ConnectionContext.KEEP_CONNECTION is set when closing the connection context in a SQLJ application but continues to fail with "DSRA9110E: ResultSet is closed".

Technote (troubleshooting)


Problem(Abstract)

ConnectionContext.KEEP_CONNECTION is set when closing the connection context in a SQLJ application but continues to fail with "DSRA9110E: ResultSet is closed".

Symptom

DSRA9110E: ResultSet is closed


Cause

Closing the ConnectionContext with or without closing the connection results in releasing the resources associated with the ConnectionContext. This includes all associated PreparedStatements on the ConnectedProfile and consequently the associated ResultSets.

Diagnosing the problem

Review the application logic to determine if connections are being closed prior to accessing the resultset.

Resolving the problem

The IBM Data Server Driver for JDBC and SQLJC does not support a persistent resultset after the connection has been closed. Review and correct the application logic to close the connection once finished using the resultset.

Rate this page:

(0 users)Average rating

Document information


More support for:

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

Software version:

9.1, 9.5, 9.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1461696

Modified date:

2013-04-21

Translate my page

Machine Translation

Content navigation