https://issues.apache.org/bugzilla/show_bug.cgi?id=48080
Summary: Tomcat documentation and JDBC context
Product: Tomcat 6
Version: unspecified
Platform: Other
OS/Version: other
Status: NEW
Severity: minor
Priority: P2
Component: Documentation
AssignedTo: dev@tomcat.apache.org
ReportedBy: reno.rkc...@free.fr
In the Tomcat documentation for JDBC [1], you give an example of resource
definition with the mysql option "autoReconnect=true".
Will it be possible to remove or specified in the tomcat documentation that the
autoreconnect option for the jdbc context definition is not recommended by
Mysql [2] and that it could be better to use the validationQuery parameter[3]
in the
context definition. I saw this exception arrived 2 times (in 2 differents
projects and replacing the option by validationQuery solved the problem).
I suppose that the Tomcat documentation is followed by thousand of people
(newcomers and others) so they will use the standard tomcat sample (with the
autoReconnect option) and won't be aware that this option is not recommended.
I set a "minor" severity but it may be "trivial", i don't know.
[1]:http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
[2]:http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
[3]:http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org
