Subject Re: [Firebird-Java] ESQL with Firebird
Author Daiju Kato
Hello all,

After changing from cocoon 2.0.4 VM14 to cocoon 2.0,4 full version,
my program works fine.

Thanks.


Daiju

At 07:15 04/02/23, you wrote:
>At 01:44 AM 17/02/2004 +0900, you wrote:
> >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 and I try Firebird
> >1.5 RC9 and
> >Jyabird 1.5 Beta 3.
> >
> >Please let me know if you know why.
>
>As far as I understand it, you can't combine ESQL with an external
>connectivity layer at all. The gpre pre-compiler converts the ESQL blocks
>into host-language source code. Currently gpre is only available for C and
>Cobol, I think.
>
>You would need to write your own version of gpre in Java that implements
>the ESQL equivalents to the API functions that Jaybird maps to JDBC, i.e.
>translates the ESQL into something that Java can compile to pass the
>correct C structures to the server. The "gain" from doing that hardly
>justifies the effort.
>
>For a stand-alone embedded application it's simpler to abandon ESQL and
>write an ordinary DSQL client/server application that utilises the Jaybird
>classes. On Windows your Jaybird app can use the embedded server, on Linux
>it can use Classic.
>
>Hardly anyone seems to use ESQL these days...the one who would really KNOW
>how to answer your question is Ann Harrison. Ann doesn't watch this
>list. We normally discourage cross-posting, but I'm going to post this as
>a reply to your cross-posted message in firebird-support, with a note for
>Ann to step in and explain it for you (and me!)
>
>Helen
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>

===================================================
Daiju Kato
Technical Writer
e-mail:dkato@...
===================================================