You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by deligeli <od...@jpost.com> on 2009/10/31 23:38:18 UTC
java.io.EOFException
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?
--
View this message in context: http://old.nabble.com/java.io.EOFException-tp26146582p26146582.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: java.io.EOFException
Posted by Kai Grabfelder <no...@kaigrabfelder.de>.
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@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: java.io.EOFException
Posted by deligeli <od...@jpost.com>.
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?
>
--
View this message in context: http://old.nabble.com/java.io.EOFException-tp26146582p26146830.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org