[Zope] Atomic ZSQL on Zope 2.7.5

[jpenny at ykksnap-america.com]

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

zope-bounces at zope.org wrote on 04/25/2006 10:38:30 AM:

> 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:

...

> 
> 
> 
> How can I detect failure and maintain atomicity?
> 
> 
> 
> 
> 
> Michael Maslak, Jr.
>