Hi Laurence, thanks for the reply. These are good pointers.
Besides your suggested approach I am also trying something simpler as my use case is very specialized: 1) both Thread 1 and 2 write to completely different tables, 2) they are started both exactly after q2, 3) they (provably) affect/access different rows than q1 and q2, and 4) they are joined and their success/failure status and their pending transactions are obtained before q7 is issued. It is therefore possible to decide after q7 completed, whether all three transactions (main and the thread ones) succeeded, and if yes, all three are committed, otherwise all three are rolled back (which is essentially a two-phase commit protocol). However, the zope solution is more generic and will come in handy in less specialized scenarios. Thanks, Christian -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
