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

[Matthew T. Kromer]

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.