文档章节

'twophase' is an invalid keyword

rootliu
 rootliu
发布于 2017/09/10 21:55
字数 440
阅读 209
收藏 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
博文 252
码字总数 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

没有更多内容

加载失败,请刷新页面

加载更多

这周撸了两款小程序,分享下关键点。

本周撸了两款小程序,在这里总结下开发过程中的小经验,希望对大家有用。 小程序端 我们先说小程序要注意的地方。 ##默认入口转发问题 当一个小程序Page的js文件中存在 onShareAppMessage 方...

阿北2017
18分钟前
1
0
物联网技术很新吗?不!都是旧技术

通常,当我们想到物联网时,我们会想到新的、令人兴奋的现代技术。毕竟,还有什么比不用起床就能通过智能手机告诉咖啡机开始煮晨杯的“未来”更重要呢? 多亏了物联网,我们可以在世界任何地方...

linuxCool
25分钟前
1
0
利用责任链模式设计一个拦截器

前言 近期在做 Cicada 的拦截器功能,正好用到了责任链模式。 这个设计模式在日常使用中频率还是挺高的,借此机会来分析分析。 责任链模式 先来看看什么是责任链模式。 引用一段维基百科对其...

crossoverJie
44分钟前
2
0
属性动画

透明度 alpha 平移translationX/translationY 旋转 rotation 缩放 scaleX/scaleY 多个动画一起AnimatorSet 透明度 ObjectAnimator oa = ObjectAnimator.ofFloat(iv,"alpha" ......

lanyu96
44分钟前
1
0
Docker和Kubernetes如何让DevOps更具效力

缩短time-to-makrt对于任何一家企业都至关重要,这直接决定了客户满意度、市场竞争力乃至盈利能力。但在部署应用时,大多数企业内的IT团队都或多或少会遇到Dev和Ops之间的问题,这两个部门围...

好雨云帮
53分钟前
1
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部