How do you reset all connections following Database Outage

[mitchelln]

Hi All

Is there a way to reset all database connections if there has been an outage.

I know I could use <check-valid-connection-sql/> in the ds file which will reset them individually but we cannot afford the overhead to run a simple query for every connection request even if its super lightweight.

Obviously our database's are monitored so we will know of an outage when it occurs but is there a way to programmitically cleanup all the connections.

Any help would be welcomed even if its to point me in the direction of the right documentation to read.


Cheers




Neil

[skondam]

You can restart the Connection pool using JMX Console. First invoke destroy and then create.
The below URL may work with your server-name, port and POOLNAME
http://<<server-name:port>>/jmx-console/HtmlAdaptor?action=inspectMBean&name=jboss.jca%3Aservice%3DManagedConnectionPool%2Cname%3D<<POOLNAME>>

[adrian.brock]

Or just invoke "flush"