Philip Kilner wrote:
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
deeper...
I was under the impression that ZSQL methods were very much intended to
be atomic:
http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx#2-77
I know that it's been atomic to the point of frustration when working
with Zope and MySQL. Perhaps the database adapter is at fault here?
--
Floyd May
Senior Systems Analyst
CTLN - CareerTech Learning Network
[EMAIL PROTECTED]
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
