wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes How To Solve : java.sql.SQLException: Exhausted Resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How To Solve : java.sql.SQLException: Exhausted Resultset" Watch "How To Solve : java.sql.SQLException: Exhausted Resultset" New topic

How To Solve : java.sql.SQLException: Exhausted Resultset

kayanaat sidiqui
Ranch Hand

Joined: Sep 04, 2008
Posts: 122

I have written a piece of code where i got this exception--

Exception in thread "main" java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:490)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:857)

The code is written in this fashion--

Even though i tried with making rs1 and cs1 null and used it inplace of rest cs and rs.

But again got the same exception.

Could you please help me out?

Kalabaw moo
Ranch Hand

Joined: May 26, 2009
Posts: 61
rs.next() or rs1.next()?

Edit: should you put a try...catch block for the ResultSet?
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 44006
Moving to JDBC forum.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: How To Solve : java.sql.SQLException: Exhausted Resultset
It's not a secret anymore!