-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I'm trying to use dbcp with our 9.40/9.21/9.20/7.30 informix database,
but it always produces an exception : pool exhausted. The root cause
seems to be dbcp cannot create a validated object. I tried removing
the validation query, but the problem remains. If I set my factory to
org.objectweb.jndi.DataSourceFactory ( and install carol, jonas, jotm
etc ), everything works fine.
Is there a way to get the standard DBCP to connect to an informix
database ? I attached the ROOT.xml file with the datasource definition.
I'm sorry to post this here, but I did not find a mailinglist for dbcp ...
Thanks advance !
Peter.
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
pool exhausted, cause:
java.util.NoSuchElementException: Could not create a validated object
~ at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:851)
~ at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
~ at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
~ at
org.apache.jsp.iri_002dadmin.Z0Toevoegen_jsp._jspService(Z0Toevoegen_jsp.java:129)
~ at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
~ at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
~ at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
~ at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
~ at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
~ at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
~ at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
~ at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
~ at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
~ at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
~ at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
~ at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
~ at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
~ at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
~ at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
~ at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
~ at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
~ at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
~ at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
~ at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
~ at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
~ at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
~ at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
~ at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
~ at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
~ at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
~ at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
~ at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
~ at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
~ at java.lang.Thread.run(Thread.java:534)
- --
Peter Van Biesen
Adj. Sysadmin V.F.S.I.P.H.
tel: +32 (0) 2 225 85 70
fax: +32 (0) 2 225 85 88
e-mail: [EMAIL PROTECTED]
PGP: http://www.vlafo.be/pgpkeys/[EMAIL PROTECTED]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFAtK6SHtEPd3S05zgRAn3cAKCclthx4g+J/o8ERjWOGUFBDSt1hQCgnYKf
ChjtoaBYnApggsN+/rhvm4s=
=XvJK
-----END PGP SIGNATURE-----
<?xml version='1.0' encoding='utf-8'?>
<Context displayName="Welcome to Tomcat" docBase="ROOT" path="" workDir="work/Catalina/localhost/_">
<Resource name="jdbc/iri-brussel3" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/iri-brussel3">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<!-- <parameter>
<name>factory</name>
<value>org.objectweb.jndi.DataSourceFactory</value>
</parameter> -->
<parameter>
<name>password</name>
<value>weblogic</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:informix-sqli://brussel3.vlafo.be:1525/irijun00:informixserver=brussel3_tcp;dbdate=MDY4</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.informix.jdbc.IfxDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>weblogic</value>
</parameter>
</ResourceParams>
</Context>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
