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

最新推荐文章于 2024-12-06 19:36:20 发布

高尔夫golf

最新推荐文章于 2024-12-06 19:36:20 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： Java开发数据库

本文链接：https://blog.youkuaiyun.com/konglongaa/article/details/51668619

Java开发同时被 2 个专栏收录

259 篇文章

订阅专栏

数据库

111 篇文章

订阅专栏

本文详细分析了在Java应用中遇到的MySQL连接异常问题，包括CommunicationsException错误的具体原因及解决思路。通过排查配置文件、Jar包及MySQL服务状态，最终定位并解决了问题。

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

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:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.mysqltoactivemq.Ag_Worker.DBHelperGetJsonBean(Ag_Worker.java:249)
at com.mysqltoactivemq.Ag_Worker$1.run(Ag_Worker.java:126)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 19 more
/n/n[ERROR] 2016-06-13 15:36:22,072 method:com.mysqltoactivemq.Ag_Worker.DBHelperGetJsonBean(Ag_Worker.java:257)
DBHelperGetJsonBean erro:
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.

参考了文章：http://blog.youkuaiyun.com/zmzsoftware/article/details/6835604 看了预测mysql库问题

参考了文章：http://blog.sina.com.cn/s/blog_49cc672f0100w5fb.html 看了预测jar包问题

我最终发现我这边，打jar包含了配置文件，冗余了配置文件，导致程序放在Linux系统没有读取到新配置文件导致的，这里报错要么就是配置文件有问题，要么就是jar包，要么就是mysql有问题，碰到此报错予以排除吧