Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-27 Thread Vincent B.
>> > > >> > > Le mercredi 26 octobre 2016 15:45:59 UTC+2, Mike Bayer a écrit : >> > > >> > > This is connectivity issues, I have no idea what airflow is, >> > however >> > > if you're dro

Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-27 Thread Vincent B.
ns this 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 c

Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-27 Thread mike bayer
> wrote: > > 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

Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-27 Thread Vincent B.
to create a plain cx_oracle test script at least to make the options > > and the error clear. > > > > > > On Oct 26, 2016 9:22 AM, "Vincent B." <mr.benoi...@gmail.com > > > wrote: > > > > Hi, > > > >

Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-26 Thread mike bayer
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] {bas

Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-26 Thread Vincent B.
9:22 AM, "Vincent B." <mr.benoi...@gmail.com > > wrote: > >> 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

Re: [sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-26 Thread Mike Bayer
nd=self.engine > > > This error "This connection is closed" is *not *raised when in airflow > "test" mode. I can connect and update my database and my python script > works perfectly. > However in airflow "run" mode it fails. > > I also

[sqlalchemy] sqlalchemy with airflow and Oracle

2016-10-26 Thread Vincent B.
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 [2016