there is any way to use a CachedRowSet or similar on Android? I'd like to save my ResultSet's values into any object independent of the Statement, and then close my Statement without losing the information that I've retrieved.
I'm using jdbc MySQL 5.1.27 connector.
Thanks in advance.
My main problem is that in some methods I'm getting various ResultSets and while I'm working with them I can see how my tablet is working slower. I want to close every Statement I've opened and keep working with the ResultSets, but the problem is that the ResultSets are dependant of the Statemenents, so if I close the Statement, I'm losing my ResultSet.
I want to use something like 'CachedRowSet', what is supossed to work like a ResultSet but without having to stay connected to the database.
I use JDBC cause the app works in closed networks, retrieving information directly from the server.