Hi, thanks for your answers.
In my web.xml file, I've:
<init-param>
<param-name>load-class</param-name>
<param-value>
org.gjt.mm.mysql.Driver
</param-value>
</init-param>
Is it ok or not?
Regards.
> 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]>
>
---------------------------------------------------------------------
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]>
