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
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...