Hi,
Do you know how I can monitor database connections in a database pool.. ? I am using Jboss container.
The purpose is to monitor connections that are closed and refresh them.
There a firewall.. across which my application makes connections to the database.. the firewall times out due to the inactivity. and my application dies.
I was thinking may be I could check for the database connections in a pool and then one that is not being used for a long time .. close it and again refresh the connection.
Please Advise...
you can add an entry to the datasource that will check the validity of a sql connection when it is pulled from the pool (use a simple, low overhead sql select).
<check-valid-connection-sql>SELECT ...</check-valid-connection-sql>