tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AD <>
Subject mysql timeout
Date Sat, 22 Nov 2008 04:44:13 GMT
 I am trying to troubleshoot an error that seems to occur quite frequently
with no real solution.  I constantly see

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure in my application after the app runs for a few days.  Communication
is fine, networking is fine, netstat even shows connected sessions.  It
appears one of the connection went stale but it is still being returned from
the pool.  I did some reading and it appears there are 2 options

1 - Set wait_timeout in MySQL very high , but still risky
2 - use something like DBCP to enforce a validation query for the connection
from the pool.

Does anyone have any feedback/advise on this issue?  It appears to be quite
common.  I am running on Redhat Linux, Tomcat 5.5.26


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message