Daiju Kato Escribio :-) > Carlos, > >> i think you do not have declare the class name of the driver >> in web.xml. > > I have already set class name in web.xml. > Please let me know if you know anything for the problem. > > thanks.
Well i do not remember any problem more. I configure web.xml, cocoon.xconf and copy firebirdsql-full.jar in WEB-INF/lib, restart cocoon and work. Try to see if the connection is open for the server of firebird i remember what the firebird show an icon in the task bar of windows, maybe the dburl is wrong. Another thing i remember is in the ESQL, we need put double quote in the name of field or tables, something like this: select * from "ZIPCODE" then if you use XSP you need use \" in the SQL: select * from \"ZIPCODE\" Cheers, Carlos Chávez. > > 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$BaW(Bez > > > > > > 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> > > > Daiju > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- Carlos Chávez -- Carlos Chávez --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
