db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: java.sql.SQLException: Communication link failure: java.io.IOException
Date Mon, 20 Sep 2004 08:08:47 GMT
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: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>  
>


---------------------------------------------------------------------
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