文档章节

'twophase' is an invalid keyword

rootliu
 rootliu
发布于 2017/09/10 21:55
字数 440
阅读 158
收藏 0

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

  2. Michael Bayer repo owner
    • changed component to oracle
    • changed milestone to 1.1.x
  3. 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

    → <<cset 1b98ce355a60>>

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

  5. Bohuslav Hosek reporter

    SQLAlchemy: 1.2.0b1 cx_Oracle : 6.0b1

    It's OK, thanks.

  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.

  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.

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

  9. Log in to comment

本文转载自:https://bitbucket.org/zzzeek/sqlalchemy/issues/3997/twophase-is-an-invalid-keyword

共有 人打赏支持
rootliu
粉丝 2
博文 244
码字总数 2796
作品 0
海淀
数据库管理员
微信模板信息推送

返回Json数据是:{"errcode":40001,"errmsg":"invalid credential, access_token is invalid or not latest hint: [qTIGaa0373vr51!]"} 一下是我的代码 用的JFainl 框架 ApiResult result=T......

香槟早已挥发得彻底
2017/07/24
45
0
有没有朋友使用cx_oracle进行多库全局事务(xa)

python使用cx oracle操作oracle,其中cxOracle.connect([user, password, dsn, mode, handle, pool, threaded, twophase, events, cclass, purity, newpassword])函数的twophase据cx_oracle......

钻石星辰
2011/05/11
567
0
KEIL C的FATAL ERROR L204

用Keil C命令bl连接OBJ时,出现类似 *** FATAL ERROR L204: INVALID KEYWORD POS: 87 PERIPH.OBJ, D:PROGRAM FILESCYPRESSUSBTARGETLIBLPUSBJMPTB.OBJ, # 这样的错误,POS指明了出错的位置。......

ZhengAlex
2012/10/09
0
0
在vmware虚机上用iscsi协议建立多路径环境测试multipath (4)

安装与配置DM-multipath 安装运行DM软件 # yum install device-mapper-multipath # /etc/init.d/multipathdrestart ok Stopping multipathddaemon: [ OK ] Starting multipathddaemon: [ OK......

leesbing
2017/04/09
0
0
Openfire 4.1.1 发布,即时消息传输平台

Openfire 4.1.1 发布了,Openfire 是实时的基于 WEB 的即时消息传输平台,是原来的 Jive Messenger。 更新内容: Bug 修复 [OF-1253] - Due to initial mysql schema failure, a new install...

王练
2017/01/01
2.8K
1

没有更多内容

加载失败,请刷新页面

加载更多

下一页

又一个centos文件顺序导致的问题

背景 新的centos似乎对于文件顺序做了特别的优化 和文件顺序出现的问题确实多了不少 centos7导致的spring循环依赖【实际上和这个问题不一样 不过由此衍生出的问题】 某应用放在新的系统开始报...

Mr_Qi
12分钟前
0
0
阿里云国际版香港CN2测评 月付9美元/30M带宽/1T流量

市面上很多家香港VPS服务商,一直都说阿里云国际版香港CN2线路好,延迟低,速度快,价格便宜流量还多,那么这个香港线路到底怎么样呢?本文从性能、延时、路由、速度方面来全方面测评一下阿里...

flyzy2005
54分钟前
0
0
撤销git commit --amend

it commit -amend之后想撤销 git reset HEAD@{1}

xiaomge
今天
0
0
有意思的TimeUnit

java.util.concurrent.TimeUnit 这个类,相信童鞋们都不陌生。它是一个enum: public enum TimeUnit 好吧,我一直把它当做一个枚举类来用。偶然看到还有别的用法,大吃一斤,原来 TimeUnit 并...

polly
今天
10
0
生成pyc

Python生成pyc文件 pyc文件是py文件编译后生成的字节码文件(byte code)。pyc文件经过python解释器最终会生成机器码运行。所以pyc文件是可以跨平台部署的,类似Java的.class文件。一般py文件改...

Mr_Tea伯奕
今天
0
0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

返回顶部
顶部