jdbc报错 :com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

最新推荐文章于 2022-11-17 17:00:27 发布
最新推荐文章于 2022-11-17 17:00:27 发布
阅读量877 收藏
点赞数 1
分类专栏： 搬砖发育 文章标签： javaweb jdbc mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mr_suddenflash/article/details/78700374
版权

报错详细：

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 java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
    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(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    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(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at sqg.designfn.db.DataConnection.<init>(DataConnection.java:22)
    at sqg.designfn.dao.proxy.MovieDAOProxy.<init>(MovieDAOProxy.java:24)
    at sqg.designfn.factory.MovieFactory.getIMovieDAOInstance(MovieFactory.java:11)
    at sqg.designfn.servlet.ShowMovieServlet.doGet(ShowMovieServlet.java:30)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:500)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.ConnectException: Connection refused: 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.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
    ... 42 more

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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 java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
    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(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    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(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at sqg.designfn.db.DataConnection.<init>(DataConnection.java:22)
    at sqg.designfn.dao.proxy.MovieDAOProxy.<init>(MovieDAOProxy.java:24)
    at sqg.designfn.factory.MovieFactory.getIMovieDAOInstance(MovieFactory.java:11)
    at sqg.designfn.servlet.ShowMovieServlet.doGet(ShowMovieServlet.java:30)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:500)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.ConnectException: Connection refused: 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.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)

    ... 42 more



原因：MySQL服务没启。

解决：选中“计算机”，右键“管理”，选中“服务和应用程序”，“服务”，找到MySQL服务，启动。可以设置MySQL服务为自动启动，避免每次启动的麻烦（操作附图2张）。

图一 启动MySQL服务

图二 设置为自启动



事实上zhuxiao1123123
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
解决Cause com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
11-09
Cause com.mysql.jdbc.exceptions.jdbc4.CommunicationsException The last packet successfully received from the server was 47,795,922 milliseconds ago. The last packet sent successfully to the server was...
Java连接MySQL出现CommunicationsException和SSLHandshakeException问题处理
wyj180的博客
07-23 1432
在搭建Spring boot整合Mybatis的时候，出现了如下错误： 报错信息： com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 217 milliseconds ago. The last packet sent successfully to the serv.
MySQL_遇到的BUG
底层码农
04-10 8514
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure ...
解决——》CommunicationsException:Communications link failure
小仙~
11-17 9388
Mysql的连接等待时间（wait_timeout）默认8小时。在wait_timeout时间内，mysql的连接（connection）处于等待状态，一旦超过这个时间，mysql就会关闭。但是在我们的项目中的连接池中仍存在合法的connection，当你的程序需要再次访问数据库时，就会出现以上异常，但是再重新访问，又能正常从数据库中获取到数据。
记一次com.mysql.jdbc.exceptions.jdbc4.CommunicationsException异常排查
sonycong的专栏
07-22 1031
具体异常为： Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 51,440,515 milliseconds ago. The last packet sent successfully t...
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection;
hg123677的博客
11-05 1638
java.sql.SQLException: com.mysql.jdbc.Driver at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:567) ~[druid-1.1.2.jar:1.1.2] at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSou...
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ….. this is incompatible with sq
12-14
1、写在开头 标题之前我想说一下Linux的mysql真的实在是太坑了。太坑了。总是会出现这样那样的你想不到的问题。崩溃了。首先来罗列一下我遇到过的...Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcepti
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法
09-09
主要介绍了Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法的相关资料,需要的朋友可以参考下
mysql数据库在springboot项目中启动报错问题.docx
11-04
com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error:GlobalConfigUtils setMetaData Fail !
系统使用一段时间之后，数据库连接超时问题排查：sql.jdbc.exceptions.jdbc4.CommunicationsException Communications link failure
wang9979的博客
11-01 344
连接数据库异常，com.mysql.jdbc.exceptions.jdbc4.CommunicationsException Communications link failure
Mysql异常之Communications link failure
m0_37148920的博客
06-13 3724
前天线上出现数据数据抖动，收到大量异常告警，都要疯了，数据库出现大量异常，肯定第一件事就是看下数据库监控数据，发现有一个从分片执行时间有一个50多秒的操作，这里肯定有问题了，第一时间找了dba，ji ...
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
qq_21128741的博客
03-01 9954
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failur
Mysql异常com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure
阿正的博客
06-28 3297
参考：https://wentao365.iteye.com/blog/2124869
【已解决】com.mysql.jdbc.exceptions.jdbc4.CommunicationsExcepti：Communications link failure ----mysql连接报错
L_it123的博客
06-18 7万+
使用idea 做项目时，连接mysql数据库报错 The last packet successfully received from the server was 1,548 milliseconds ago. The last packet sent successfully to the server was 1,540 milliseconds ago. ### The error may exist in com/liu/dao/StudentMapper.xml ### The error
Communications link failure 一个困扰了我三天的问题已解决
weixin_48327294的博客
05-04 2万+
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure 一个困扰了我三天的问题 通信链路故障 对就是通信链路故障没错，其实我对我写的代码还挺自信的所以这个问题 困扰了我三天，各种网上的方法都尝试了但是都没有解决问题没最后我甚至卸载 Mysql再进行重装，发现还是报这个错误，最后甚至是重装了系统但还无济于事， 最后我把这个问题放下了没解决。过了一天我放下了我的自尊把我的代码统统查看了 一遍于
[已解决]踩过的坑之mysql连接报“Communications link failure”错误
热门推荐
小小鱼儿小小林的博客
07-05 68万+
目录 前言 第一种方法： 第二种方法 第三种方法(适用于项目和数据库在同一台服务器) 第四种方法 第五种方法(项目和数据库不在同一台服务器) 总结 前言 先给大家简述一下我的坑吧，（我用的是mysql，至于oracle有没有这样的问题，有心的小伙伴们可以测试一下哈）， 在自己做个javaweb测试项目的时候，因为买的是云服务器，所以数据库连接的是用ip地址，用IDE开发好...
连接mysql报“com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException”的错误解决
深海微澜
05-28 6万+
使用jdbc连接mysql数据库，报错com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException。 JDBCTest.java代码为： public class JDBCTest { public static void main(String[] args) throws Exception { Connection connection = null; PreparedStatem
异常解决com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
weixin_33850890的博客
11-03 866
21:37:08,815 DEBUG BasicResourcePool:1831 - An exception occurred while acquiring a poolable resource. Will retry.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureTh...
Error:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
最新发布
12-16
这个错误通常是由于MySQL服务器无法响应或连接超时引起的。以下是一些可能的解决方法： 1. 检查MySQL服务器是否正在运行，并确保您的网络连接正常。 2. 检查MySQL服务器的日志文件以查看是否有任何错误或警告消息。 3. 尝试增加连接超时时间。您可以在连接字符串中设置连接超时时间，例如： ```java jdbc:mysql://localhost:3306/mydatabase?connectTimeout=3000 ``` 这将把连接超时时间设置为3秒钟。 4. 尝试使用较新的MySQL驱动程序。您可以从MySQL官方网站下载最新的JDBC驱动程序。 5. 如果您正在使用连接池，请确保您的连接池配置正确，并且您的连接池没有达到最大连接数。 6. 如果您的应用程序在远程服务器上运行，请确保您的防火墙允许MySQL流量通过。 以下是一个Java代码示例，演示如何处理此错误： ```java import java.sql.*; public class Example { public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase?connectTimeout=3000", "username", "password"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM mytable"); while (rs.next()) { System.out.println(rs.getString("column1")); } conn.close(); } catch (SQLException ex) { ex.printStackTrace(); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } } } ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值