Wait_timeout Exceeded on JDBC Connection
(Doc ID 2019877.1)
Last updated on MARCH 23, 2020
Applies to:MySQL Connectors - Version 5.3 and later
Information in this document applies to any platform.
On : 5.6 version, Connector/J
When attempting to access MySQL Server via JDBC,
the following error occurs.
2015-05-03 21:09:25,541 ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The last packet successfully received from the server was 108,565,353 milliseconds ago. The last packet sent successfully to the server was 108,565 ,399 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
The issue has the following business impact:
Due to this issue, users cannot manage connections via their application to the mysql service.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document