首页 文章

JDBC连接'jdbc:mysql://127.0.0.1:3306/xxx'但挂起并抛出'jdbc:mysql://172.29.198.142:3306/xxx'的套接字异常

提问于
浏览
0

我这里有一个非常奇怪的问题 . JDBC使用'127.0.0.1'连接到mysql服务器但是当我在那个地方使用真正的IP-ADDRESS时它会像永远一样挂起并抛出一些套接字异常

所以“jdbc:mysql://127.0.0.1:3306 / xxx”;奇迹般有效....

“JDBC:MySQL的://172.29.198.142:3306 / XXX”;扔下面丑陋的例外...... !!

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: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:1117)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:350)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2408)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at   sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
got null
com.xxxxxxxx.server.test.PersistTest
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:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.lntinfotech.server.test.PersistTest.testConnectionJDBC(PersistTest.java:204)
at com.lntinfotech.server.test.PersistTest.main(PersistTest.java:56)
Caused by: java.net.SocketException: Malformed reply from SOCKS server
at java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:90)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:429)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:218)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 16 more

请帮忙!!!!!!

提前致谢......

1 回答

  • 0

    检查你是否打开网络端口 . 简单的测试您可以在该PC或网络中的其他PC上使用mySql查询浏览器,但使用的IP地址不是localhost或127.0.0.1 ...如果可以连接则可以查看java库或java代码 . 如果它无法检查是否有阻止该端口的防病毒或防火墙 .

相关问题