'twophase' is an invalid keyword

[Bohuslav Hosek]

I have problem,

engine=sqlalchemy.create_engine('oracle+cx_oracle://user:password@dsn') connection=engine.connect()

TypeError: 'twophase' is an invalid keyword argument for this function

sqlalchemy.version '1.1.10' cx_Oracle.version '6.0b1'

[Mike Bayer]

cx_Oracle 6.0b1 is in beta, I would suggest using the official release which is 5.3.

[Mike Bayer]

Remove twophase for cx_Oracle 6.x

Support for two-phase transactions has been removed entirely for cx_Oracle when version 6.0b1 or later of the DBAPI is in use. The two- phase feature historically has never been usable under cx_Oracle 5.x in any case, and cx_Oracle 6.x has removed the connection-level "twophase" flag upon which this feature relied.

Change-Id: I2e8161cc2bc12f4845c9224cd483038112fe9734 Fixes: #3997

→ <<cset 1b98ce355a60>>

[Mike Bayer]

Remove twophase for cx_Oracle 6.x

Support for two-phase transactions has been removed entirely for cx_Oracle when version 6.0b1 or later of the DBAPI is in use. The two- phase feature historically has never been usable under cx_Oracle 5.x in any case, and cx_Oracle 6.x has removed the connection-level "twophase" flag upon which this feature relied.

Change-Id: I2e8161cc2bc12f4845c9224cd483038112fe9734 Fixes: #3997 (cherry picked from commit 1b98ce355a60b7ad9898aeb412c21591bb438231)

→ <<cset 41e92f855815>>

[Bohuslav Hosek]

SQLAlchemy: 1.2.0b1 cx_Oracle : 6.0b1

It's OK, thanks.

[fly Go]

How to solved it? I can only install cx_Oracle 6 instead of 5. Because cx_Oracle 5 need oralce include folder which I don't know how to download. I don't know how two-phase comes in my oracle.

[Mike Bayer]

@gclsoft the fix is released as of 1.1.11. for either cx_Oracle, 5 or 6, you need the oracle client libraries in order to run it (maybe not on windows) but in any case you can get those libraries from http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html. you don't have to run the database just install the packages.

[Mike Bayer]

Remove twophase for cx_Oracle 6.x

Support for two-phase transactions has been removed entirely for cx_Oracle when version 6.0b1 or later of the DBAPI is in use. The two- phase feature historically has never been usable under cx_Oracle 5.x in any case, and cx_Oracle 6.x has removed the connection-level "twophase" flag upon which this feature relied.

Change-Id: I2e8161cc2bc12f4845c9224cd483038112fe9734 Fixes: #3997 (cherry picked from commit 1b98ce355a60b7ad9898aeb412c21591bb438231) (cherry picked from commit 41e92f85581589fd011f93c86b81439f71237433)

→ <<cset 919b9b362fb6>>