Exhausted Resultset Exception

[Andy Smith]

Hello,

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


java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:170)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:212)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:275)
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatemen
t.java:2693)
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.jav
a:2828)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.
java:307)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:137

[Sol Mayer-Orn]

Could it be that you closed your result set , or your statement ?

See example:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#07_01