Daiju Kato Escribio :-)
> Hello all,
>
> Please assist me if you use Firebird.
>
> I try to connect Firebird database with Jaybird JDBC driver.
> Even though loading JDBC driver in web.xml, below error is encountered.
>
> Could not get the datasource
> org.apache.avalon.excalibur.datasource.NoValidConnectionException:
> No valid JdbcConnection class available
Hi, Daiju.
i think you do not have declare the class name of the driver
in web.xml.
for example:
for postgres is something like this:
<init-param>
<param-name>load-class</param-name>
<param-value>
org.postgresql.Driver
</param-value>
</init-param>
i think for firebird it's org.firebirdsql.jdbc.FBDriver.
i remember you need put the file firebirdsql-full.jar in
../WEB-INF/lib of you servlet.
Cheers,
--
Carlos Chávez
>
> I use cocoon 2.0.4, Jaybird 1.0.1 and Firebird 1.0.3.
>
> Please let me know if you know why.
>
>
> xsp file:
>
> <content>
> <esql:connection>
> <esql:pool>personnel</esql:pool>
> <esql:execute-query>
> <esql:query>select * from ZIPCODE</esql:query>
> <esql:results>
> <table>
> <esql:row-results>
> <tr>
> <td><esql:get-string column="ZIPCODE"/></td>
> <td><esql:get-string column="CITY"/></td>
> <td><esql:get-string column="STREET"/></td>
> </tr>
> </esql:row-results>
> </table>
> </esql:results>
> <esql:no-results>
> <p>no results were found</p>
> </esql:no-results>
> <esql:error-results>
> <p><esql:get-message/></p>
> <p><esql:get-stacktrace/></p>
> </esql:error-results>
> </esql:execute-query>
> </esql:connection>
> </content>
> </page>
> </xsp:page>
>
> cocoon.xconf:
> <datasources>
> <jdbc logger="core.datasources.personnel" name="personnel">
> <pool-controller max="10" min="5"/>
>
> <auto-commit>false</auto-commit>
>
>
> <dburl>jdbc:firebirdsql:localhost/3050:c:\\data\\zipcode.gdb?lc_ctype=sjis_0208</dburl>
> <user>SYSDBA</user>
> <password>masterkey</password>
> </jdbc>
> </datasources>
>
>
> Thanks.
>
> Daiju Kato
> e-mail:[EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
