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