> From: Alex Turner [mailto:[EMAIL PROTECTED] > Subject: Connection Pool Woes > > I have a server that is set to maxThreads="5", maxSpareThreads="5", > and when I use a Simply Data Source, that does not pooling, if I hit > the page a lot, I get over 30 connections opened, with database > connections that are not closing quickly at all. If this runs in > production, I'm going to run out of database connections.
This is nearly always a problem in the webapp. Make sure you explicitly close all result sets, statements, and connections in finally clauses. See the section on "Preventing dB Connection Pool Leaks" at: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.h tml You should be able to use the techniques in there to track down the problem. - 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]
