You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Lucas Fragomeni <lu...@lucasfragomeni.com> on 2004/09/21 05:52:16 UTC
java.sql.SQLException: Communication link failure: java.io.IOException - Fixed
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 <an...@reea.net>
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: 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
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org