File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes View open db connections.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "View open db connections.." Watch "View open db connections.." New topic

View open db connections..

Neha Mohit
Ranch Hand

Joined: Apr 25, 2006
Posts: 87
Hi all,

Can we see open db connections in jboss web-console.

Thanks in advance
Peter Johnson

Joined: May 14, 2008
Posts: 5823

I don't know about web-console (it has not been working in the latest releases), but using jmx-console, in the jboss.jca:name=XXX,service=ManagedConnectionPool MBean (where XXX is the datasource name), you can find these attributes:

ConnectionCount - current number of connection to the database
InUseConnectionCount - the number of those connections that are active (in use by some app)

and various other counts.

JBoss In Action
It is sorta covered in the JavaRanch Style Guide.
subject: View open db connections..