文档章节

'twophase' is an invalid keyword

rootliu
 rootliu
发布于 2017/09/10 21:55
字数 440
阅读 258
收藏 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
粉丝 4
博文 281
码字总数 2796
作品 0
海淀
数据库管理员
私信 提问
有没有朋友使用cx_oracle进行多库全局事务(xa)

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

钻石星辰
2011/05/11
577
0
《Oracle PL/SQL开发指南》学习笔记17——PL/SQL Basics (Review Section,Mastery Check)(第二部分)

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/hpdlzu80100/article/details/84454592 Exceptions Review Section This section has described the followin......

预见未来to50
11/24
0
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

没有更多内容

加载失败,请刷新页面

加载更多

如何解决 homebrew 更新慢的问题

之前一直困扰于 Homebrew 的更新速度,曾试过修改更新源(清华、中科大等)的方式,但是并没什么卵用;也试过设置 curl 代理的方式,但是 brew 走的好像不是 curl 的方式,所以也没用。 通过...

whoru
12分钟前
0
0
TiDB EcoSystem Tools 原理解读系列(二)TiDB-Lightning Toolset 介绍

简介 TiDB-Lightning Toolset 是一套快速全量导入 SQL dump 文件到 TiDB 集群的工具集,自 2.1.0 版本起随 TiDB 发布,速度可达到传统执行 SQL 导入方式的至少 3 倍、大约每小时 100 GB,适合...

TiDB
14分钟前
0
0
【Visual Studio 扩展工具】如何在ComponentOneFlexGrid树中显示RadioButton

概述 在ComponentOne Enterprise .NET控件集中,FlexGrid表格控件是用户使用频率最高的控件之一。它是一个功能强大的数据管理工具,轻盈且灵动,以分层的形式展示数据(数据呈现更加直观)。...

葡萄城技术团队
17分钟前
0
0
Maven环境隔离

Maven环境隔离 1. 什么是Maven环境隔离 顾名思义,Maven环境隔离就是将开发中的环境与beat环境、生产环境分隔开,方便进行开发和维护。这个在实际项目中用的还是很多的,如果你的项目用的Mav...

蚂蚁-Declan
17分钟前
1
0
day182-2018-12-19-英语流利阅读-待学习

“性感”时代已去,维密将如何转身? Daniel 2018-12-19 1.今日导读 维多利亚的秘密(Victoria's Secret)这个内衣品牌,最近似乎步入了“中年危机”——曾经打遍天下的“性感”内衣,在主打...

飞鱼说编程
17分钟前
2
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部