Alright, it's woking! You're right Andras... the 'autoReconnect' fixed it. It seem a bit slow, but works! I've read it before, but i thought the solution were on some Torque property, not on a MySQL's. Well.. Thanks a lot! Lucas. ---- Date: Mon, 20 Sep 2004 11:08:47 +0300 From: Andras Balogh <[EMAIL PROTECTED]> Subject: java.sql.SQLException: Communication link failure: java.io.IOException Content-Type: text/plain; charset=ISO-8859-1; format=flowed 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
