cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From paint...@mc.duke.edu
Subject Re: Connection Pool with DB2
Date Fri, 01 Jun 2001 21:11:23 GMT

Annett,

your code looks right to me.  Did you restart Cocoon after defining your
pool in cocoon.properties?

-Christopher




Please respond to cocoon-users@xml.apache.org

To:   cocoon-users@xml.apache.org
cc:   "Guido Raunest" <guido.raunest@zurich.com>

Subject:  Connection Pool with DB2


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=debxxxx
processor.xsp.pool.database.test.password=xxxx
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message