You can also play with the more generic:
!-- sql to call on an existing pooled connection when it is obtained from pool --
| check-valid-connection-sqlSELECT 1/check-valid-connection-sql
|
View the original post :
Thx guys this helped me out with my problem ! And goran: Where do I put this
check-valid-connection-sql ? In the login.config.xml, the part of my webapp ? Or in
the datasource ?
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838257#3838257
Reply to the post
In the datasource.
/G
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=3838265#3838265
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3838265
---
This SF.Net email is
You need to change your connection in your datasource. You need to add the attribute
autoReconnect=true to your connection, e.g.
connection-urljdbc:mysql://localhost:3306/multimedia?autoReconnect=true/connection-url
View the original post :