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

I use cocoon 2.0.4, Jaybird 1.0.1 and Firebird 1.0.3 and I try Firebird
1.5 RC9 and
Jyabird 1.5 Beta 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:dkato@...