> i try to run the tutorial and every time i get an exception :
>
> Original exception :
> org.apache.avalon.excalibur.datasource.NoValidConnectionException:
> No valid JdbcConnection class available at
>
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance
> (JdbcConnectionFactory.java:164) at
> org.apache.avalon.excalibur.pool.ResourceLimitingPool......

Have you got the jars containing the jdbc drivers for MySql in the
<cocoon-dir>/WEB-INF/libs directory?

> to work around the problem i have modified the .xsp file putting
> there inside the jdbc tags (driver, url ...) just before the
> connection in the esql tags ; in this it runs ... so i think

The url, password etc go in <cocoon-dir>/WEB-INF/cocoon.xconf, eg for
sqlserver:
<datasources>
    <!-- other jdbc datasources  -->
    <jdbc logger="core.datasources.personnel" name="personnel">
        <pool-controller min="5" max="10" oradb="true"/>
        <pool-controller max="10" min="5"/>
        <auto-commit>false</auto-commit>
        <dburl>jdbc:microsoft:sqlserver://<server-name>:1433</dburl>
        <user>sacopy</user>
        <password>password</password>
    </jdbc>
</datasources>




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to