CommunicationsException Problem with mySQL4.0.20 and Connector 3.1.12

[kartik srinivasan]

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)

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