CommunicationsException Problem with mySQL4.0.20 and Connector 3.1.12
Posted by: kartik srinivasan
Date: February 23, 2007 03:37AM

I keep getting this error after my tomcat 5.0.28 application has been up for a couple of days. Any clues will be appreciated.

--------------------------------------------------------------------------
2007-01-31 01:20:59,516 ERROR org.enhydra.jdbc.xapool - StandardXADataSource:getFreeConnection ERROR: Failed while autocommiting a connection: 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:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
at org.enhydra.jdbc.standard.StandardXADataSource.getFreeConnection(StandardXADataSource.java:492)
at org.enhydra.jdbc.standard.StandardXAConnection.getConnection(StandardXAConnection.java:138)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:209)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:462)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:574)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:102)
at org.springframework.jdbc.object.SqlQuery.findObject(SqlQuery.java:216)
at org.springframework.jdbc.object.SqlQuery.findObject(SqlQuery.java:277)
at org.springframework.jdbc.object.SqlQuery.findObject(SqlQuery.java:284)

--------------------------------------------------------------------------

Options: ReplyQuote


Subject
Written By
Posted
CommunicationsException Problem with mySQL4.0.20 and Connector 3.1.12
February 23, 2007 03:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.