java.net Forums : Monitor active connections in a JDBC ...

Home » java.net Forums » GlassFish » GlassFish

Thread: Monitor active connections in a JDBC pool over time - possible?

Welcome, Guest

Guest Settings

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 2 - Last Post: Oct 31, 2008 1:01 AM by: sm157516

jsl123

Posts: 95

Monitor active connections in a JDBC pool over time - possible?
Posted: Oct 30, 2008 1:30 AM

Hi, is there an (easy) way to monitor the number of active connections in a database pool over time. I'm often in a situation where i've run out of available connections in the pool. I've tried increasing the max number but without success. So would like to monitor them over time to see if i can spot any pattern and work out what is either using them all, or not freeing them up

Any ideas

Thanks

stephenmearl

Posts: 1

Re: Monitor active connections in a JDBC pool over time - possible?
Posted: Oct 30, 2008 9:22 AM

in response to: jsl123

Are you using any type of application server?

sm157516

Posts: 182

Re: Monitor active connections in a JDBC pool over time - possible?
Posted: Oct 31, 2008 1:01 AM

in response to: jsl123

If you are using glassfish, there is a neat way of doing this. I have explained it here : http://blogs.sun.com/technical/entry/jdbc_pool_monitoring_using_management . The attributes that can be monitored are at http://blogs.sun.com/JagadishPrasath/entry/monitoring_jdbc_connection_pool_glassfish .

Back to Thread List