jdbc报错 Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully

最新推荐文章于 2024-10-17 20:47:48 发布

Thomas2143

最新推荐文章于 2024-10-17 20:47:48 发布

阅读量715

点赞数

分类专栏：总结文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_35515661/article/details/142105743

版权

总结专栏收录该内容

791 篇文章 ¥99.90 ¥299.90

订阅专栏

完整报错

2024-09-10T17:39:17.348173238+08:00 stdout F Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 8,159,974 milliseconds ago.  The last packet sent successfully to the server was 8,159,974 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.

解决方法

jdbc链接偶现失活解决:
    jdbc:mysql://hostname:port/dbname?useSSL=false&testOnBorrow=true&validationQuery=SELECT 1&autoReconnect=false
    此配置中：
        •   testOnBorrow=true：每次获取连接时测试连接是否有效。
        •   validationQuery=SELECT 1：执行简单的 SQL 查询来测试连接。