求解mysql连接问题 连接一段时间后出现的问题,一般是运行一天都无问题,第二天一早来看就有异常了,高手指点
** BEGIN NESTED EXCEPTION ** java.io.EOFExceptionSTACKTRACE:java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at com.bhb.sms.busyness.zillionaire.UserState.loadUserSession(UserState.java:214)
at com.bhb.sms.busyness.zillionaire.UserState.<init>(UserState.java:274)
at com.bhb.sms.busyness.zillionaire.worker.Worker.init(Worker.java:70)
at com.bhb.sms.busyness.zillionaire.worker.Worker.init(Worker.java:41)
at com.bhb.sms.busyness.zillionaire.Center.onDelivery(Center.java:41)
at com.bhb.sms.busyness.server.CommImpl$MODispatchThread.task(CommImpl.java:290)
at com.bhb.sms.util.common.WatchThread.run(WatchThread.java:30)
** END NESTED EXCEPTION **Last packet sent to the server was 1 ms ago.
[06-08-25 09:13:44 646]<I>getStringContent error sql:
[06-08-25 09:13:44 647]<I>addUserSession error desc: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFExceptionSTACKTRACE:java.io.EOFException....** END NESTED EXCEPTION **
** BEGIN NESTED EXCEPTION ** java.io.EOFExceptionSTACKTRACE:java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at com.bhb.sms.busyness.zillionaire.UserState.loadUserSession(UserState.java:214)
at com.bhb.sms.busyness.zillionaire.UserState.<init>(UserState.java:274)
at com.bhb.sms.busyness.zillionaire.worker.Worker.init(Worker.java:70)
at com.bhb.sms.busyness.zillionaire.worker.Worker.init(Worker.java:41)
at com.bhb.sms.busyness.zillionaire.Center.onDelivery(Center.java:41)
at com.bhb.sms.busyness.server.CommImpl$MODispatchThread.task(CommImpl.java:290)
at com.bhb.sms.util.common.WatchThread.run(WatchThread.java:30)
** END NESTED EXCEPTION **Last packet sent to the server was 1 ms ago.
[06-08-25 09:13:44 646]<I>getStringContent error sql:
[06-08-25 09:13:44 647]<I>addUserSession error desc: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFExceptionSTACKTRACE:java.io.EOFException....** END NESTED EXCEPTION **
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货