> I'm probably completely wrong about this, but in your example above, I > don't think the statement f_table.insert().execute() necessarily uses > the same connection as the ORM-level transaction and queries.
If I got it right, then, as far as I know, two transactions is impossible in one connection and most probably second thread is trying to change something in table that thread one is dealing with. > > Using SQL expressions with ORM transactions is covered in this section > of the docs: > > http://www.sqlalchemy.org/docs/04/session.html#unitofwork_sql > > Hope that helps, Not sure where is appropriate to use SessionContext (which is deprecated), sessionmaker, scoped_session, create_session and stuff. I've found this in documentation and this is just works ) : session = scoped_session(create_session) Is it necessary to specify transactional=True somewhere ? If yes, then where exactly ? Btw, I was using only ORM operations. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---