Hi Andreas,

Andreas Jung wrote:
>> For some reason I thought ZSQL method calls were atomic, but they appear
>> otherwise.
> What do you mean by atomic? ZSQL are handled by the database adaper
> which is usually tied to the transaction manager of the ZODB.

I'm too tired to find the words, so cut and pasted from answers.com: -

"Indivisible. An atomic operation, or atomicity, implies an operation
that must be performed entirely or not at all. For example, if machine
failure prevents a transaction to be processed to completion, the system
will be rolled back to the start of the transaction."

Like Michael, I had understood that ZSQL database transactions were tied
into Zope transactions, and would fail or succeed as a whole. Like him,
I have found that - at least with this combination of DA & RDBMS - this
is not so. I work around it, as I always do when a Microsoft product is
involved. If I hit the same thing with PostgreSQL, I'll look into it




PGP Public key: http://www.xfr.co.uk
Voicemail & Facsimile: 07092 070518

“The creative impulse animates whatever
instrument is placed at its disposal.”
— Robert Fripp
Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to