We get a lot of similar problem as mentioned in http://www.mail-archive.com/[EMAIL PROTECTED]/msg01537.html , haven't yet able to figure out what is causing it.
Amit. > -----Original Message----- > From: Graham Leggett [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 10, 2003 7:20 AM > 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(BaseSignatureP ee > r.java:217) > at > za.co.fma.patricia.database.om.BaseSignaturePeer.doInsert(BaseSignatureP ee > r.java:569) > at > za.co.fma.patricia.database.om.BaseSignature.save(BaseSignature.java:108 81 > ) > at > za.co.fma.patricia.database.om.SignatureManager.makeInstance(SignatureMa na > ger.java:68) > at > za.co.fma.patricia.database.om.CompanyManager.save(CompanyManager.java:2 48 > ) > at > za.co.fma.patricia.struts.action.CompanyAction.update(CompanyAction.java :3 > 21) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a: > 39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Im > pl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j av > a:280) > at > org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216 ) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr oc > essor.java:484) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 27 > 5) > 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(PatriciaActionSer vl > et.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.i nv > okeNext(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.i nv > okeNext(Unknown > Source) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Unknown > Source) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(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.i nv > okeNext(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.i nv > okeNext(Unknown > Source) > at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown > Source) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(Unknown > Source) > at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown > Source) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(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.i nv > okeNext(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:60 1) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC on > nection(Http11Protocol.java:392) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56 5) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .j > ava:619) > at java.lang.Thread.run(Thread.java:534) > Caused by: java.sql.SQLException: Connection is closed. > at > org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnect io > n.java:245) > at > org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConne ct > ion.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]
