commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "srinath narasimhan" <srin...@nuviewinc.com>
Subject RE: DBCP Issues
Date Tue, 15 Apr 2003 15:54:49 GMT
<parameter>
	<name>testOnBorrow</name>
	<value>true</value>
</parameter>


-----Original Message-----
From: Chris Forbis [mailto:chris.forbis@veritas.com]
Sent: Tuesday, April 15, 2003 11:09
To: 'Jakarta Commons Users List'
Subject: RE: DBCP Issues


Do you know how these get set in the XML?  I have seen examples using jocl
files that digester picks up, but with the tomcat servlet.xml context setup
I am a little lost (seems to be very little docs on it)


-----Original Message-----
From: srinath narasimhan [mailto:srinath@nuviewinc.com]
Sent: Tuesday, April 15, 2003 9:37 AM
To: Jakarta Commons Users List
Subject: RE: DBCP Issues



I think You also need to set isTestOnBorrow, isTestOnReturn, isTestOnIdle
flags, depending when you want to validate.


-----Original Message-----
From: Chris Forbis [mailto:chris.forbis@veritas.com]
Sent: Monday, April 14, 2003 23:25
To: 'Jakarta Commons Users List'
Subject: RE: DBCP Issues


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 <vc@basebeans.com>
> 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 <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(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

---------------------------------------------------------------------
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

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message