wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes Monitor DB Connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Monitor DB Connections" Watch "Monitor DB Connections" New topic
Author

Monitor DB Connections

Srinivas Katta
Ranch Hand

Joined: Feb 01, 2007
Posts: 76
Hi All,

Is there any Way to Monitor DB Connection Pool usages while JBoss is running with Oracle DB using jmx-console, Can some one explain if this is Possible.

Thanks
Srinivas
Ravish Mody
Greenhorn

Joined: Mar 30, 2011
Posts: 7

Hi Srinivas,

Yes, you can monitor the connection pool usage from the JMX console, following is the JMX console path

jboss.jca -> name=<YOUR_DS_NAME>,service=ManagedConnectionPool

It would show you details like AvailableConnectionCount, ConnectionCreatedCount, InUseConnectionCount etc


Regards,

Ravish Mody
http://middlewaremagic.com/weblogic
Come, Join Us and Experience The Magic…
Srinivas Katta
Ranch Hand

Joined: Feb 01, 2007
Posts: 76
Thank you for the Response

We have the Server configured in Cluster mode, Is there any way to access jmx-console

When I tried with <Domain name>/jmx-console it i snot accessible

Thanks
Srinivas
Ravish Mody
Greenhorn

Joined: Mar 30, 2011
Posts: 7

HI Srinivas,

JMX console shows details about only 1 server at a time, however if you have servers running in cluster then you have to open that number of JMX consoles say you have two servers running in a cluster all_node1 running on port 8180 and all_node2 running on port 8280 then the URL for them would be like as follows

all_node1
http://localhost:8180/jmx-console/

all_node2
http://localhost:8280/jmx-console/

However if you need only one console to monitor all the nodes then JON which is JBoss Operations Network would be the best options for you.
Srinivas Katta
Ranch Hand

Joined: Feb 01, 2007
Posts: 76
Thank You, I will Check this
 
Consider Paul's rocket mass heater.
 
subject: Monitor DB Connections
 
Similar Threads
Weblogic Connection Pool Issue
WA #1.....word association
problem with preparedStatement with SQL Server 2000
monitoring JDBC
monitoring sql's using JAMon