Java APIs

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Communication link failure

843798Dec 19 2006 — edited Sep 10 2007

hi,
Im facing mysql Communication link failure problem, am using Linux OS(2.4.21-4) with MySQL V. 4.1.7 , Mysql driver 3.1.6 exception . im using LInux server with mysql driver , when i execute my program its running fine .after 1 day mysql inactivity happens disconnect from server and aplication reports error 'Communication link failure ...'

cannot issue a Statement.executeUpdate(), the error is this one.

Error is in Connection:com.mysql.Communication com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1845)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2292)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java.1625)
..
few more lines are there

** END NESTED EXCEPTION **

Can anybody help me
Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2007

Added on Dec 19 2006

#jdk-s-monitoring-troubleshooting-tools

2 comments

756 views