[sqlalchemy] Expected behaviour for Oracle's lost contact

2013-12-05 Thread Mariano Mara
Hi there, in one application I am using sqlalchemy 0.7.8 against Oracle 11 release 1 and I am hitting Oracle's lost contact more times than I would like to. Since the app seems unable to recover from the error, I have to restart it completely (it is a pyramid app). According to this

Re: [sqlalchemy] Expected behaviour for Oracle's lost contact

2013-12-05 Thread Michael Bayer
On Dec 5, 2013, at 10:54 AM, Mariano Mara mariano.m...@gmail.com wrote: Hi there, in one application I am using sqlalchemy 0.7.8 against Oracle 11 release 1 and I am hitting Oracle's lost contact more times than I would like to. Since the app seems unable to recover from the error, I have

Re: [sqlalchemy] Expected behaviour for Oracle's lost contact

2013-12-05 Thread Michael Bayer
also note if you really want to prevent disconnects at the top of a transaction, you can use a pessimistic approach, see http://docs.sqlalchemy.org/en/rel_0_9/core/pooling.html?highlight=pessimistic#disconnect-handling-pessimistic . On Dec 5, 2013, at 11:05 AM, Michael Bayer

Re: [sqlalchemy] Expected behaviour for Oracle's lost contact

2013-12-05 Thread Mariano Mara
On jue 05 dic 2013 16:19:14 ART, Michael Bayer wrote: also note if you really want to prevent disconnects at the top of a transaction, you can use a pessimistic approach, see http://docs.sqlalchemy.org/en/rel_0_9/core/pooling.html?highlight=pessimistic#disconnect-handling-pessimistic .