dao.RecoverableDataAccessException 解决方法

最新推荐文章于 2024-09-13 20:00:00 发布

Marcuslu

最新推荐文章于 2024-09-13 20:00:00 发布

阅读量4.3k

点赞数

分类专栏：自己学习的分类 java 文章标签： java spring boot 后端

本文链接：https://blog.csdn.net/Marcuslu/article/details/125423221

版权

自己学习的分类同时被 2 个专栏收录

18 篇文章 1 订阅

订阅专栏

java

6 篇文章 0 订阅

订阅专栏

背景

使用springboot框架/mbs，今早看日志发现存在dao.RecoverableDataAccessException 问题；.
下面展示一些 内联代码片。

2022-06-23 03:17:21,806 ERROR com.example.jmindex.controller.getDataFromInternet.getJm.getEtcJm [http-nio-8083-exec-10] org.springframework.dao.RecoverableDataAccessException: 
### Error querying database.  Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 3,609,285 milliseconds ago. The last packet sent successfully to the server was 3,622,297 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.

解决

在application里添加 autoReconnect=true；

#本地数据库链接
 url: jdbc:mysql://localhost:3306/try?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8