JDBC question

We're having a problem with open cursors (too many of them). It sure looks like we're closing everything. However, I noticed one thing that looked strange, although I doubt that it would cause a cursor to remain open:

Statement stmt = (blah);
ResultSet rs = stmt.(blah);

(...)

stmt.close();
rs.close();

What does it mean to close the ResultSet after the Statement has been closed? I thought it automatically got closed when its Statement got closed.

Again, I doubt this is the problem, but could it be? Maybe something like the servlet knows, during the stmt.close(), that it has to retain info about rs, since a reference to rs is coming up, but then when it gets to the rs.close(), it can't actually do that, since the applicable Statement is now gone?

Thanks,

Bob Vesterman. Received on Mon Oct 30 2000 - 16:39:33 CST