File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 9329
    
110

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 validation when db is down
long post IBM.158
Connection Pool Problem in weblogic 9.2 MP3
Checking Connection Pool Size
connection validation and connection close method in connection pooling when DB is down