服务器数据库间断性的会出现数据库连接异常的报错，报错异常为

### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 34,101 milliseconds ago. The last packet sent s

uccessfully to the server was 34,103 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before us

e in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

my.ini

--增加如下配置

wait_timeout=144000

interactive_timeout=144000

-- 保存后重启mysql服务


 

更多推荐

You should consider either expiring and/or testing connection validity before us