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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
