Subject Re: [Firebird-Java] Using Jaybird with OpenOffice
Author Roman Rokytskyy
> 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.
>
> Clicking on "More" gives additional information:
>
> SQL Status: HY000
>
> 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