logging with org.apache.commons.dbcp.BasicDataSource

[PretzelLogic]

Hello,

Does anyone know how I get connection pool info in my log file (log4j)? I'm using apache dbcp Basic DataSource and I'm interested in seeing the pool size and when/if a connection is returned to the pool.

cheers.

[PretzelLogic]

Anyone have a suggestion ?

cheers

[PretzelLogic]

Looking for some help with this again...

[denis.zhdanov]

You can look through dbcp and commons-pool source and check that they don't use logging. The only you can do is to use standard jdbc logging facilities via BasicDataSource.setLogWriter() and implement a custom wrapper that is able to provide you current pool state (like the one mentioned here).