Re: [sqlalchemy] Expire SQLAlchemy session if Oracle node failover

2013-09-13 Thread Michael Bayer
failing over between database nodes is not something that is handled within SQLAlchemy, it's part of the functionality of your cx_Oracle driver as well as your tns setup. You should check with the cx_oracle list or perhaps google around some for correct TNS settings regarding this feature.

Re: [sqlalchemy] Expire SQLAlchemy session if Oracle node failover

2013-09-13 Thread Devraj Mukherjee
Thanks Michael. I was just making sure before I started digging any further. Cheers. On Sat, Sep 14, 2013 at 1:55 AM, Michael Bayer mike...@zzzcomputing.comwrote: failing over between database nodes is not something that is handled within SQLAlchemy, it's part of the functionality of your

[sqlalchemy] Expire SQLAlchemy session if Oracle node failover

2013-09-12 Thread Devraj Mukherjee
Hi all, We are using SQLAlchemy + cx_Oracle to connect to one of two Oracle nodes (setup to mirror the databases). Connection string as follows: oracle+cx_oracle://%s:%s@