No, you should invoke .close() on your resultset and statement object. Setting to null is also a good idea, but not as important as closing the objects.
- Andrew > -----Original Message----- > From: Short, Dave [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 27, 2002 12:09 PM > To: 'Tomcat Users List' > Subject: RE: Does closing a Connection variable and setting > it to null close all of the ResultSet and Statements? > > > By closing you mean set the ResultSet and Statement objects > to null - correct? > > -----Original Message----- > From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]] > Sent: August 27, 2002 9:06 AM > To: Tomcat Users List > Subject: Re: Does closing a Connection variable and setting > it to null close all of the ResultSet and Statements? > > > > > On Tue, 27 Aug 2002, Tim Funk wrote: > > > Date: Tue, 27 Aug 2002 12:03:18 -0400 > > From: Tim Funk <[EMAIL PROTECTED]> > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > To: Tomcat Users List <[EMAIL PROTECTED]> > > Subject: Re: Does closing a Connection variable and setting > it to null > > close all of the ResultSet and Statements? > > > > It is not requried to close ResultSets, Statements, etc if > you close > > the connection. (I think) The spec says if you close a connection - > > all associated resources for that connection will also be closed. > > > > That's what the spec says, but relying on it is being awfully > trusting of JDBC driver developers to do the right thing. A > little paranoia here (i.e. close the result sets and > statements yourself) goes a long way towards making your apps > more reliable. > > Craig > > > > If you are using a pool - the pool manager *should* be obeying this > > principal too. > > > > Michael Nicholson wrote: > > > Well, I guess the subject line says it all. I'm having memory > > > issues, > and having read the OOM error messages on the list, I've > checked and found some open and not being closed connections, > so I'm going back and closing them all. The question is do I > need to explicitly close/dereference (set to > null) all statements and recordsets too? Right now the > system takes about 4% of my available memory just for the > beans in question, so I'm trying to minimize what I store so > that I could conceptually have more than one user. > > > > > > Thanks in advance, > > > Mike Nicholson > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > > > -- > To unsubscribe, e-mail: > <mailto:tomcat-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:tomcat-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>