db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Cursors
Date Wed, 13 Jul 2005 14:48:38 GMT
simmi iyer wrote:

> Using network client driver to connect to network
> server.
> 
> Using java threads to run parallel selects. RAM used
> goes up and after some time Network server throws "Out
> of Memory" error.
> 
> Obviously the cursors at database end are not getting
> closed when ResultSet is closed at the client end java
> code.
> 
> I understand from Derby docs that cursors by default
> get closed when  a commit is done on connection. Is
> there any other way of closing the database cursors?

Maybe I'm not understanding what exactly you mean, but can you just call
the close method? java.sql.ResultSet.close().

Dan.


Mime
View raw message