cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergio" <s...@alu.ua.es>
Subject Re: Cannot get a Poolable before pool initialized
Date Fri, 17 Aug 2001 19:48:09 GMT
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 <f.barbare@netia.fr> wrote: > I
> have the same errors. i'm looking for a solution
> > too...
> >
> > Thanks
> >
> > Florent
> >
> > -----Original Message-----
> > From: Sergio [mailto:sng2@alu.ua.es]
> > Sent: jeudi 16 août 2001 21:23
> > To: cocoon-users@xml.apache.org
> > 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:
> > <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail:
> > <cocoon-users-help@xml.apache.org>
> >
> >
> >
> ---------------------------------------------------------------------
> > 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>
> >
>
> =====
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>


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