ERROR (org.hibernate.util.JDBCExceptionReporter:101)- Communications link failure 解决办法

最新推荐文章于 2023-02-02 05:01:45 发布

原创最新推荐文章于 2023-02-02 05:01:45 发布 · 1.3k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

MySQL

数据库

原项目从MySQL 5.7调整到8.0后，数据库驱动需在pom文件中调整。调整后出现连接超时和通信链接失败问题，原因是MySQL的“wait_timeout”属性，空闲超8小时会自动断开连接，而dbcp未检验连接有效性。解决办法是调整数据库配置文件并重启MySQL。

原项目用的是mysql 5.7，后调整为mysql 8.0后，数据库驱动有问题，可按需调整pom文件。

       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>8.0.20</version>
       </dependency>

但调整驱动后，发现java.net.ConnectException: Connection timed out: connect，以及 ERROR (org.hibernate.util.JDBCExceptionReporter:101)- Communications link failure

具体报错如下：

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.__newInstance(DelegatingConstructorAccessorImpl.java:45)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45009)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45012)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
   at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
   at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
   at com.mysql.cj.NativeSession.connect(NativeSession.java:144)
   at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
   ... 9 more
Caused by: java.net.ConnectException: Connection timed out: connect
   at java.net.DualStackPlainSocketImpl.connect0(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
   at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
   at java.net.Socket.connect(Socket.java:589)
   at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
   at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
   ... 12 more
[2020-12-25 20:18:18.403] [] [] [] [] [--]-[] WARN (org.hibernate.util.JDBCExceptionReporter:100)- SQL Error: 0, SQLState: 08S01
[2020-12-25 20:18:18.404] [] [] [] [] [--]-[] ERROR (org.hibernate.util.JDBCExceptionReporter:101)- Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[2020-12-25 20:18:18.405] [] [] [] [] [--]-[] WARN (org.hibernate.util.JDBCExceptionReporter:100)- SQL Error: 0, SQLState: 08S01
[2020-12-25 20:18:18.406] [] [] [] [] [--]-[] ERROR (org.hibernate.util.JDBCExceptionReporter:101)- Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.