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 22:02:22 GMT


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: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>


-- 
Carlos Chávez



-- 
Carlos Chávez

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


Mime
View raw message