Re: not getting connection leak stacktraces

2004-07-21 Thread QM
On Tue, Jul 20, 2004 at 10:03:30PM -0400, E wrote:
: Tomcat's reporting some connection leaks in my application...but I can't 
: figure out where they're coming from.

Some quick detective work may spot the problem: set the pool's max
connections to 1, then use the app.

When you uncover all of the leaks, then set the max connections back to
normal.

-QM

-- 

software  -- http://www.brandxdev.net
tech news -- http://www.RoarNetworX.com


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



not getting connection leak stacktraces

2004-07-20 Thread E
Tomcat's reporting some connection leaks in my application...but I can't 
figure out where they're coming from. The only output i see in my logs is:
AbandonedObjectPool is used 	 
([EMAIL PROTECTED])
   LogAbandoned: true
   RemoveAbandoned: true
   RemoveAbandonedTimeout: 60

I'm running Tomcat 5.0.27, connecting to MySQL 12.22 using 
mysql-connector 3.0.11. My connection pool is setup as follows:

Resource name=jdbc/writer auth=Container 
type=javax.sql.DataSource/
ResourceParams name=jdbc/writer
parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter

parameter
namemaxActive/name
value10/value
/parameter
parameter
namemaxIdle/name
value2/value
/parameter
parameter
namemaxWait/name
value1/value
/parameter
parameter
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
nameremoveAbandonedTimeout/name
value60/value
/parameter
parameter
namelogAbandoned/name
valuetrue/value
/parameter
parameter
nameusername/name
valueXXX/value
/parameter
parameter
namepassword/name
valueXXX/value
/parameter
parameter
namedriverClassName/name
valuecom.mysql.jdbc.Driver/value
/parameter
parameter
nameurl/name
valuejdbc:mysql://localhost:3306/mydatabase?autoReconnect=true/value
/parameter
/ResourceParams
I can't see any obvious leaks in my code, so I'm completely baffled. Any 
help is appreciated.

-e
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]