Result Set Is Closed. Find below the trace. The following exception can occur while processing a result set.
When ResultSetnext is executed after the cursor is closed the SQLException is thrown. Hi The problem i am facing is the exception saying Result Set is Closed in java. The following example demonstrates the ResultSet class.
We have Oracle 10g and using oracle_jdbcjar and jboss 422 version.
This behavior differs from the DB2 JDBC Type 2 drive where the cursor is not automatically closed upon retrieving all rows from a ResultSet. This will close the ResultSet as well. This ResultSet is closed. Its the stmntclose that is the problem.