RollBack not undoes the changes

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

doidopb
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 01.12.2012, 19:52

RollBack not undoes the changes

Postby doidopb » 30.06.2013, 18:22

Hello to all ...

I use Zeos with MYSQL in my Delphi applications with MYSQL 5.0.45.

After much searching, I finally found out why RollBack in my ZeosConnection never undoes the changes when i explicitly start the transaction with StartTransaction. This occurs when the ZConnection is TransactionIsolationLevel configured to tiNone.

Why does this happen??

Thanks

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 03.07.2013, 06:30

doidopb,

tiNone = no Transaction, so Zeos-Commits allways. change TransactionIsolationLevel to tiReadCommited. Or set TZConnection.AutoCommit := False;
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “6.6 - stable”

Who is online

Users browsing this forum: No registered users and 1 guest