Subject Re: [Firebird-Java] Using Jaybird with OpenOffice
Author Dan Wilson
On 3/29/2006 at 7:53 AM Roman Rokytskyy wrote:

> > Every time I attempt to view a table, I get the
> > following error:
> >
> > The data content could not be loaded.
> >
> > The result set is closed.
> >
> Reason for this is that OO opens result set and then executes another
> statement using the same connection object in auto-commit mode. In this
> case
> first result set is closed according to the JDBC specification. If you
> switch auto-commit mode off (I do not know whether it is possible in OO),
> everything will be fine.
> This behaviour (in other words, JDBC 3.0 compliance) was added/fixed in
> Jaybird 2.0.
> We have agreed to add connection property that would allow to switch this
> "feature" off.
> Roman

I installed Jaybird 1.5.6 for JRE 1.4, although I am using JRE 1.5, and the database is now accessible!

If I have understood you correctly, you changed Jaybird to be JDBC 3.0 compliant, and that uncovered a bug in the way OpenOffice works. While you did the correct thing in improving compliance, this makes Jaybird 2.0 unusable with OO. Perhaps one could add a warning to that effect on the site, so that innocent downloaders would know to take the older version of Jaybird?

Thanks for your help!