You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by Graham Leggett <mi...@sharp.fm> on 2003/12/09 23:20:15 UTC
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
RE: java.sql.SQLException: Connection is closed.
Posted by Amit Rana <ra...@solis.jp>.
We get a lot of similar problem as mentioned in
http://www.mail-archive.com/torque-user@db.apache.org/msg01537.html ,
haven't yet able to figure out what is causing it.
Amit.
> -----Original Message-----
> From: Graham Leggett [mailto:minfrin@sharp.fm]
> Sent: Wednesday, December 10, 2003 7:20 AM
> To: torque-dev@db.apache.org
> 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: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org