java.io.EOFException

[deligeli]

hi!

i got this message recently:

ERROR,11:50:57 - Error calling Connection.prepareStatement:
java.sql.SQLException: 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.EOFException

STACKTRACE:

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:3020)
at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:629)


i reach the database like this:
<settings cacheModelsEnabled="true" />
        <transactionManager type="JDBC" commitRequired="false">
                <dataSource type="SIMPLE">
                        <property value="${driver}" name="JDBC.Driver" />
                        <property value="${url}" name="JDBC.ConnectionURL" />
                        <property value="${username}" name="JDBC.Username" />
                        <property value="${password}" name="JDBC.Password" />
                </dataSource>
        </transactionManager>

what is problem with it? why did it happen?

[deligeli]

hi

i have read here:

http://www.mikesparr.com/2007/04/07/ibatis-mysql-communications-line-failure-fix/

that the problem is with the selectKey.

does it mean that selectKey doesn't work? how can i make it work please?

deligeli wrote:

hi!

i got this message recently:

ERROR,11:50:57 - Error calling Connection.prepareStatement:
java.sql.SQLException: 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.EOFException

STACKTRACE:

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:3020)
at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:629)


i reach the database like this:
<settings cacheModelsEnabled="true" />
        <transactionManager type="JDBC" commitRequired="false">
                <dataSource type="SIMPLE">
                        <property value="${driver}" name="JDBC.Driver" />
                        <property value="${url}" name="JDBC.ConnectionURL" />
                        <property value="${username}" name="JDBC.Username" />
                        <property value="${password}" name="JDBC.Password" />
                </dataSource>
        </transactionManager>

what is problem with it? why did it happen?

[Kai Grabfelder-3]

I never had problems with mySql and selectKey. Have you tried the solution that is proposed in the blog entry?

Regards

Kai

--- Original Nachricht ---
Absender: deligeli
Datum: 01.11.2009 00:57

> hi
>
> i have read here:
>
> http://www.mikesparr.com/2007/04/07/ibatis-mysql-communications-line-failure-fix/
>
> that the problem is with the selectKey.
>
> does it mean that selectKey doesn't work? how can i make it work please?
>
>
> deligeli wrote:
>>
>> hi!
>>
>> i got this message recently:
>>
>> ERROR,11:50:57 - Error calling Connection.prepareStatement:
>> java.sql.SQLException: 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.EOFException
>>
>> STACKTRACE:
>>
>> 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:3020)
>> at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
>> at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
>> at
>> com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:629)
>>
>>
>> i reach the database like this:
>> <settings cacheModelsEnabled="true" />
>> <transactionManager type="JDBC" commitRequired="false">
>> <dataSource type="SIMPLE">
>> <property value="${driver}" name="JDBC.Driver" />
>> <property value="${url}" name="JDBC.ConnectionURL" />
>> <property value="${username}" name="JDBC.Username" />
>> <property value="${password}" name="JDBC.Password" />
>> </dataSource>
>> </transactionManager>
>>
>> what is problem with it? why did it happen?
>>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@...
For additional commands, e-mail: user-java-help@...