• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

checking health of connection pool

 
satish bodas
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
satish bodas
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jaikiran for the help .

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

Regards,
~satish
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic