On 8-3-2015 02:51, Keith Laten Williams klwilliams@...
[Firebird-Java] wrote:

>
>
> Mark Rotteveel wrote:
>
> | I am able to reproduce this
> | with LibreOffice base and your
> | test database. The cut off point
> | of 41 seems related to how
> | many records LibreOffice itself
> | caches.
>
> Then it seems there is some divergence with Apache OpenOffice for which
> the number is 40.

It does sound like an off-by-one error ;)

> Mark Rotteveel also wrote:
>
> | Contrary to my expectations,
> | the OpenOffice protocol
> | implementation in Jaybird
> | doesn't use holdable resultsets
> | by default. The fix is to specify
> | the connection property
> | defaultHoldable=true
> | in the connection string.
> | I will see if I can change this in
> | the next release of Jaybird.
>
> Thank you for the fix and for your attempt to get this into the next
> Jaybird release. Arioch The, thank you, it appears your line of thinking
> bore fruit. I am happy to report that in my production database the
> additional connection property eliminated the error message I saw and
> caused the database to perform as expected (in both LibreOffice and
> Apache OpenOffice). Mark, I will post a summary of the problem (and your
> fix) on a LibreOffice message board and on an Apache OpenOffice message
> board.

The OpenOffice/LibreOffice compatibility is a bit of a pain point for
Jaybird. As far as I can tell LibreOffice and OpenOffice have some
expectations that don't entirely match those of JDBC, and on the other
hand some bugs in Jaybird that you'd normally not notice are very
noticeable in Base.

I also tried the built-in Firebird support (available if experimental
features are enabled), but I wasn't able to connect, but that might have
been related to having Firebird 3 installed on this machine as well.

Mark
--
Mark Rotteveel