RE: coonection lost after idle time

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Mar 18 2003 - 10:33:27 EST

  • Next message: John Poole: "view in mySQL - SQlSelectQuery"

    From the posted stack trace, I assume that Halbig is on MySQL. In this
    case the following advise might apply:

      http://www.objectstyle.org/cayenne/lists/cayenne-user/2003/01/0025.html

    Andrus

    > 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:33:27 EST