<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Records Not Saved to External Firebird Database File"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106463#c19">Comment # 19</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Records Not Saved to External Firebird Database File"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106463">bug 106463</a>
from <span class="vcard"><a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> <span class="fn">Lionel Elie Mamane</span></a>
</span></b>
<pre>(In reply to Lionel Elie Mamane from <a href="show_bug.cgi?id=106463#c18">comment #18</a>)
<span class="quote">> 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</span >
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).
<a href="https://www.firebirdsql.org/manual/isql-set.html">https://www.firebirdsql.org/manual/isql-set.html</a> 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, <a href="http://tracker.firebirdsql.org/browse/CORE-3825">http://tracker.firebirdsql.org/browse/CORE-3825</a> 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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>