Communication link failure
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.
