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?
