文档章节

'twophase' is an invalid keyword

rootliu
 rootliu
发布于 2017/09/10 21:55
字数 440
阅读 114
收藏 0
点赞 0
评论 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
博文 222
码字总数 2796
作品 0
海淀
数据库管理员
微信模板信息推送

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

香槟早已挥发得彻底 ⋅ 2017/07/24 ⋅ 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 ⋅ 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

在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

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

Ext.Error: Unable to parse the JSON returned by the server: You're trying to decode an invalid JSON String

Firefox给出的错误 Ext.Error: Unable to parse the JSON returned by the server: You're trying to decode an invalid JSON String:...

anonymous_007 ⋅ 2014/05/28 ⋅ 2

控制 WebLogic 解压 war 包

在开发web应用时,如果通过weblogic的控制台部署war包,则weblogic默认在运行期不会解压war,这对于调试jsp颇为不便。 其实,只需一个简单的设置就可以强迫weblogic解开war,并且编辑jsp后w...

小编辑 ⋅ 2010/01/05 ⋅ 0

Entity Framework Core 1.0.1,大量 Bug 修复

Entity Framework Core 1.0.1 发布了,ADO.NET Entity Framework 是微软以 ADO.NET 为基础所发展出来的对象关系对应 (O/R Mapping) 解决方案,早期被称为 ObjectSpace。 该版本修复了大量的B...

局长 ⋅ 2016/09/16 ⋅ 4

Haproxy 1.5.7 正式发布,Web 负载均衡

Haproxy 1.5.7 正式发布,此版本现已提供下载,更新内容如下: A nasty bug reported by Dmitry Sivachenko can causehaproxy to die in some rare cases when a monitoring system issues a......

oschina ⋅ 2014/10/31 ⋅ 7

CUPS 2.0.2 发布,Unix/Linux 打印程序

CUPS 2.0.2 发布,此版本现已提供在:http://www.cups.org/software.php。 此版本修复了一个潜在的缓冲溢出问题,还有一些常规的 bug 修复: Security: cupsRasterReadPixels buffer overfl...

oschina ⋅ 2015/02/11 ⋅ 5

没有更多内容

加载失败,请刷新页面

加载更多

下一页

Thrift RPC实战(二) Thrift 网络服务模型

TServer类层次体系 TSimpleServer/TThreadPoolServer是阻塞服务模型 TNonblockingServer/THsHaServer/TThreadedSelectotServer是非阻塞服务模型(NIO) 1 TServer抽象类的定义 内部静态类Args的...

lemonLove ⋅ 5分钟前 ⋅ 0

vim命令用法

第五章 vim命令 vim和vi几乎是一样的,唯一的区别就是当编辑一个文本时,使用vi不会显示颜色,而使用vim会显示颜色。 vim有三个模式:一般模式,编辑模式,命令模式。 系统最小化安装时没有安...

弓正 ⋅ 7分钟前 ⋅ 0

MyBatis源码解读之配置

1. 目的 本文主要介绍MyBatis配置文件解析,通过源码解读mybatis-config.xml(官方默认命名)、Mapper.xml 与Java对象的映射。 2. MyBatis结构 查看大图 MyBatis结构图,原图实在太模糊了,所以...

无忌 ⋅ 10分钟前 ⋅ 0

Ignite的jdbc与网格的连接方式的查询性能对比

环境: 数据量100万 Ignite2.5 Windows10 8g jdbc方式连接 import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; i......

仔仔1993 ⋅ 25分钟前 ⋅ 0

收集自网络的wordpress 分页导航的代码教程(全网最全版)

wordpress 分页导航是用来切换文章的一个功能,添加了 wordpress 分页导航后,用户即可自由到达指定的页面数浏览分类文章,而这样的一个很简单功能却有很多朋友在用插件:WP-PageNavi,插件的...

Rhymo-Wu ⋅ 41分钟前 ⋅ 0

微服务 WildFly Swarm 入门

Hello World 就像前面章节中的其他框架一样,我们希望添加一些基本的 Hello-world 功能,然后在其上逐步添加更多的功能。让我们从在我们的项目中创建一个 HolaResources 开始。您可以使用您的...

woshixin ⋅ 48分钟前 ⋅ 0

Maven的安装和Eclipse的配置

1. 下载Maven 下载地址 2. 解压压缩包,放到自己习惯的硬盘中 此处我将其放到了 D:\Tools 目录下。 3. 配置环境变量 右键此电脑 -> 属性 -> 高级系统设置 -> 环境变量。 在系统变量中新建,变...

影狼 ⋅ 55分钟前 ⋅ 0

python pip使用国内镜像的方法

国内源 清华:https://pypi.tuna.tsinghua.edu.cn/simple 阿里云:http://mirrors.aliyun.com/pypi/simple/ 中国科技大学 https://pypi.mirrors.ustc.edu.cn/simple/ 华中理工大学:http://......

良言 ⋅ 56分钟前 ⋅ 0

对于url变化的spa应该如何使用微信jssdk

使用vue单页面碰上微信jssdk config验证失败的坑。第一次成功 之后切换页面全部失败,找到了解决方法,第一次验证成功后保存验证信息 切换页面时验证信息直接拿来用,加一个wx.error() 失败时...

孙冠峰 ⋅ 今天 ⋅ 0

Spring Cloud Gateway 一般集成

SCF发布,带来很多新东西,不过少了点教程,打开方式又和以前的不一样,比如这个SCG,压根就没有入门指导,所以这里写一个,以备后用。 一、集成 pom.xml <dependency> <groupI...

kut ⋅ 今天 ⋅ 0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

返回顶部
顶部