executeQuery() doesnt return any rows and the same statement returns row in sqlplus

Question

I have used the select statement to get a record from sqlplus and the statement returned a row but when i use executeQuery() method in java it does not return any rows in resultset.

Class.forName("oracle.jdbc.driver.OracleDriver");  
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@LocalHost:1521:orcl","sys as sysdba","System_1");                                                                               
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);  
Resultset rs=stmt.executeQuery("SELECT * from server WHERE username='admin'");

p.s. :-I'm using oracle 12c

Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@LocalHost:1521:orcl","sys as sysdba","System_1"); Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery("SELECT * from server WHERE username='admin'"); — , Mar 06 '17 at 17:18
Put you code in try catch block and look for exceptions. Or debug after creating connection. — Atul, Mar 06 '17 at 17:23
Please show some code how you process the result set, the comment on one of the answers suggests that you misunderstand what [`ResultSet.getRow()`](https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSet.html#getRow--) returns (hint: it is not the total number of rows...) — Mark Rotteveel, Mar 06 '17 at 20:44

score -2 · Answer 1 · answered Mar 06 '17 at 20:45

-2

Try using LIKE keyword instead of =.

answered Mar 06 '17 at 20:45

staszko032

802
6
16

If `column LIKE 'admin'` would work, then so will `column = 'admin'` – Mark Rotteveel Mar 06 '17 at 20:47
@staszko032 refer http://stackoverflow.com/questions/543580/equals-vs-like to know the difference between like and = – Atul Mar 06 '17 at 22:22

executeQuery() doesnt return any rows and the same statement returns row in sqlplus

1 Answers1