Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
From: "George Sexton" <gsexton@mhsoftware.com>
To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
Subject: RE: Tracking Datasource Connection Usage?
Date: Thu, 6 Oct 2005 14:27:37 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-Reply-To: <001301c5cab1$d502a670$0d3f2909@jmalcolmt40>
Thread-Index: AcXKsfbismCmKwM8S/6oIOujMcEXJgAAlsvw
Message-Id: <20051006202749.8A2C6324C8@mail.mhsoftware.com>


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