Hi.,
As per my experience..poolable ... problems are
basically caused by the c2 not able to negotiate the
jdbc connection and the reasons could be ..
1. The database is not up(which should not be case
here)..
2. Pool name is wrong(which should not be case here)..
3. The driver is not loaded properly(which may be case
here)..
>From the example you noted here, the case where you
are <esql:driver> is working fine..which mean in case
of <datasources> the driver is not loaded(guessing)..
Please make sure the driver class name is specified in
web.xml under load-class param..
and also make sure in the cocoon.log that you see the
driver class loaded...
Hope this helps..
have g'day
--- florent barbare <[EMAIL PROTECTED]> wrote: > I
have the same errors. i'm looking for a solution
> too...
>
> Thanks
>
> Florent
>
> -----Original Message-----
> From: Sergio [mailto:[EMAIL PROTECTED]]
> Sent: jeudi 16 août 2001 21:23
> To: [EMAIL PROTECTED]
> Subject: Cannot get a Poolable before pool
> initialized
>
>
> Hi
> I'm working with Cocoon 2
>
> I receive this message when I try to create a
> connection with a datasource.
> The configuration of datasource in cocoon.xconf is:
>
> <datasources>
> <jdbc name="dbpccom">
> <pool-controller min="5" max="10"/>
> <auto-commit>false</auto-commit>
>
> <dburl>jdbc:mysql://localhost:3306/pccom</dburl>
> <user>pccom</user>
> <password></password>
> </jdbc>
> </datasources>
>
> When I try to access to DB without any datasource it
> works fine:
>
> <esql:connection>
> <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
>
>
<esql:dburl>jdbc:mysql://localhost:3306/pccom</esql:dburl>
> <esql:username>pccom</esql:username>
> <esql:password></esql:password>
> <esql:autocommit>false</esql:autocommit>
> ...
> ...
> ...
> </esql:connection>
>
> But if I try to use the datasource:
>
> <esql:connection>
> <esql:pool>dbpccom</esql:pool>
> ...
> ...
> ...
> </esql:connection>
>
> that is the error:
>
> 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
>
> ¿how can I initialize the pool?
>
>
>
---------------------------------------------------------------------
> 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:
> <[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <[EMAIL PROTECTED]>
>
>
>
---------------------------------------------------------------------
> 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:
> <[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <[EMAIL PROTECTED]>
>
=====
Thanks and have great day
srini
____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
