Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
To: commons-user@jakarta.apache.org
Path: not-for-mail
From: Vic Cekvenich <vc@basebeans.com>
Subject: Re: DBCP Issues
Date: Mon, 14 Apr 2003 17:02:26 -0400
Organization: baseBeans Engineering
Lines: 135
Message-ID: <b7f7l6$82l$1@localhost.localdomain>
References: <5786599.1050353252265.JavaMail.SYSTEM@bodisafa>
NNTP-Posting-Host: pcp01379980pcs.levtwn01.pa.comcast.net
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Date: Mon, 14 Apr 2003 21:02:30 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.3) Gecko/20030312
In-Reply-To: <5786599.1050353252265.JavaMail.SYSTEM@bodisafa>

A good one to use if Poolman on sourceforge, rock solid.

.V

travis@spaceprogram.com wrote:
> I have been having lots of issues too with DBCP including that one that you get.  I think I may be switching to a new db pool as I cannot fix it.  
> 
> It's 2 years old??  
> 
> Travis
> 
> ---- Original Message ----
> From: Chris Forbis <chris.forbis@veritas.com>
> Sent: 2003-04-14
> To: "'commons-user@jakarta.apache.org'" <commons-user@jakarta.apache.org>
> Subject: DBCP Issues
> 
> I am having some issues with the DBCP packages.
> 
>  
> 
> (Bellow is the exception)
> 
>  
> 
> I use it like suggested with Tocmat and tomcats JNDI.  And it seems to work
> perfect about 99% of the time.  But ever once and a while I get an
> exception.  After a little looking and testing I can tell that the
> connection I get back is fine, and I use it... but sometime in using it I
> get the error.  The connection does not seem closed, but the checkOpen code
> is saying it is.  Has anyone seen this?  Also the code for dbcp is over 2
> years old... is there something better to be using?
> 
>  
> 
> Thanks!
> 
>  
> 
> Chris
> 
>  
> 
>  
> 
>  
> 
> java.sql.SQLException: Connection is closed.
>         at
> org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.
> java:245)
>         at
> org.apache.commons.dbcp.DelegatingConnection.createStatement(DelegatingConne
> ction.java:170)
>         at
> ast.apropos.eds.web.QSnapShotFields.updateSettingsInDB(QSnapShotFields.java:
> 262)
>         at
> ast.apropos.eds.web.servlet.QSnapShotEdit.doPost(QSnapShotEdit.java:111)
>         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(Application
> FilterChain.java:247)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:256)
>         at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:191)
>         at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
> )
>         at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:171)
>         at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
> )
>         at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
> :174)
>         at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
>         at java.lang.Thread.run(Thread.java:536)