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
This archive was generated by hypermail 2.0.0 : Thu Feb 06 2003 - 12:36:39 EST