TZConnection::AutoCommit

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
jjeffman
Senior Boarder
Senior Boarder
Posts: 56
Joined: 25.08.2005, 12:40
Location: Porto Alegre

TZConnection::AutoCommit

Post by jjeffman »

I would like some information on how to control the database transactions using the TZConnection Zeos component.
I might be wrong but for me is a very strange behavior having to set up AutoCommit to true for calling StartTransaction, Commit and Rollback. All other components I have been working with use the AutoCommit set to true when you do not want to control the transaction by yourself.

When will the Help files or documentation on Zeos Database components be available ?
User avatar
skozan
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 06.10.2005, 11:23
Contact:

Post by skozan »

With AutoCommit set to True, every SQL statement is (auto)commited. When StartTransaction is executed then all statements are executed on the Commit.
jjeffman
Senior Boarder
Senior Boarder
Posts: 56
Joined: 25.08.2005, 12:40
Location: Porto Alegre

Post by jjeffman »

The way you described is just the way I use with other database components like ODAC (www.crlab.com) . If you have a look at the code of the TZConnection component you will see that you "must" be in auto-commit mode to call the StartTransaction method. That is what seems to me very strange.
Jayme Jeffman Filho

DBA, Software Engineer
Sul Engenharia e Sistema Ltda

http://www.sulenge.com.br
darkbrain
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 28.12.2005, 11:56

Post by darkbrain »

Yes it's strange also for me, and the lack of documentation doesn't help. Anyway this article helped me: http://seegernet.koolhost.de/zeosforum/ ... rticle&k=6
when i start a manual transaction it's turned off automatically.
In practice Autocommit can't be false, so why is here?

bye,
DarkBrain
Post Reply