checking health of connection pool

[satish bodas]

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]

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]

Thanks Jaikiran for the help .

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

Regards,
~satish