If you are using Tomcat/Catlina try putting the jdbc driver in catalina/common/endorsed this may help? If not post more information.
Rob -----Original Message----- From: Daiju Kato [mailto:[EMAIL PROTECTED] Sent: 15 February 2004 20:34 To: [EMAIL PROTECTED] Subject: ESQL with Firebird 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. 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=sj is_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]
