What is meant by exhausted result set?
This error is caused when we are executing JDBC-ODBC connection programs in java.
After executing SQL query in java we store the records retrieved in a ResultSet object.
We need to iterate over the records in the ResultSet to fetch each record values and do necessary operations further.
we use resultSet.next() method to move to next record in while loop.
So , if the result set is null then “exhaustedresultset ” error arises.
or when we are trying to access records even after reading all records in resultset without setting a stop condition when the resultset.next() is null. then the “ExhaustedResultSet” may arise implying no records to process further.