[jboss-user] [JCA] New message: "Re: How best to handle DB failover?"

Vicky Kak do-not-reply at jboss.com
Mon Mar 1 12:40:57 EST 2010

User development,

A new message was posted in the thread "How best to handle DB failover?":


Author  : Vicky Kak
Profile : http://community.jboss.org/people/vickyk

> mcevikce wrote:
> But even with <check-valid-connection-sql> defined, my old connections are still there. I would expect all of the old connections to be recycled but thats not the case.
> Is there a way to clear all the connections in my datasource and recreate them with new URL?
Actually you are not using ha datasource, it seems the URL gets changed on the fly.
The DB connections available in the pool are alive, the check-valid-connection when called will basically take longer time since the DB is locked, it is not closed/shutdown. If it would have been closed/shutdown I would have recommended you to try <use-fast-fail> as mentioned here
In your case I would suggest you to write a custom MBean which will flush the pool by invoking flush() operation on one of the JCA infrastructure MBeans, check jboss.jca:* Mbeans ( ManagedConnectionPool::flush()).


To reply to this message visit the message page: http://community.jboss.org/message/529175#529175

More information about the jboss-user mailing list