Connection Pool Question JBoss 4.2.x

[chipschoch]

I would like to implement the connection pool interface to wrap the current connection pool implementation in order get better logging. This is driven by deficiencies in the DBMS (Sybase) auditing features. Can anyone point me to where I can find information on where to start. For instance, where is the connection manager MBean deployment configured, etc;?

Thanks

[peterj]

If all you want is better logging, why not use something like log4jdbc? http://code.google.com/p/log4jdbc/

[chipschoch]

Thanks. This looks pretty interesting. However, we are trying to track down an issue where we are getting too many connections opened. We want to log when gets and puts to the connection pool happen.

[peterj]

The connection pool mbean is generated automatically when the *-ds.xml file is parsed, so you might be better off modifying the existing one than trying to wrap or replace it. I think that the connection pool manager is in the source at connector/src/main/org\jboss/resource/connectionmanager/InternalManagedConnectionPool.java (this is a guess, the actual connector is hidden behind an interface - see the poolingStrategy field in the JBossManagedConnectionPool class in the same directory.


Alternately, you could turn on TRACE level logging for the InternalManagedConnectionPool class, it seems to do some logging regarding connection requests at that level.