tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Sexton" <gsex...@mhsoftware.com>
Subject RE: Tracking Datasource Connection Usage?
Date Thu, 06 Oct 2005 20:27:37 GMT

http://findbugs.sourceforge.net/


Will tell you where in your code you are not freeing resources. 


George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
  

> -----Original Message-----
> From: JWM [mailto:techstuff@malcolms.com] 
> Sent: Thursday, October 06, 2005 2:09 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Tracking Datasource Connection Usage?
> 
> I started getting exceptions saying no connections were 
> available on my JDBC
> datasource  (org.gjt.mm.mysql.Driver).  The pool was 
> definitely large enough
> to handle the load.  So it appears that I'm not freeing the all the
> connections as I should.  I noticed that I did not have the
> 'removeAbandoned' flag set on the Resource tag.  Changing that has
> apparently fixed the out of connections problem.  But I 
> really want to clean
> up the code and fix it the right way.  I've got the close() 
> statements in
> place.  But obviously, I'm missing some of them somewhere.  
> Is there any
> process for logging/tracking allocating and freeing 
> connections (and absence
> thereof.), available connections, etc?  Or are there any 
> methods I can call
> to give me this type of debug info?  What's the recommended 
> way to debug
> this?
> 
> Thanks.
> 
> JWM
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 


---------------------------------------------------------------------
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