Subject | Re: [Firebird-Java] Using Jaybird with OpenOffice |
---|---|
Author | Roman Rokytskyy |
Post date | 2006-03-29T05:53:39Z |
> Every time I attempt to view a table, I get theReason for this is that OO opens result set and then executes another
> 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
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