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

[kayanaat sidiqui]

Hi,

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--

  private void meth(Connection conn) {

 
   CallableStatement cs1 = con.prepareCall(query1);
   ResultSet rs1= cs1.executeQuery();

   while (rs.next()) {
     
        CallableStatement cs2= con.prepareCall(query2);
        ResultSet rs2 = cs2.executeQuery();
	rs2.next();
     
        if (condition) {
	   CallableStatement cs3= con.prepareCall(query3);
           ResultSet rs3 = cs3.executeQuery();
	   rs3.next();

		if (condition) {
		   CallableStatement cs4= con.prepareCall(query4);
        	   ResultSet rs4 = cs4.executeQuery();
		   rs4.next();

			if (condition) {
		   		CallableStatement cs5 = con.prepareCall(query5);
        	 	        ResultSet rs5 = cs5.executeQuery();
		  	        rs5.next();
				rs5.close();
				cs5.close();
                	}
			rs4.close();
			cs4.close();
                }
		rs3.close();
		cs3.close();
        }
	rs2.close();
	cs2.close();
  }
  rs1.close();
  cs1.close();
}  

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?

Thanks,
Kaya.

[Kalabaw moo]

rs.next() or rs1.next()?

while (rs.next()) {  

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

[Campbell Ritchie]

Moving to JDBC forum.