MySQL connection via Hibernate is timed out frequently

[gane]

I am connecting to MySql using Hibernate and every 8 hours the connection is timed out. I am getting com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption. It also display very big error message. "The last packet successfully received from the server was 437,036,648 milliseconds ago......."

If i restart my application, things will work fine. Please help me out.

[travishein]

are you using a database connection pool, such as commons-pool.
they support a "test on borrow" mechanism where the connection in the pool is tested with a "validation query" before it is given to the requesting application. This facility works to remove these sql error messages from the application, as it opens the connection again as needed.
see also: DBCP - Commons Wiki
but i;m sure other connection pool implementations support something like test on borrow and validation query as well

[nandak]

The issue is due to your connection pool library timing out the database connection. You need to test or validate it. Check out the article to set the relevant properties in c3p0 file.