I have a situation that some ResultSets are created by a connection. At a given time, the connection is finalized and closed. The application crashes when I tries to access one these ResultSets (to get some information. e.g. getString(String name)), without "telling" us that it has been closed.
Is there any way to know whether a ResultSet has been closed? Besides that, I believe that right behavior would be throw an exception whenever an invalid ResulSet be accessed.
A similiar situation is described here: http://sqlanywhere-forum.sap.com/questions/9635/application-crashes-when-closing-a-preparedstatement.
I'm using ultraliteJ for Android version 12.0.1 build 3726.
Thank you for the bug report. We should be able to reproduce the bug given this information.
As a workaround, I would suggest that you check the Connection that owns the ResultSet to see if it is open. If the Connection is not open, then do not use the ResultSet.
answered 11 Oct '12, 13:34