Idle connection errors

From: Steve Wells (websystem..mail.com)
Date: Sun Apr 02 2006 - 21:34:40 EDT

Next message: emre.yilma..tr.com.tr: "Pk generation strored procedures"

Previous message: cayenne-user-hel..ncubator.apache.org: "ezmlm warning"
Next in thread: Andrus Adamchik: "Re: Idle connection errors"
Reply: Andrus Adamchik: "Re: Idle connection errors"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

If we try and run a query after the connection have been idle for some time,
many hours (sorry I don't exactly yet know how long) we get:

Caused by: java.sql.SQLException: Invalid state, the Connection object is
closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java
:1305)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall (
ConnectionJDBC2.java:1941)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareCall(
DelegatingConnection.java:212)
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareCall
(PoolingDataSource.java :268)
at org.objectstyle.cayenne.access.trans.ProcedureTranslator.createStatement
(ProcedureTranslator.java:160)
at
org.objectstyle.cayenne.dba.sqlserver.SQLServerProcedureAction.performAction
(SQLServerProcedureAction.java :105)
at org.objectstyle.cayenne.access.DataNodeQueryAction.runQuery(
DataNodeQueryAction.java:95)
at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java
:321)
... 54 more

using SQL Server, jtds 1.2, Cayenne M10. Any thoughts please?

Next message: emre.yilma..tr.com.tr: "Pk generation strored procedures"
Previous message: cayenne-user-hel..ncubator.apache.org: "ezmlm warning"
Next in thread: Andrus Adamchik: "Re: Idle connection errors"
Reply: Andrus Adamchik: "Re: Idle connection errors"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Sun Apr 02 2006 - 21:35:05 EDT