Bug 47235

Summary: MySQL example should *not* include usage of the autoReconnect flag
Product: Tomcat 6 Reporter: Eric DeCosta <edecosta>
Component: DocumentationAssignee: Tomcat Developers Mailing List <dev>
Status: RESOLVED FIXED    
Severity: normal CC: reno.rkcrew
Priority: P2    
Version: unspecified   
Target Milestone: default   
Hardware: PC   
OS: Windows XP   
URL: http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html

Description Eric DeCosta 2009-05-21 07:47:38 UTC
See: http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html

"...The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications do not handle SQLExceptions properly, and is only designed to be used when you are unable to configure your application to handle SQLExceptions resulting from dead and stale connections properly..."
Comment 1 Mark Thomas 2009-05-25 03:18:44 UTC
Thanks for the report. This has been fixed in trunk, 6.0.x, 5.5.x and 4.1.x and will be included in 6.0.21, 5.5.28 and 4.1.40 respectively.
Comment 2 Mark Thomas 2009-11-03 16:27:46 UTC
*** Bug 48080 has been marked as a duplicate of this bug. ***