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.
