Will try that, thanks
Andrus Adamchik wrote:
> Quiet possible. See this message that shows how to configure automatic
> reconnection in MySQL:
>
> http://objectstyle.org/cayenne/lists/cayenne-user/2003/01/0025.html
>
> Andrus
>
>
>>Every once in a while I get the error below. could it be the connection
>>pool? or maybe a bub in the mysql jdbc driver?:
>>
>>root cause
>>
>>org.objectstyle.cayenne.CayenneRuntimeException: Global exception.
>> at
>>org.objectstyle.cayenne.access.util.SelectObserver.nextGlobalException(SelectObserver.java:156)
>> at
>>org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:331)
>> at
>>
>>.......
>>
>>
>>
>>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
>> at
>>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
>> at java.lang.Thread.run(Thread.java:536)
>>Caused by: org.objectstyle.cayenne.CayenneRuntimeException: Query
>>exception.
>> at
>>org.objectstyle.cayenne.access.util.SelectObserver.nextQueryException(SelectObserver.java:147)
>> at
>>org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:288)
>> ... 44 more
>>
>>
>>Caused by: java.sql.SQLException: Communication link failure:
>>java.io.IOException
>>
>> at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
>> at com.mysql.jdbc.Connection.execSQL(Unknown Source)
>> at com.mysql.jdbc.PreparedStatement.executeQuery(Unknown Source)
>> at
>>org.objectstyle.cayenne.access.DefaultResultIterator.(DefaultResultIterator.java:117)
>> at org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:358)
>>at
>>org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:278)
>> ... 44 more
>>
>>Apache Tomcat/4.1.10-LE-jdk14
>>
>>--
>>Vincent Stoessel
>>Linux Systems Developer
>>vincent xaymaca.com
>
>
>
-- Vincent Stoessel Linux Systems Developer vincent xaymaca.com
This archive was generated by hypermail 2.0.0 : Thu Feb 06 2003 - 13:12:05 EST