Geek Answers Handbook

How to view / control database connections in a database?

We use the database connection pool for our java application. This is a web application running tomcat.

I want to view live connections in a pool as they are created and destroyed. Can anybody help?

UPDATE: we are using Oracle 11g. We use the DDConnectionBroker library to pool pools.

+4
source share
2 answers

I'm not sure if there is a connection monitoring API in the DDConnectionBroker library ... I would recommend Proxool if you want more transparency.

http://proxool.sourceforge.net/

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

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

0
source

I was also looking for this problem and could put together what I need:

org.apache.commons.dbcp.BasicDataSource

If you use Spring , it is so easy to enter this information on your bean and return what you need from this object, which must be entered and already created for you.

All questions let me know!

0
source

More articles:


All Articles