coonection lost after idle time

From: Halbig Thomas (thomas.halbi..interthur.ch)
Date: Tue Mar 18 2003 - 04:42:37 EST

Next message: John Poole: "RE: coonection lost after idle time"

Previous message: Dirk Olmes: "Re: cayenne postgres view problem?"
Next in thread: John Poole: "RE: coonection lost after idle time"
Reply: John Poole: "RE: coonection lost after idle time"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

I'have a problem with the database connection.
It seems so that cayenne sets the connections back after a specific idle time. After them, I try to access to the database I will receive the following Exception:

WARN DefaultOperationObserver: global exception
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.MysqlIO.sqlQuery(Unknown Source)
        at com.mysql.jdbc.Connection.execSQL(Unknown Source)
        at com.mysql.jdbc.Connection.execSQL(Unknown Source)
        at com.mysql.jdbc.Connection.setAutoCommit(Unknown Source)
        at org.objectstyle.cayenne.conn.PooledConnectionImpl.getConnection(PooledConnectionImpl.java:121)
        at org.objectstyle.cayenne.conn.PoolManager.getConnection(PoolManager.java:367)
        at org.objectstyle.cayenne.conn.PoolManager.getConnection(PoolManager.java:337)
        at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:243)
        at org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:427)
        at org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:884)
        at org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:976)
        at org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:813)
        at com.winterthur.cm.controller.LocalAccountManager.getAllAccounts(LocalAccountManager.java:254)
        at com.winterthur.cm.cron.UpdateBalancesWorker.handleAlarm(UpdateBalancesWorker.java:49)
        at com.jalios.jdring.AlarmManager.notifyListeners(AlarmManager.java:378)
        at com.jalios.jdring.AlarmWaiter.run(AlarmWaiter.java:108)

Any idea, is this is a bug on cayenne side or a configuration failure on my side?

Thanx in advance
Thomas

Next message: John Poole: "RE: coonection lost after idle time"
Previous message: Dirk Olmes: "Re: cayenne postgres view problem?"
Next in thread: John Poole: "RE: coonection lost after idle time"
Reply: John Poole: "RE: coonection lost after idle time"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Mar 18 2003 - 04:46:44 EST