[Libreoffice-bugs] [Bug 106463] Data Records Not Saved to External Firebird Database File

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106463

--- Comment #19 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Lionel Elie Mamane from comment #18)

> Most DBMSs have a mode where they "autocommit" at the end of each statement,
> and it is the default mode; it seems firebird does not, so IMO the SDBC
> driver should take care of issuing a commit at the end of each call to any
> of execute, executeQuery, executeUpdate in Statement.cxx and
> PreparedStatement.cxx

Searching a bit more around made me found the "isc_tpb_autocommit", which seems
to do what we want and may be easier than issuing a commit as an additional SQL
command. At least for DML statements, that seems to be meant to work "out of
the box".

For DDL statements, I'm not sure. Needs testing.

DML statement = statements that change *data* like UPDATE, INSERT, DELETE as
opposed to DDL statements that change data structure (CREATE TABLE, ALTER
TABLE, CREATE INDEX, etc).

https://www.firebirdsql.org/manual/isql-set.html says that in isql, to
autocommit DDL statements, one needs to issue one-time at connection "SET
AUTODDL ON". I'm not sure if that makes isql issue a "commit" statement to the
firebird core or if it sets an option in the firebird core.

OTOH, http://tracker.firebirdsql.org/browse/CORE-3825 seems to say they fixed a
but around how the isc_tpb_autocommit option interacts with DDL commands, so
maybe it works for DDL commands, too. Needs testing.

It would probably be useful to look at how the JDBC driver does it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190128/b8928cdc/attachment.html>