[C2] pooling setup question

[Gary Clark <ga...@jeld-wen.com>]

I'm trying to get pooling to work with esql under C2b1.  Without pools, it
works fine.  IE, if I use the following.

    <esql:driver>org.postgresql.Driver</esql:driver>
    <esql:dburl>jdbc:postgresql://localhost/develop</esql:dburl>
    <esql:username>devtool</esql:username>
    <esql:password></esql:password>

My cocoon.conf contains:

  <datasources>
    <jdbc name="devtool">
      <pool-controller min="5" max="10"/>
      <dburl>jdbc:postgresql://localhost/develop</dburl>
      <user>devtool</user>
      <password></password>
    </jdbc>
  </datasources>

When I change it to <esql:pool>devtool</esql:pool> I the the following
error:
org.apache.cocoon.ProcessingException: Failed to execute
pipeline.:org.apache.cocoon.ProcessingException: Failed to execute
pipeline.:org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():java.lang.RuntimeException: Could not get
the datasource java.sql.SQLException: You cannot get a Poolable before the
pool is initialized

So, how do I get the pool to initialize?  I've tried to find something in
the examples, but I must be missing something.

Gary A. Clark
Systems Programmer
Software Services Group
JELD-WEN Information Systems


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