File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Exhausted Resultset Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exhausted Resultset Exception" Watch "Exhausted Resultset Exception" New topic

Exhausted Resultset Exception

Andy Smith
Ranch Hand

Joined: Sep 28, 2003
Posts: 239

I am getting the below mentioned exception, any one having any idea ?

java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatemen
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.jav
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.
at oracle.jdbc.driver.OracleResultSet.getString(

Share Knowledge to gain it.
SCJP 2, SCWCD 2, SCDJWS, IBM 141 (In Progress), IBM 486 (Next)
Sol Mayer-Orn
Ranch Hand

Joined: Nov 13, 2002
Posts: 311
Could it be that you closed your result set , or your statement ?

See example:
I agree. Here's the link:
subject: Exhausted Resultset Exception