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