Hello, 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 Thanks Adam
