https://bugs.freedesktop.org/show_bug.cgi?id=77048

--- Comment #2 from Julien Nabet <[email protected]> ---
On this same url:
"
Please note, that each instance of FBEventManager will open a new socket
connection to the Firebird server on the port specified by Firebird.

Similar to other JDBC extensions in Jaybird, the interfaces are released under
the modified BSD license, the implementation of the code is released under LGPL
license.

Default holdable result sets (closed ResultSet in auto-commit mode)

This connection property allows to create holdable result sets by default. This
is needed as a workaround for the applications that do not follow JDBC
specification in regard to the auto-commit mode.

Specifically, such applications open a result set and, while traversing it,
execute other statements using the same connection. According to JDBC
specification the result set has to be closed if another statement is executed
using the same connection in auto-commit mode. Among others the
OpenOffice/LibreOffice Base users have problems with the JDBC compatibility in
Jaybird.

The property is called:

    defaultResultSetHoldable as connection property for JDBC URL or for
java.sql.DriverManager class and no or empty value should be assigned to it; it
has an alias defaultHoldable to simplify the typing;

    isc_dpb_result_set_holdable as a DPB member;

    FirebirdConnectionProperties interface methods isDefaultResultSetHoldable()
and setDefaultResultSetHoldable(boolean)

Note, the price for using this feature is that each holdable result set will be
fully cached in memory. The memory occupied by it will be released when the
statement that produced the result set is either closed or re-executed.
"

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to