Return-Path: Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 15370 invoked from network); 15 Apr 2003 03:25:06 -0000 Received: from london-bridge.east.veritas.com (HELO hromime01.veritas.com) (207.30.27.2) by daedalus.apache.org with SMTP; 15 Apr 2003 03:25:06 -0000 Received: from lmoxch04.veritas.com (unverified) by hromime01.veritas.com (Content Technologies SMTPRS 4.2.10) with ESMTP id for ; Mon, 14 Apr 2003 23:25:15 -0400 Received: by lmoxch04.enterprise.veritas.com with Internet Mail Service (5.5.2656.59) id <2PYXFD0A>; Mon, 14 Apr 2003 23:25:15 -0400 Message-ID: <8BE017CC8923D511A00A0008C78605EE037B71F5@lmoxch04.enterprise.veritas.com> From: Chris Forbis To: 'Jakarta Commons Users List' Subject: RE: DBCP Issues Date: Mon, 14 Apr 2003 23:25:15 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: text/plain X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Besides putting the validate query XML in the context def, does anyone know if more is needed to get it to run the validation query? Like a validate = true or something? Also are there any good docs on how to use DBCP with JNDI and the tomcat context? Thanks -----Original Message----- From: Vic Cekvenich [mailto:vc@basebeans.com] Sent: Monday, April 14, 2003 5:45 PM To: commons-user@jakarta.apache.org Subject: Re: DBCP Issues its not active, but nothing to do it. It just works. travis@spaceprogram.com wrote: > Ya? I heard it is not active anymore? > > What about c3p0 on sourceforge, know anything about that one? > > Travis > > ---- Original Message ---- > From: Vic Cekvenich > Sent: 2003-04-14 > To: commons-user@jakarta.apache.org > Subject: Re: DBCP Issues > > 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 >>Sent: 2003-04-14 >>To: "'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(DelegatingConnectio n. >>java:245) >> at >>org.apache.commons.dbcp.DelegatingConnection.createStatement(DelegatingCon ne >>ction.java:170) >> at >>ast.apropos.eds.web.QSnapShotFields.updateSettingsInDB(QSnapShotFields.jav a: >>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(Applicati on >>FilterChain.java:247) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter Ch >>ain.java:193) >> at >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve. ja >>va:256) >> at >>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv ok >>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.inv ok >>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:1 80 >>) >> at >>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv ok >>eNext(StandardPipeline.java:643) >> at >>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv e. >>java:171) >> at >>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv ok >>eNext(StandardPipeline.java:641) >> at >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1 72 >>) >> at >>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv ok >>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.ja va >>:174) >> at >>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv ok >>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.processCon ne >>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.j av >>a:619) >> at java.lang.Thread.run(Thread.java:536) > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: commons-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org