If you have a version of Cocoon that is compiled with the latest
Avalon jars (Excalibur/Framework/LogKit), you can add in the element
<driver>com.company.jdbc.CompanyDriver</driver> and have it loaded
that way. Otherwise, you _must_ load your driver with the "load-class"
initial parameter specified in web.xml.
Check the FAQ.
Also, with the next version of Excalibur, you will get better error
reporting so that it will tell you what to do.
Sergio wrote:
>
> 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]>
