Hi,
I am getting this exception frequently on console. I have increase Mysql time out period to 8 Hr also but it doesn't work. After restart
tomcat it work for some time
again this exceptions come on console.
I am using Tomcat 6 with MySQL, and Torque
===============================================================================
[11/21/10 12:02 AM WARNING] TorqueException while getting the new Connection org.apache.torque.TorqueException: 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:1963)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5371)
at
org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:326)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.setupDefaults(SharedPoolDataSource.java:227)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:692)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912)
at org.apache.torque.Torque.getConnection(Torque.java:314)
at org.apache.torque.util.Transaction.beginOptional(Transaction.java:108)
at com.company.framework.model.util.TorqueUtility.getNewConnection(TorqueUtility.java:712)
at com.company.cs.allocation.job.alert.WSAlertSYProfileLoader.loadProfile(WSAlertSYProfileLoader.java:161)
at com.company.framework.alert.JobSYProcessing.csJobExecute(JobSYProcessing.java:70)
at
com.company.framework.jobutility.csJobThread.run(csJobThread.java:137)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago. -> com.company.framework.model.util.TorqueUtility.getNewConnection():718
==================================================================================
After this exception application stop working and on every click it show this exception on console.
Any one have solution on this? please reply.
Thanks in advance.