java.sql.SQLException: Exhausted Resultset

Question

I get the error java.sql.SQLException: Exhausted ResultSet to run a query against an Oracle database. The connection is via a connection pool defined in Websphere. The code executed is as follows:

if (rs! = null) (     while (rs.next ()) (         count = rs.getInt (1);     ) ) 

I note that the resultset contains data (rs.next ())

Thanks

Answer 1

I've seen this error while trying to access a column value after processing the resultset.

if (rs != null) {   while (rs.next()) {     count = rs.getInt(1);   }   count = rs.getInt(1); //this will throw Exhausted resultset } 

Hope this will help you :)

Answer 2

Try this:

if (rs != null && rs.first()) {     do {         count = rs.getInt(1);     } while (rs.next()); }