db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lucas Fragomeni <lu...@lucasfragomeni.com>
Subject java.sql.SQLException: Communication link failure: java.io.IOException
Date Mon, 20 Sep 2004 04:14:13 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message