Result set not returning values

[karthikeyan_raju]

hi all,
i have a paculiar prob in my code..

i have a method that has the DB connection param.. connects to the DB.. retrieves data and sends it across..

All connection parameters are correct
Data is available in the table
Data is retrieved when the statement is run on DB client pl sql editor.

but rs.next() returns false

what could be the issue ???

below is the code..

public void getEventKeys() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
// This is format for below string
// jdbc:oracle:thin:@//host:port/service
String url = "jdbc:oracle:thin:@//cola094-vip:1521/XRDEV";
// username: scott
// password: tiger
Connection conn = DriverManager.getConnection(url,"scott", "tiger");
conn.setAutoCommit(true);
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select my_key from my_trigger");
while (rset.next()) {
System.out.println ("There is data!");
}
stmt.close();
}
catch (Exception e) {
System.out.println (e.getMessage());
}

[mrmatt1111]

Does your code throw an exception?

If the query executes without exception it can only be assumed that "my_trigger" contains no rows. You might want to check that it has rows first.

Edit: you might want to put in a message somewhere in getEventKeys() to verify that you are actually making the call to that method.

[karthikeyan_raju]

i ran the code in debug mode.. everything seems fine.. only thing is that the resultset.next is not returning true.. and yes data is there in thaat table...

[masijade]

Well, there's nothing wrong with that code (other than the fact that you are not closing the resultset or the connection, and that, as well as the statement close, should be taking place in a finally block).

So, when you check that the "table exists" and "has rows", are you using the same user and password you are there (different users have different rights) and are you connecting to the same IP, port, and SID. Stupid questions, but they need to be asked because the Orcale driver does not simply ignore them.

If the answers to those questions are yes, then find an Oracle DB forum, as the problem is with the Driver and not with either Java or JDBC.

[netrista]

Do you have the ability to perform comparative tests with a 3rd-party JDBC driver? If not, can you enable JDBC tracing against your current JDBC driver to determine why the rs.next() function call is failing?

Best regards,
Netrista Khatam
Tech Services Manager
OpenLink Product Support

[ganapathyvj]

Hi Karthikeyan

Were you able to resolve this issue at all? I've the exact problem and don't know where the problem lies.

Thanks
Ganapathy