db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graham Leggett <minf...@sharp.fm>
Subject java.sql.SQLException: Connection is closed.
Date Tue, 09 Dec 2003 22:20:15 GMT
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


Mime
View raw message