Hello, I'm deploying a Pylons/TG app that uses SQLAlchemy into a customer's server network. Due to their network architecture, TCP sessions from SA to the Oracle server are getting timed out by their Ciscos. My application needs to work around this.
I heard that Mike Bayer had stated that SQLAlchemy won't be able to cope with database outages properly, however, the next request after a timeout/disconnection will try again. I assume this is causing the sporadic errors I am receiving, such as: "AttributeError: 'unicode' object has no attribute '_sa_instance_state'" inside sqlalchemy.orm.attributes 'UndefinedError: None has no member named "name"' from a Genshi template containing $item.name where 'item' is a model class instance. Is there a way to configure a connection keepalive, regular pinging of the DB, or otherwise make sure that pool connections are recycled within a given time limit? Thanks, -- Teemu Yli-Elsilä --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---