For those who will find this topic as answer to mysql "connection reset" search query. The problem has been solved too.
Connection have had been really closed by mysql. It was and is set up with WAIT_TIMEOUT less than 1 minute (I guess that admin had tried to minimize connection leaks for php ?) I have changed connection string in -ds.xml file to jdbc:mysql://spinity.com:3306/java?autoReconnectForPools=true&sessionVariables=wait_timeout=28800 (don't forget to mark the string as CDATA) note sessionVariables=wait_timeout=28800 I'm not sure that autoReconnectForPools is a good idea. Useful links http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource (here stated that autoReconnect is not a good idea, but nothing about autoReconnectForPools). View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926780#3926780 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926780 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
