t was the sqlalchemy integration in airflow that was problematic.
Thanks again. You saved me hours (days) of work.
On Thursday, October 27, 2016 at 2:53:55 PM UTC+2, Vincent B. wrote:
>
> Thanks for this very detailled answer!
> It will take some time for me to investigate this.
>
> B
o fix their example to match the modern form which is at
>
> http://docs.sqlalchemy.org/en/latest/core/pooling.html#disconnect-handling-pessimistic.
>
>
>I would submit this to them.
>
>
>
>
> On 10/27/2016 03:46 AM, Vincent B. wrote:
> > Thanks again.
>
t;pool_timeout" parameter to a number of seconds less than this
> timeout.
>
>
>
> On 10/26/2016 10:24 AM, Vincent B. wrote:
> > Thanks for this answer.
> >
> > As you suggested i tried to connect, with success, to my database
> > through cx_oracle.
>
s would be something to email the cx_oracle
> list about . The error message looks like you're not able to establish a
> connection in the first place. You might want to create a plain cx_oracle
> test script at least to make the options and the error clear.
>
> On Oct 26, 2016
Hi,
I am using sqlalchemy 1.0.5, Airflow 1.7.1.3, Python 2.7 and Oracle 12.
I'm pretty much stuck with the integration of a connexion to Oracle through
sqlalchemy in an Airflow Airbnb script.
Here is my log from Airflow/sqlalchemy.
[2016-10-26 14:51:07,574] {base.py:719} INFO - COMMIT