I'm using MS SQL Server 2000 and eGenix mxODBC on W2K3
platform with Zope 2.7.5.
DTML method:
…
…
-
insertMAT ZSQL method:
BEGIN TRANSACTION
insert into mat1 (mat_id)
values ();
insert into mat2 (mat_id, mat_name)
values (, );
COMMIT TRAN
Am 29.08.2006, 22:42 Uhr, schrieb Maslak, Michael
<[EMAIL PROTECTED]>:
Can you please correct my mistake or my
misunderstanding?
Yes, you don't need to explicitly start and commit transactions in ZSQL as
Zoep does this for you.
Charlie
___
Zope
Am 30.08.2006, 00:35 Uhr, schrieb Maslak, Michael
<[EMAIL PROTECTED]>:
It is allowing a record to be committed in mat1 even as mat2 fails.
There is no roll back happening.
Normally, if you leave the transaction management to Zope and the RDBMS
can manage it, then all transactions will inde
Am 30.08.2006, 00:44 Uhr, schrieb Maslak, Michael
<[EMAIL PROTECTED]>:
Did what you suggested. That is, removed the BEGIN TRANSACTION & COMMIT
TRANSACTION statements. It has the same behavior: a non-atomic commit.
No roll back. mat1 has a new record mat2 errors.
Please keep your reply on lis