美文网首页
springboot连接数据库总是出现断开连接的问题

springboot连接数据库总是出现断开连接的问题

作者: 此生也有生 | 来源:发表于2018-01-31 14:51 被阅读0次

日志描述:

### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 67,631,373 milliseconds ago.  The last packet sent successfully to the server was 67,631,375 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.

如果配置是第一种的话 改为第二种即可

相关文章

网友评论

      本文标题:springboot连接数据库总是出现断开连接的问题

      本文链接:https://www.haomeiwen.com/subject/bgakzxtx.html