wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes checking health of connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "checking health of connection pool " Watch "checking health of connection pool " New topic
Author

checking health of connection pool

satish bodas
Ranch Hand

Joined: Jun 19, 2008
Posts: 116
Hello ,
Have set up a Datasource in Jboss .

Wanted to know if there is any way to check the health of the connection pool ?

Option a >
Any admin interface which specifies no of connections in use / no free

( Have faced issues in other projects ( using ATG server ) where poor code was causing connection leaks - but there was no GUI to show the status / health

Option b >
Is there any way programmatically that I can set a threshhold limit and raise an alarm email once that min limit is reached ?

Thanks ,
~satish
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9955
    
163

Originally posted by satish bodas:


Option a >
Any admin interface which specifies no of connections in use / no free


Yes.

- Access http://localhost:8080/jmx-console.
- Under jboss.jca section look for name=XXX,service=ManagedConnectionPool (where XXX is the jndi-name of your datasource).
- Click on that link
- The next page will display the connection pool statistics.

Originally posted by satish bodas:
( Have faced issues in other projects ( using ATG server ) where poor code was causing connection leaks


Connections can be tracked. See this


[My Blog] [JavaRanch Journal]
satish bodas
Ranch Hand

Joined: Jun 19, 2008
Posts: 116
Thanks Jaikiran for the help .

I am now able to see the admin console which shows the health of the connection pool .

Regards,
~satish
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: checking health of connection pool
 
Similar Threads
Connection Pool Problem in weblogic 9.2 MP3
long post IBM.158
connection validation when db is down
connection validation and connection close method in connection pooling when DB is down
Checking Connection Pool Size