'twophase' is an invalid keyword

2019独角兽企业重金招聘Python工程师标准>>>

'twophase' is an invalid keyword

Bohuslav Hosek created an issue 2017-05-23

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'

Comments (8)

1. 

   Michael Bayer repo owner

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

   • 2017-05-23

2. 

   Michael Bayer repo owner
   • changed component to oracle
   • changed milestone to 1.1.x
   • 2017-05-24

3. 

   Michael Bayer repo owner
   • changed status to resolved

   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>>

   • 2017-05-24

4. 

   Michael Bayer repo owner

   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>>

   • 2017-05-24

5. 

   Bohuslav Hosek reporter

   SQLAlchemy: 1.2.0b1 cx_Oracle : 6.0b1

   It's OK, thanks.

   • 2017-05-24

6. 

   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.

   • 2017-08-19

7. 

   Michael Bayer repo owner

   fly Go 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.

   • 2017-08-21

8. 

   Michael Bayer repo owner

   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>>

   • 2017-08-23
9. Log in to comment

转载于:https://my.oschina.net/rootliu/blog/1533826