com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Com

php中文网
发布: 2016-06-07 15:17:51
原创
1661人浏览过

环境 RedHat Linux 9 VWWare 8.0 SSH 3.2.9 Putty 0.62 MySQL 3.2 问题 通过 JDBC 连接 MySQL 出现 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commu

环境

redhat linux 9 + vwware 8.0 + ssh 3.2.9 + putty 0.62 + mysql 3.2

        

问题

通过JDBC连接MySQL出现com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure

 

 

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

The last packet successfully received from the server was 276 milliseconds ago.  The last packet sent successfully to the server was 50 milliseconds ago.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3591)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3480)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4021)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2671)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2621)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
        at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3892)
        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3437)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2437)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2207)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at TestJDBC.getConnection(TestJDBC.java:19)
        at TestJDBC.testResult(TestJDBC.java:76)
        at TestJDBC.main(TestJDBC.java:13)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3041)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3491)
        ... 25 more
java.lang.NullPointerException
        at TestJDBC.testResult(TestJDBC.java:77)
        at TestJDBC.main(TestJDBC.java:13)
登录后复制


 

 

解决

尚未完成。还请各位赐教。估计是MySQL版本问题。

 

参考资料

 

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

http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai

 

MySQL第二天早上第一次连接超时报错,解决方法com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:

http://zeusami.iteye.com/blog/1112827

造物云营销设计
造物云营销设计

造物云是一个在线3D营销设计平台,0基础也能做电商设计

造物云营销设计 97
查看详情 造物云营销设计

 

mysql连接com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link

http://blog.sina.com.cn/s/blog_49cc672f0100w5fb.html

 

linuxjsp环境的配置(支持mysql数据驱动)

http://www.haogongju.net/art/356469

 

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

http://blog.csdn.net/nemo2011/article/details/6526121

 

 

最佳 Windows 性能的顶级免费优化软件
最佳 Windows 性能的顶级免费优化软件

每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
热门推荐
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号