cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Idle connection errors
Date Mon, 03 Apr 2006 08:11:11 GMT
Some drivers support auto-reconnect parameter:

http://objectstyle.org/confluence/display/CAY/Reconnect

jTDS doesn't seem to support that. From the stack trace, you are  
using a DBCP connection pool. IIRC DBCP allows transparent reconnect  
with any driver. You'd have to check DBCP docs on that.

Andrus


On Apr 3, 2006, at 5:34 AM, Steve Wells wrote:
> 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.createStateme 
> nt
> (ProcedureTranslator.java:160)
>  at
> org.objectstyle.cayenne.dba.sqlserver.SQLServerProcedureAction.perform 
> Action
> (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
View raw message