the nesting should work fine I just added a small test case to check that. you can look at the test case and see if you can break it. the C1 below is closed because your T2 probably is committing for some reason but i dont know why.
On Feb 28, 2007, at 11:56 AM, Rick Morrison wrote: > Hi all, > > I'm trying to mix ORM transactions and SQL transaction as follows: > > T1 = S.create_transaction() > # do some ORM stuff > C1 = T1.connection() > C2.execute(sql) > > T2 = S.create_transaction () > # nested ORM stuff > > C2 = T2.connection() > C2.execute(sql) > > T2.commit() # should not commit (I think), but does! > > C1.execute(sql) # ERROR: this connection is closed > > Is this not supposed to work? > > Thx, > > Rick > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
