Connection Pool with DB2

[Annett Figge <an...@zurich.com>]

Hi all,

can anybody help us in solving our problem with connection pooling?

Trying to use a named pool like this
<esql:connection>
      <esql:pool>test</esql:pool>
...

results in the following runtime exception:

Error found handling the request.
java.lang.RuntimeException: Could not open pooled connection: test
     at _C_._ApacheGroup._Tomcat._webapps._cocoon._samples._db2test._allerollen.populateDocument(_allerollen.java:147)
     at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
     at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
     at org.apache.cocoon.Engine.handle(Engine.java:384)
     at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
     at org.apache.tomcat.core.Handler.service(Handler.java:286)
     at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
     at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
     at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
     at org.apache.tomcat.service.connector.Ajp13ConnectionHandler.processConnection(Ajp13ConnectionHandler.java:160)
     at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
     at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
     at java.lang.Thread.run(Thread.java:479)

Using "hard-coded" esql-connection like this
<esql:connection>
      <esql:driver>COM.ibm.db2.jdbc.app.DB2Driver</esql:driver>
      <esql:dburl>jdbc:db2:VGM</esql:dburl>
      <esql:username>debxxxx</esql:username>
      <esql:password>xxxxxxx</esql:password>
.....
in xsp-files works fine.

Our configuration:
Apache 1.3.12
Tomcat 3.2.1
Cocoon 1.8.2 with turbine-pool.jar 1.5
DB2 V7.1.1

Our cocoon-properties:
++++ snip

# Turbine DB Connection Pool
############################

# These are your database settings, look in the
# org.apache.turbine.util.db.pool.* package for more information.

processor.xsp.pool.database.test.driver=COM.ibm.db2.jdbc.app.DB2Driver
processor.xsp.pool.database.test.url=jdbc:db2:VGM
processor.xsp.pool.database.test.username=deb4948
processor.xsp.pool.database.test.password=glessen
processor.xsp.pool.database.test.maxConnections=5
processor.xsp.pool.database.test.expiryTime=3600000

# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.

processor.xsp.pool.database.adaptor=DBDB2Net,DBDB2App
processor.xsp.pool.database.adaptor.DBDB2App=COM.ibm.db2.jdbc.app.DB2Driver
processor.xsp.pool.database.adaptor.DBDB2Net=COM.ibm.db2.jdbc.net.DB2Driver

+++ snip

Any hint our idea is welcome.

Annett Figge


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>