25 Apr
2006
25 Apr
'06
7:59 p.m.
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@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.