在弹簧启动424小时后使用Hibernate

引起的：com.mysql.jdbc.exceptions.jdbc4.communicationsexpection：从服务器成功收到的最后一个数据包为56,006,037毫秒。 成功发送到服务器的最后一个数据包是56,006,037毫秒前。比服务器配置的“ 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.

To address this issue, it is recommended to configure appropriate connection properties in the application's configuration file (e.g., application.properties）：

Remove idle connections if they have not been used within a specified time (spring.datasource.min-evictable-idle-time-millis).

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 56,006,037 milliseconds ago.  The last packet sent successfully to the server was 56,006,037 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.

By implementing these configurations, the connection pool will regularly test the validity of connections and replace those that have become stale, ensuring stable即使在延长了不活动的时间之后，数据库连接。