finding a resource leak commons.dbcp

[Paul Danese]

Hi,

I’m running a struts application using the
commons.dbcp BasicDataSource as part of a connection
pool for interacting with a MySQL database.

I *think* my application has a pool ‘leak’ in that it
will periodically ‘hang’ until I re-start the server,
but I’m not positive about this explanation.

Questions:
1.      are there any other (obvious) possible explanations
for periodic haning of a struts application?  I say
this b/c I’ve looked at the code and it looks to my
untrained eye that I’m closing all database
connections.
2.      Is there a simple way to monitor the # of live
connections that my pool has ‘handed out’?  in looking
at the api for commons.dbcp, I notice that
BasicDataSource has a field called connectionPool,
which is of the type, GenericObjectPool. 
GenericObjectPool itself has methods called
getNumActive and getNumIdle, but I can’t seem to
figure out how to get to them.

Thanks for any info!



                
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

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