Page 1 of 1

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

Posted: 21.02.2022, 21:22
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.

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

Posted: 22.02.2022, 08:13
by aehimself
Zeos 8 includes the TZTransaction object for this exact purpose I suppose :)

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

Posted: 23.02.2022, 09:14
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Ƃ

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

Posted: 24.02.2022, 15:04
by hamacker
Hi Michael,

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