Java Database Connectivity (JDBC)

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