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]
