Subject RE: [Firebird-Java] Using Jaybird with OpenOffice
Author Rick Debay
Dan, did you file a bug report with OO?

-----Original Message-----
[] On Behalf Of Dan Wilson
Sent: Wednesday, March 29, 2006 7:10 AM
Subject: Re: [Firebird-Java] Using Jaybird with OpenOffice

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!


Yahoo! Groups Links