Application crashes when getting string from a closed resultset

Former Member — Thu, 11 Oct 2012 12:47:49 GMT

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.

Re: Application crashes when getting string from a closed resultset

Former Member — Thu, 11 Oct 2012 13:34:13 GMT

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.

Question Re: Application crashes when getting string from a closed resultset in Technology Q&A

Application crashes when getting string from a closed resultset

Re: Application crashes when getting string from a closed resultset