-----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: peter.vanbiesen@(protected)
PGP: http://www.vlafo.be/pgpkeys/peter.vanbiesen@(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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)