ZeosLIb Transactions
lazarus / 16-Databases

----------------------------------------------------------------------
mariodosreis · 2022-01-29 11:31

Well i'm kind of new around here.
I just don't understand how to assigne a zTransaction to a
zConnection?!
As far as i realize this component is missing and it 's provided with
ZeosLib 8.0, but i'm not able to find it for download!?
Mean while how to deal with Zeoslib 7.2.14 for instance
Can you help?
Best regard's

----------------------------------------------------------------------
marsupilami79 · 2022-01-29 13:16

Hello mariodosreis,

Zeos 8 isn't released yet. So your only option is to get a snapshot
from our SVN (see here) or from my copy on Github (see here).

For most sitzuations you don't need TZTransaction. Just use
TZConnection.StartTransaction / TZConnection.Commit and
TZConnection.Rollback to manage an explict transaction on the main
connection. TZTransaction gets used if you need multiple transactions
in parralel on one connection. One note though: TZTransaction will
create a new connection for drivers that don't support multiple
transactions for one connection. In Zeos this means all drivers
besides Firebird.

Best regards,

Jan

----------------------------------------------------------------------
miab3 · 2022-01-30 10:48

Jan did not mention that Zeos works by default in AutoCommit mode and
(if you do not change it, e.g. by TZConnection.StartTransaction) he
opens and approves transactions himself

Michał

----------------------------------------------------------------------
mariodosreis · 2022-02-01 19:24

Thank you