• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

Monitor DB Connections

 
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 7
Oracle Redhat Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Srinivas Katta
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 7
Oracle Redhat Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank You, I will Check this
 
No holds barred. And no bars holed. Except this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic