亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

JDBC無法連接數據庫?

JDBC無法連接數據庫?

一只勤奮的魚3773709 2016-10-16 20:11:39
驅動是5.1.40的,MySQL是5.6.33的,數據庫開著,能進能修改package?com.kevin.db; import?java.sql.Connection; import?java.sql.DriverManager; import?java.sql.ResultSet; import?java.sql.Statement; public?class?DBUtil?{ ????private?static?final?String?URL="jdbc:mysql://127.0.0.1:3306/test"; ????private?static?final?String?USER="root"; ????private?static?final?String?PASSWORD="root"; public?static?void?main(String[]?args)?throws?Exception{ Class.forName("com.mysql.jdbc.Driver"); Connection?conn?=?DriverManager.getConnection(URL,USER,PASSWORD); Statement?stmt?=?conn.createStatement(); ResultSet?rs?=?stmt.executeQuery("SELECT?id,pname?FROM?provinces"); while(rs.next()){ System.out.println(rs.getString("pname")+","+rs.getInt("id")); } } }下面是異常:Exception?in?thread?"main"?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(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:989) at?com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:632) at?com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1016) at?com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253) 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(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:410) at?com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) at?java.sql.DriverManager.getConnection(Unknown?Source) at?java.sql.DriverManager.getConnection(Unknown?Source) at?com.kevin.db.DBUtil.main(DBUtil.java:14) Caused?by:?java.net.SocketException:?Connection?reset at?java.net.SocketInputStream.read(Unknown?Source) at?java.net.SocketInputStream.read(Unknown?Source) at?com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) at?com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) at?com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) at?com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3005) at?com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:567) ...?16?more
查看完整描述

4 回答

?
路人丶丨

TA貢獻115條經驗 獲得超45個贊

應該是因為數據庫一直保持打開,很久沒有進行操作。 ?mysql自動斷開,連接池認為還在連接中

查看完整回答
1 反對 回復 2016-10-17
?
忘性最大的人

TA貢獻118條經驗 獲得超37個贊

搬運stack overflow

  1. IP address or hostname in JDBC URL is wrong.

  2. Hostname in JDBC URL is not recognized by local DNS server.

  3. Port number is missing or wrong in JDBC URL.

  4. DB server is down.

  5. DB server doesn't accept TCP/IP connections.

  6. DB server has run out of connections.

  7. Something in between Java and DB is blocking connections, e.g. a firewall or proxy.?


查看完整回答
1 反對 回復 2016-10-16
?
悠小爺

TA貢獻21條經驗 獲得超8個贊


長時間不妨問,connection失效導致的。

Caused?by:?java.net.SocketException:?Connection?reset 學會看報錯信息,長時間不妨問connection重置了。

重啟mysql: service mysql restart ?

查看完整回答
反對 回復 2016-10-23
  • 4 回答
  • 1 關注
  • 3051 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號