[jboss-user] [JCA/JBoss] - Re: please help mysql datasource timeout problem

[vickyk]

 MySQL closes connections after 8 hours of inactivity. You either need to use a connection pool that handles stale connections or use the "autoReconnect" parameter
For more details read here 
http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-troubleshooting.html#qandaitem-24-3-5-3-4

Configure check-valid-connection in the -ds.xml file . For more details please refer here 
http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossJCADatabaseFailover


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

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