Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exhausted Resultset error

843859Apr 2 2009 — edited Apr 3 2009
Greetings,
i having this application and it has been running for 4 years. This is the first time the system encountered this error, exhausted resultset I'm using Oracle database for storing of the data.

This is a snippet if the codes for retrieve the results from the database:
while (rset.next()) {
                      newHypeRec = new LogicalResponse();
                      newHypeRec.setAnswer(rset.getString("ANSWER"));
                      newHypeRec.setTextAnswer(rset.getString("TEXT_ANSWER"));
                      newHypeRec.setChoiceAnswer(rset.getString("CHOICE_ANSWER"));
                      newHypeRec.setListAnswer(rset.getString("LIST_ANSWER"));
                       newHypeRec.setCheckAnswer(rset.getString("CHECK_ANSWER"));
          
                     attemptLogicalResponseList.addElement(newLogicalRec); 
        	 }
I have google online that if the coding is imperfect, there is a chance to hit the exhausted resultset error. However, the application is using the while loop to check if the are results.

I have another conclusion that the java memory has run out in the server. Can this be the case to hit this error?
Or is it because there is a way to set the number of resultsets?
Or it is oracle can control the number of result sets?
I like to seek views based on what scanarios that the application will hit this error? Feel free to list your views

And lastly, how can i solve this error or if anyone has encounter this error and manage to solve it?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2009
Added on Apr 2 2009
3 comments
412 views