We often have the problem that we have to restart a JBoss instance (or profile, if you want to call that) after the underlying DBMS is restarted. This probably has to do with the application code, but I wonder: Is there a way to restart a certain JBoss JDBC Connection pool after regaining connection with the underlying database. Something like this:
Provide a monitoring service which marks the datapool unhealthy when the connections are gone.
After marking a pool unhealthy, check at a certain interval if a connection can be made.
After 2 is a success, restart the JDBC Connection pool such that the application can use it again.
My questions are:
Is this been done yet (in JBoss-AS 5, 6, but if it is integrated in 7, I like to know that too) ?