Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: CommitRetaining instead of Commit



Permlink Replies: 1 - Last Post: Jul 8, 2016 2:39 AM Last Post By: Dmitry Arefiev
Andrea Bettin

Posts: 6
Registered: 12/12/15
CommitRetaining instead of Commit
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 4, 2016 7:26 AM
I'm using XE7 & FB 2.5.4.
I want to use CommitRetaining instead of Commit for each transcantion. I have activated this option:

db.TxOptions.StopOptions:= db.TxOptions.StopOptions + [xoFinishRetaining];

but when I open a query the application goes into infinite loop. This is the log from the monitor:

..
Commit [ConnectionDef="", Retaining=True]
Commit [ConnectionDef="", Retaining=True]
Commit [ConnectionDef="", Retaining=True]
Commit [ConnectionDef="", Retaining=True]
..

I attach the minimal example that duplicates the behavior [https://drive.google.com/open?id=0B66zhuObV8pxcXhmaGVUSVFSczA]
Why do I get this behavior?

Edited by: Andrea Bettin on Jul 4, 2016 7:26 AM
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: CommitRetaining instead of Commit
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 8, 2016 2:39 AM   in response to: Andrea Bettin in response to: Andrea Bettin
Thank you for reporting that. Fixed. I posted patch at:
https://forums.embarcadero.com/thread.jspa?threadID=217370

--
With best regards,
Dmitry

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02