Hi Graham, Torque seems to take a stale connection from the conenction pool. I think there is/was a parameter to check the validity of connections in the pool - are you using that?!
Cheers, Siegfried Goeschl -----Original Message----- From: Graham Leggett [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:20 PM To: [EMAIL PROTECTED] Subject: java.sql.SQLException: Connection is closed. Hi all, One of my system users has reported a spurious error that said "the connection is closed". Is this a known problem with Torque? I have Tomcat v4.1.27 provide a connection pool to my webapp, which is in turn accessed by my Torque v3.1 based application. The exception is as follows, any clues? root cause org.apache.torque.TorqueException: java.sql.SQLException: Connection is closed. at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:746) at za.co.fma.patricia.database.om.BaseSignaturePeer.doInsert(BaseSignaturePeer.java:217) at za.co.fma.patricia.database.om.BaseSignaturePeer.doInsert(BaseSignaturePeer.java:569) at za.co.fma.patricia.database.om.BaseSignature.save(BaseSignature.java:10881) at za.co.fma.patricia.database.om.SignatureManager.makeInstance(SignatureManager.java:68) at za.co.fma.patricia.database.om.CompanyManager.save(CompanyManager.java:248) at za.co.fma.patricia.struts.action.CompanyAction.update(CompanyAction.java:321) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at za.co.fma.patricia.struts.PatriciaActionServlet.doPost(PatriciaActionServlet.java:40) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.RequestFilterValve.process(Unknown Source) at org.apache.catalina.valves.RemoteAddrValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContext.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Connection is closed. at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:245) at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:222) at com.workingdogs.village.Schema.schema(Unknown Source) at com.workingdogs.village.Schema.schema(Unknown Source) at com.workingdogs.village.DataSet.(Unknown Source) at com.workingdogs.village.TableDataSet.(Unknown Source) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:740) ... 53 more --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
