/ jaybird Public
LibreOffice doesn't display tables with more than 41 records [JDBC383] #425
affect-version: Jaybird 2.2 affect-version: Jaybird 2.2.1 affect-version: Jaybird 2.2.2 affect-version: Jaybird 2.2.3 affect-version: Jaybird 2.2.4 affect-version: Jaybird 2.2.5 affect-version: Jaybird 2.2.6 affect-version: Jaybird 2.2.7 component: jdbc driver fix-version: Jaybird 2.2.8 fix-version: Jaybird 3.0.0 priority: major resolution: fixed type: bug
Submitted by: @mrotteveel
LibreOffice doesn't display tables with more than 41 records, even when using the :oo subprotocol. Workaround is to specify defaultHoldable=true in the connection string. The reason seems to be that LibreOffice caches 41 records, and uses the ResultSet when you scroll to record 42 or further (which is then already closed).
Either the protocol must use defaultHoldable=true by default, or we need to investigate how to address this specific problem.
See also: https://groups.yahoo.com/neo/groups/Firebird-Java/conversations/messages/11096
The text was updated successfully, but these errors were encountered: