Hello Lucas,
I would try to play a little bit with the connection settings of mysql, see: http://dev.mysql.com/doc/connector/j/en/index.html#id2424263 (Connection Properties*) *I think what it interests you is the 'autoReconnect' property.
Best regards, Andras.
Lucas Fragomeni wrote:
Help!
Here is my problem: i have a web application running perfectly well at home, but when I put it on my host provider it just keeps throwing, from time to time, a java.sql.SQLException, originated from a org.apache.torque.TorqueException, caused by a java.io.IOException:
Everything starts on the 'getConnection()', and happens only from time to time... Would it have something to do with the way my host provide treats security and connection pools?
Bellow is the stack trace I get:
java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1675) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1083) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1142) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1114) at com.mysql.jdbc.Connection.execSQL(Connection.java:1873) at com.mysql.jdbc.Connection.execSQL(Connection.java:1819) at com.mysql.jdbc.Connection.execSQL(Connection.java:1800) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:604) at org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:370) at org.apache.commons.dbcp.datasources.SharedPoolDataSource.setupDefaults(SharedPoolDataSource.java:258) at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:704) at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:665) at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743) at org.apache.torque.Torque.getConnection(Torque.java:306) at org.apache.torque.util.Transaction.beginOptional(Transaction.java:118) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365) at infuse.syo.torque.BasePaginaPeer.doSelectVillageRecords(BasePaginaPeer.java:387) at infuse.syo.torque.BasePaginaPeer.doSelectVillageRecords(BasePaginaPeer.java:355) at infuse.syo.torque.BasePaginaPeer.doSelect(BasePaginaPeer.java:324) ... rethrown as org.apache.torque.TorqueException: Communication link failure: java.io.IOException at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:755) at org.apache.torque.Torque.getConnection(Torque.java:306) at org.apache.torque.util.Transaction.beginOptional(Transaction.java:118) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365) at infuse.syo.torque.BasePaginaPeer.doSelectVillageRecords(BasePaginaPeer.java:387) at infuse.syo.torque.BasePaginaPeer.doSelectVillageRecords(BasePaginaPeer.java:355) at infuse.syo.torque.BasePaginaPeer.doSelect(BasePaginaPeer.java:324) ... Caused by: java.sql.SQLException: Communication link failure: java.io.IOException ... ... 50 more
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
