The last packet successfully received from the server was71200 milliseconds ago

最新推荐文章于 2024-05-20 10:01:30 发布

yihonghe

最新推荐文章于 2024-05-20 10:01:30 发布

阅读量722

点赞数

分类专栏： tomcat jdbc 编程小错误

编程小错误同时被 3 个专栏收录

4 篇文章 0 订阅

订阅专栏

tomcat

2 篇文章 0 订阅

订阅专栏

jdbc

1 篇文章 0 订阅

订阅专栏

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 
The last packet successfully received from the server was71200 milliseconds ago.
The last packet sent successfully to the server was 71200 milliseconds ago, which  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.

A：

网上人们说使用数据库连接池的情况下，连接URL中加入autoReconnect=true&failOverReadOnly=false两个参数可以解决，后来试了一下不行，后来又找了一堆参数加进去，成功了（具体是哪几个起了作用，我也懒的试了，有的参数设置的不合理）：

    removeAbandoned="true"
    removeAbandonedTimeout="10"
    testWhileIdle='true' 
    minEvictableIdleTimeMillis='10000' 
    timeBetweenEvictionRunsMillis='8000'
    validationQuery="SELECT NOW() FROM DUAL"