tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Caldarale, Charles R" <Chuck.Caldar...@unisys.com>
Subject RE: Database connections aren't being released...
Date Thu, 06 Oct 2005 03:56:31 GMT
> From: Richard Road Runner [mailto:rjadrian@nc.rr.com] 
> Subject: Database connections aren't being released...
> 
> Over a period of time, the number of connections to the 
> database continues to increase far beyond the possible number 
> of users.

This is usually a problem in the webapp, in that some code path is
failing to close a result set, statement, or connection.  After a while,
these accumulate and you run out.  If you're using connection pooling,
you can try setting removeAbandoned="true", but that's a kludge, not a
true fix.  For more details, see:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples
-howto.html

 - 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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message