Application crashes when getting string from a closed resultset

[Former Member]

Hi everyone,

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.

[Former Member]

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.