How to view/monitor live database connections in a database pool?

Question

We use database connection pooling for our java application. It is a web app run under tomcat.

I want to view live connections in the pool as they are created and destroyed. Can somebody please help?

UPDATE: We are using Oracle 11g. We use DDConnectionBroker library for connection pooling.

Hi user32262 did you solve your problem? I need the same information. Start to dig on stackoverflow but no success. — rafa.ferreira, Mar 22 '11 at 12:12
Do you want to monitor the number of threads that are waiting for a connection to become available? If yes, a DDConnectionBroker-specific tool is needed. — Nicolas Raoul, Aug 02 '12 at 08:28
@user32262 Did you mean "DbConnectionBroker"? at http://javaexchange.com — Nicolas Raoul, Aug 02 '12 at 08:37

score 0 · Answer 1 · answered Oct 18 '10 at 19:51

I am not sure if there are any connection monitoring API's in DDConnectionBroker library... I would recommend Proxool if you want more transparency.

http://proxool.sourceforge.net/

Also check out DBCP and CP30, DBCP is the best in the bucket

http://www.java2s.com/Product/Java/Database/Connection-Pool.htm

score 0 · Answer 2 · answered Mar 22 '11 at 13:35

0

I was searching for this issue too and could collect what I need from:

org.apache.commons.dbcp.BasicDataSource

If you are using Spring is so easy to inject this information on your bean and retreive what you need from this object, that shall came injected and already instantiated for you.

Any questions let me know!

answered Mar 22 '11 at 13:35

rafa.ferreira

1,997
7
26
41

1

The question is about DbConnectionBroker, not Commons DBCP. – Nicolas Raoul Aug 02 '12 at 08:38

How to view/monitor live database connections in a database pool?

2 Answers2