Wait_timeout Exceeded on JDBC Connection
Last updated on MARCH 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms