Hi Simon,

The problem is that I want to use multiple sessions, I think.

How would I have connections to multiple databases with differing schemas using a single Session?

cheers,

Chris

On 25/02/2014 18:14, Simon King wrote:
I've never used two-phase commit, but can you get away with just a
single session, like the example at:

    
http://docs.sqlalchemy.org/en/rel_0_9/orm/session.html#enabling-two-phase-commit

Simon

On Tue, Feb 25, 2014 at 6:07 PM, Chris Withers <ch...@simplistix.co.uk> wrote:
No takers? :'(


On 19/02/2014 18:43, Chris Withers wrote:

Hi All,

My other usual question now ;-)

I have multiple databases that I'm connecting to from my application. I
need to commit or rollback a single transaction across all of them.

So, two phase commit, right?

Okay, but how do I tie the sessions together? What and how do I call
commit?

Is there anything better than zope.transaction? (which does address this
need...)

Chris


--
Simplistix - Content Management, Batch Processing & Python Consulting
             - http://www.simplistix.co.uk

--
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.


--
Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk

--
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to