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