cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carlos Chávez <ccha...@agsoftware.dnsalias.com>
Subject Re: ESQL with Firebird
Date Mon, 16 Feb 2004 17:29:52 GMT

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:dkato@vmail.plala.or.jp
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message