if you separate them as 3 separate ZSQL methods (or class attributes if
you're using zsql via a python product) and try again, do you get the
same unatomic behaviour?
I'm always using Postgresql databases and I've been using PoPy for the
DA but now I'm always using ZPsycopgDA. Atomicity has
I think that your problem is in the fact that you have fed them all in
one long string (and may have autocommit on.)
If they were separate ZSQL methods, they would, in my experience,
roll back.
I recommend separating them into separate methods, with one insert
per method.
jim penny
[EMAIL PROT
Hi Michael,
Maslak, Michael wrote:
> How can I detect failure and maintain atomicity?
>
You may get more responses to this on the Zope-DB list - as well as
other RDBMS + Zope users, the eGenix guys are active over there (or as
active as you can be on such a quiet list).
--
Regards,
PhilK
E
Maslak, Michael wrote at 2006-4-25 10:38 -0400:
>
>For some reason I thought ZSQL method calls were atomic, but they appear
>otherwise.
Your database decides whether they are atomic or not.
It is not a ZSQL feature.
> ...
>Using an eGenix mxODBC Database Connection at
>/Database/PoPy_database_co
Hi Floyd,
Floyd May wrote:
>> 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 d
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 th
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
--On 25. April 2006 10:38:30 -0400 "Maslak, Michael" <[EMAIL PROTECTED]>
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
For some reason I thought ZSQL method calls were atomic, but
they appear otherwise.
Using an eGenix mxODBC Database Connection at /Database/PoPy_database_connection
to a SQL Server 2000 back end, I have created a Python script to write SQL
commands and feed them in one large string:
