ConnectionContext.KEEP_CONNECTION is set when closing the connection context in a SQLJ application but continues to fail with "DSRA9110E: ResultSet is closed".
DSRA9110E: ResultSet is closed
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.