Subject Re: [Firebird-Java] Re: OpenOffice, Jaybird and Embedded Server
Author Roman Rokytskyy
>> There appears to be a separate driver plugin in Jaybird for
>> OpenOffice,
>> because OpenOffice (apparently) does some things wrong with
>> statements
>> and/or resultsets. This is however a variant of the pure-java driver
>> and
>> won't work with embedded.
>> I - unfortunately - think you are out of luck here.
> I am going to investigate this further, because a quick search does
> not
> turn up posts that other drivers have problems with this.

The issue is in autocommit mode - OO opens a result set and while
looping in the result set it tries to execute the statement. According
to the JDBC specs the result set has to be closed, which our driver
does. That is where OO crashes with SQLException.

The plugin provides workaround for this and it should work with all
driver types.