数据库连接出现Communications link failure

最新推荐文章于 2025-06-05 08:13:51 发布

fjzzpljj

最新推荐文章于 2025-06-05 08:13:51 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： PAT 文章标签：数据库连接

本文链接：https://blog.youkuaiyun.com/fjzzpljj/article/details/89070972

PAT 专栏收录该内容

3 篇文章

订阅专栏

在尝试数据库操作时遇到Communications link failure异常，该异常通常由于连接超时或网络问题导致。通过检查和修改数据库连接参数，例如设置useSSL=false，并确保正确输入用户名和密码，可以成功解决此问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在进行简单的数据库操作时出现以下错误：

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 31,008 milliseconds ago. The last packet sent successfully to the server was 30,981 milliseconds ago.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
   at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
   at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4912)
   at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at cn.itcast.mybatis.jdbc.JdbcTest.main(JdbcTest.java:30)
Caused by: java.net.SocketException: Software caused connection abort: recv failed
   at java.net.SocketInputStream.socketRead0(Native Method)
   at java.net.SocketInputStream.socketRead(Unknown Source)
   at java.net.SocketInputStream.read(Unknown Source)
   at java.net.SocketInputStream.read(Unknown Source)
   at sun.security.ssl.InputRecord.readFully(Unknown Source)
   at sun.security.ssl.InputRecord.read(Unknown Source)
   at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
   at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
   at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
   at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
   at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
   ... 18 more

上面红色的字就是出错的地方，对应我这个位置

上面的密码被我模糊化了，你们就填你们对应的数据密码就ok了。

修改数据库的连接，就可以解决问题了

数据库连接写成下面这样就可以了

// 加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");

// 通过驱动管理类获取数据库连接

connection = (Connection) DriverManager
                   .getConnection(
                           "jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=false",
                           "root", "*********");

"*********"：写成你们的数据库连接密码

这样我的问题就解决了。