Subject Re: [Firebird-Java] JCA question
Author Roman Rokytskyy
Hi,

> Currently I'm using JBoss 4.0, Firebird 1.0.3 and Jaybird 1.0.1 on a
> linux box.

You can upgrade to JayBird 1.5.5, it will also work with Firebird 1.0.3.

> - Use Jaybird as a normal JDBC driver.
> - Use Jaybird as a JCA connector.
>
> I don't really know what the main advantages/drawbacks of each option
> are, but my first thought tells me to use Jaybird as a normal JDBC
> driver because of some misfunctions detected on the other mode in
> previous threads in this list. Is this a correct approach? Could I miss
> any important feature if I avoid the JCA alternative?

The only thing you miss is distributed transactions. However, in JCA mode
the only known (did I forget something) issue is that JayBird incorrectly
returns list of transactions "in limbo" (in other words, transactions that
were prepared but not committed).

> Jaybird's FAQ shows how to use Jaybird in the JCA fashion but I'm not
> sure how to use it on the other way. Could anybody give me some hints on
> that direction?

Just take any example from JBoss, for example HSQLDB one, change the name of
the driver and other params and go-go-go. :)

Roman