Hi all

I am getting following exception in mysql db randomly.

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.
11-9-2011 12:0:11 Exception in readFile Method in insertRecordInDataBasecom.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:1865)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2256)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2756)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3025)


can anyone suggest why this exception comes in MySql ????

What exactly you are trying to do , that raises this exception ?

I have an java application which inserts the data into db.This exception occurs daily so i want to know the reason.
It occurs sometime otherwise my application is running successfully

What exactly you are trying to do , that raises this exception ?

You need to debug both your application and DB code that is being called form application.

I know that but i want to know the reason of this exception.

You need to debug both your application and DB code that is being called form application.

Without knowing the exact piece of code that you are executing, it is practically not possible to guess the reason of this exception.

I am not asking for the error in my code I am just asking what the meaning of this exception.whether mysql has been full

You need to debug both your application and DB code that is being called form application.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.