cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Wells" <websyst...@gmail.com>
Subject Idle connection errors
Date Mon, 03 Apr 2006 01:34:40 GMT
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?

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message