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"

    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



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