[jboss-user] [JCA/JBoss] - Re: datasources auto-reset conection on database fails?

vickyk do-not-reply at jboss.com
Mon Jan 22 05:54:47 EST 2007

Looks like you need to configure check-valid-connection in -ds.xml file .

It is explained here 
<check-valid-connection-sql> - an sql statement that is executed before it is checked out from the pool to make sure it is still valid. If the sql fails, the connection is closed and new ones created.
For more details please refer to the following link I have pulled the above contents from here

I hope this is what you have been asking  for .

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4004776#4004776

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4004776

More information about the jboss-user mailing list