RE: coonection lost after idle time

From: John Poole (john..ixxurescanada.com)
Date: Tue Mar 18 2003 - 10:12:10 EST

  • Next message: Andrus Adamchik: "RE: coonection lost after idle time"

    Configuration failure on your side. You need to set the connection
    differently depending on which database you are using. What is the
    connection URL you are using now?

    -----Original Message-----
    From: Halbig Thomas [mailto:thomas.halbi..interthur.ch]
    Sent: March 18, 2003 2:43 AM
    To: cayenne-use..bjectstyle.org
    Subject: 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(PooledConnec
    tionImpl.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:8
    84)
            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(LocalAccount
    Manager.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 - 10:16:01 EST