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:[EMAIL PROTECTED] > Sent: Thursday, October 06, 2005 2:09 PM > To: [email protected] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
