asked on
Reconnect in MySQL using hibernate
Hi everyone,
I am working on a web based database application, i am using Struts, Hibernate and Tomcat. the database is MySQL. the problem i am facing is after 8 hours the connection will terminate with the MySQL server. it wont reconnect again till I reset the tomcat sever or redeploy.
any suggestions??
I am working on a web based database application, i am using Struts, Hibernate and Tomcat. the database is MySQL. the problem i am facing is after 8 hours the connection will terminate with the MySQL server. it wont reconnect again till I reset the tomcat sever or redeploy.
any suggestions??
MySQL ServerWeb ApplicationsJava EE
Last Comment
JSase
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
http://confluence.atlassian.com/display/DOC/Configuring+a+MySQL+Datasource+in+Apache+Tomcat
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
just in case someone still needs an answer. check out this article. exactly what I needed:
http://www.databasesandlife.com/automatic-reconnect-from-hibernate-to-mysql/
http://www.databasesandlife.com/automatic-reconnect-from-hibernate-to-mysql/