Hi all,

I am connecting to DB2 8.1 on Solaris through JDBC using type 4 drivers (driver: com.ibm.db2.jcc.DB2Driver). Problem is that when a cursored query is done, the resultset gets closed after commit (resultset.next() throws SqlException "Invalid operation: result set closed").

Is there a way to tell DB2 not to close the resultset/cursor?

I am on JDK 1.3, so I am not able to use Resultset.HOLD_CURSORS_OVER_COMMIT which got introduced in JDK 1.4.

Is there any other way out?