change TIL(Transaction Isolation Level) without disconect, is it possible?

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
hamacker
Junior Boarder
Junior Boarder
Posts: 37
Joined: 13.10.2021, 15:15

change TIL(Transaction Isolation Level) without disconect, is it possible?

Post by hamacker »

Is it possible to change TIL without reconect a database?
Using zeos 7.2 without reconnect changing properties:
isc_tpb_concurrency, isc_tpb_nowait, isc_tpb_read, isc_tpb_write, isc_tpb_consistency, isc_tpb_read_committed, isc_tpb_rec_version
does not have any affect until disconect and reconect.
Is it allright?
Why Zeos does not have ZTransaction like others(SQLdb, Firedac,...) to change TIL(Transaction Isolation Level). One TIL to read data and other for updates.
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 766
Joined: 18.11.2018, 17:37
Location: Hungary

Re: change TIL(Transaction Isolation Level) without disconect, is it possible?

Post by aehimself »

Zeos 8 includes the TZTransaction object for this exact purpose I suppose :)
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: change TIL(Transaction Isolation Level) without disconect, is it possible?

Post by miab3 »

Hi hamacker,

Write(in your article) that you are talking about ZEOS 7.2.14, not ZEOS 8, which has some improvements.
These include additional components: ZTransaction, ZMemTable, server name unification,
ODBC and OLEDB protocols, and an overall increase in convenience and performance.
After all, where to get the most up-to-date versions of both, i.e .:
viewtopic.php?f=3&t=143817

Michał
hamacker
Junior Boarder
Junior Boarder
Posts: 37
Joined: 13.10.2021, 15:15

Re: change TIL(Transaction Isolation Level) without disconect, is it possible?

Post by hamacker »

Hi Michael,

Well, I fix some improvements in my article to serve both versions.
In the future, I will translate to english.
Post Reply