"Invalid operation: result set is closed" error with Data Server Driver for JDBC

Technote (troubleshooting)


Problem(Abstract)

After upgrading the JDBC driver from the Legacy JDBC Type 2 driver (db2java.zip) to the Data Server Driver for JDBC (db2jcc.jar) the following error now occurs "Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null"

Symptom

com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120] [10898][4.11.77] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null


Cause

The IBM Data Server Driver for JDBC and SQLJ automatically closes the cursor when all rows have been retrieved from a ResultSet. When ResultSet.next is executed after the cursor is closed the SQLException is thrown. This behavior differs from the DB2 JDBC Type 2 drive where the cursor is not automatically closed upon retrieving all rows from a ResultSet.

Resolving the problem

Modify the application code to avoid calling ResultSet.next after all rows have been retrieved.

Alternatively, it is possible to workaround the issue by enabling the allowNextOnExhaustedResultSet datasource property. With the allowNextOnExhaustedResultSet property set to DB2BaseDataSource.YES (1), and a forward-only cursor is positioned after the last row of a result set, a call to ResultSet.next returns false instead of throwing an SQLException.


For further discussion on this topic, visit this developerWorks forum thread:
https://www.ibm.com/developerworks/community/forums/html/topic?id=8426a3ac-fe02-47b7-b23a-cd7308ec2a1d

Related information

JDBC and SQLJ support has been enhanced
JDBC differences between drivers

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows
DB2 Programming Interfaces - JDBC

Software version:

9.1, 9.5, 9.7

Operating system(s):

AIX, Linux, Solaris, Windows

Software edition:

Enterprise Server Edition

Reference #:

1461670

Modified date:

2013-06-13

Translate my page

Machine Translation

Content navigation