KelvinCampelo / fosstrak

Automatically exported from code.google.com/p/fosstrak
0 stars 0 forks source link

Doesn't reconnect with MySQL after timeout - hibernate problem #14

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I'm running EPCIS repository 0.5.0 on Tomcat 7 on Debian. In my logs I see

  The last packet successfully received from the server was 34,303,076 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
  com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

At this point I just restart the Tomcat server and the connection to the MySQL 
server is restored. I understand that the problem is that I use the server to 
seldom ... I think a possible solution is suggested at 
http://www.jvmhost.com/articles/hibernate-famous-communications-link-failure-las
t-packet-sent-successfuly-issue-solved-c3p0

Original issue reported on code.google.com by hansfn@gmail.com on 7 Nov 2013 at 8:51