Chuck makes a good point about the overhead of the finalize() method. I think the problem was however not with open result sets and statements but with a connection itself. Using a finally clause to ensure that result sets and statements are closed is a must but it the intention is to persist an open database connection, finally will not help.
Perhaps a Session Listener would solve the problem. Earnie! -----Original Message----- From: Caldarale, Charles R [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 10:01 AM To: Tomcat Users List Subject: RE: Time out on sessions with AJP13 > From: Earnie Dyke [mailto:[EMAIL PROTECTED] > Subject: RE: Time out on sessions with AJP13 > > You should consider implementing the finalize() method in > your session bean to close the connection nicely. If there's any possible way of avoiding finalize(), don't use it. The presence of a finalize() method requires special handling (much slower) during object allocation, and there's no guarantee that the method will _ever_ be called. It's a really, really bad idea. What you should be using is finally clauses for all your connection manipulation to make sure that result sets, statements, and connections are logically closed after use. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. --------------------------------------------------------------------- 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]