Re: [Twisted-Python] cx_Oracle, Twisted - rollback failed
![](https://secure.gravatar.com/avatar/be3dcda23ab11fb4f4ae0610f4c5edd4.jpg?s=120&d=mm&r=g)
Oops, I actually did see my message going through now. Sorry for the duplicate. To answer your question, I was under the impression that the cp_reconnect would check to see if the connection existed already. Is there a way to have it check that query before rolling back? I'm guessing other databases/apis don't throw exceptions on a rollback if the connection is gone? Steve
![](https://secure.gravatar.com/avatar/fcc237fd34a8e504f7224df0c58cc0b3.jpg?s=120&d=mm&r=g)
Steve Lewis wrote:
The cp_reconnect flag tells the pool to re-open connections that have failed the next time they are accessed. The query that 'discovers' the lost connection will still fail and receive the ConnectionLost exception. When the reconnect flag is false, lost connections simply aren't detected and continue to fail. dave
![](https://secure.gravatar.com/avatar/fcc237fd34a8e504f7224df0c58cc0b3.jpg?s=120&d=mm&r=g)
Steve Lewis wrote:
The cp_reconnect flag tells the pool to re-open connections that have failed the next time they are accessed. The query that 'discovers' the lost connection will still fail and receive the ConnectionLost exception. When the reconnect flag is false, lost connections simply aren't detected and continue to fail. dave
participants (2)
-
Dave Peticolas
-
Steve Lewis