[Zope-DB] Dynamically generate sql-query in ZSQL Method

Matthew T. Kromer matt at bane.mi.org
Wed Apr 7 19:02:22 EDT 2004

On Apr 7, 2004, at 6:29 PM, Ian Bicking wrote:

> Well, in one case I was commiting a credit card transaction after 
> sending it to the processor, but before rendering the result page, so 
> that an error in the result page can't keep me from saving the 
> transaction to the database.  And in general I'm not putting 
> persistent data into the ZODB, so I don't have to worry about 
> integrity across the two systems.
> And Zope won't really retry a transaction, will it?  That's just... 
> well, way to clever for anyone's good.  Plus I do get actual conflict 
> errors from the database, which would imply it isn't retrying them.  
> And with some RDBMS's you can't do that at all, like MySQL.  Do I 
> really have to worry about rerunning transactions?

Yes, if you have any doubts write an external method which prints to 
the console or something... watch it get reexecuted on ConflictErrors.

ConflictErrors are retried 3 times before the conflict is allowed to 
pass out in an error page.

You really do have to worry about re-running transactions.

More information about the Zope-DB mailing list