I'm most certain the connections are closed but there may be a few dangling statements. I'm using mysql jdbc. Not using pools since I never could get it working. Making direct requests.
Still getting a out of memory hit every couple of days so I have to shutdown the server and start it up again. THnak,s Jim. "Shapira, Yoav" wrote: > > Howdy, > You don't have to close a result set if you're closing the statement > right away and the result set is the only one associated with the > statement... And in no case can closing the result set explicitly hurt > performance. > > Yoav Shapira > Millennium ChemInformatics > > >-----Original Message----- > >From: Greg Ward [mailto:[EMAIL PROTECTED] > >Sent: Thursday, September 04, 2003 10:05 AM > >To: Tomcat Users List; [EMAIL PROTECTED] > >Subject: Re: Memory leaks? > > > >On 03 September 2003, Jim Lynch said: > >> OK, that's probably what's going on. I know I should close > Statements > >> and Connections and do normally but I'm fairly certain I've some out > >> there dangling. I didn't know you had to close ResultSets, however. > >> Glad to know that. > > > >You don't have to close ResultSets -- check the JDBC docs: > > > > > http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#close() > > > >(Closing a Statement also closes any open ResultSets associated with > >that Statement.) > > > > Greg > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > This e-mail, including any attachments, is a confidential business communication, > and may contain information that is confidential, proprietary and/or privileged. > This e-mail is intended only for the individual(s) to whom it is addressed, and may > not be saved, copied, printed, disclosed or used by anyone else. If you are not > the(an) intended recipient, please immediately delete this e-mail from your computer > system and notify the sender. Thank you. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]