Hi Steve, On Fri, 05 Sep 2008 11:51:15 -0500, Steve Lewis <spiritualmechanic@yahoo.com> wrote:

We're trying to use twisted as a sort of bus, a centralized place to manage all of our SOA enpoints (mostly through XML-RPC). We have a few services that access the Oracle DB directly (adbapi). In production we're getting intermittent ConnectionLost exceptions from cx_Oracle. Most of these are queries that take a couple of seconds.

Hmm, it is kind of hard to say what the problem could be, without seeing the code that is using adbapi and cx_Oracle. When you say you are receiving ConnectionLost exceptions from cx_Oracle, are they *really* from cx_Oracle, i.e., "ORA-03135 - Connection lost...", or are they just the result of adbapi calling its connectionLost method?

Has anyone seen this kind of behavior before? What we're probably going to do in the short term is just remove twisted from the equation for these methods that seem to be timing out. But we're relatively new to twisted and I wonder if we're doing something that's obviously wrong.

I've used cx_Oracle with twisted many times, with many different workloads, including stored procedures with OUT parameters, and it has always worked as expected. If you are able to provide some code, this list might be able to provide you with more prescriptive advice. Hope this helps, L. Daniel Burr

Hi Steve, On Fri, 05 Sep 2008 11:51:15 -0500, Steve Lewis <spiritualmechanic@yahoo.com> wrote:

We're trying to use twisted as a sort of bus, a centralized place to manage all of our SOA enpoints (mostly through XML-RPC). We have a few services that access the Oracle DB directly (adbapi). In production we're getting intermittent ConnectionLost exceptions from cx_Oracle. Most of these are queries that take a couple of seconds.

Hmm, it is kind of hard to say what the problem could be, without seeing the code that is using adbapi and cx_Oracle. When you say you are receiving ConnectionLost exceptions from cx_Oracle, are they *really* from cx_Oracle, i.e., "ORA-03135 - Connection lost...", or are they just the result of adbapi calling its connectionLost method?

Has anyone seen this kind of behavior before? What we're probably going to do in the short term is just remove twisted from the equation for these methods that seem to be timing out. But we're relatively new to twisted and I wonder if we're doing something that's obviously wrong.

I've used cx_Oracle with twisted many times, with many different workloads, including stored procedures with OUT parameters, and it has always worked as expected. If you are able to provide some code, this list might be able to provide you with more prescriptive advice. Hope this helps, L. Daniel Burr