Sybase database Transaction mode: chained and unchained - Inner peace - ITeye博客

`

darrenzhu

浏览: 782967 次
性别:
来自: 上海

最近访客更多访客>>

akingde

egozhm

arpenker

lesliehanhan

博主相关

博客

微博

相册

收藏

留言

关于我

文章分类

社区版块

存档分类

最新评论

qdujunjie：如果把m换成具体的数字，比如4或者5，会让读者更明白
m阶B树中“阶”的含义
java-admin：不错，加油，多写点文章
关于Extjs的mixins和plugin
xiehuaidong880827：你好，我用sencha cmd打包完本地工程后，把app.js ...
ExtJS使用Sencha Cmd合并javascript文件为一个文件
KIWIFLY： lwpan 写道inverse = "true&qu ...
Hibernate中什么时候使用inverse=true
luedipiaofeng： good
消除IE stop running this script弹出框

Sybase database Transaction mode: chained and unchained

博客分类：

Database

事务模式 transaction chained sybase

阅读更多

Support for Sybase database Transaction modes in JDBC Adapter
https://www.ibm.com/developerworks/community/blogs/websphere_adapters/entry/jdbc_adapter_supported_transaction_modes_in_sybase?lang=en

points:
JDBC's transactional support requires Connection.setAutoCommit(false) to be set, which forces Sybase into Chained mode. However, nearly all existing stored procedures are written exclusively for Unchained mode.

The JDBC Adapter uses the chained mode by default. Adapter provides a configurable property "Set Auto Commit on Database Connection" that should switch to unchained mode when the property is set to true.

Choosing a transaction mode
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/X82816.htm

Transaction modes and stored procedures
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/X82816.htm

Displays or changes the execution modes associated with stored procedures.
use System procedure sp_procxmode
http://infocenter.sybase.com/archive/index.jsp?topic=/com.sybase.help.ase_15.0.sprocs/html/sprocs/sprocs180.htm

分享到：

When and how to use a ThreadLocal | Notepad++的正则表达式替换和替换

2015-09-02 10:15
浏览 1389
评论(0)
分类:数据库
查看更多

评论

发表评论

您还没有登录,请您登录后再发表评论

相关推荐

transaction_processing_concepts_and_techniques: transaction_processing_concepts_and_techniques

Transaction Processing Concepts and Techniques: 事务处理:概念与技术英文版pdf,本书列举了大量成功的商业和研究系统的实例，此外，列出了许多事务处理算法的可编译的C代码片段。本书对于那些对实现分布式系统或客户-服务器结构感兴趣的人来说，是值得一读的。...

Transaction Processing_ Concepts and Techniques: JimGray大神事务神作，数据库从业人员必备书籍，本版本是英文原版djvu版本，大家可自己转换为PDF。

Distributed Transaction Processing The XA Specification.pdf: MySQL XA、Java事务API、atomikos等等，都是基于该规范做的实现。

Transaction Processing Concepts and Techniques 英文版: 数据库经典教材，主要介绍数据库事务等相关的理论。本书对于那些对实现分布式系统或客户-服务器结构感兴趣的人来说，是值得一读的。本书适合作为高校的教科书，也可作为计算机专业人员的参考书。

Oracle.Database.10g.Performance.Tuning.Tips&Techniques: Oracle.Database.10g.Performance.Tuning.Tips&Techniques

ERRORLOG: org.hibernate.TransactionException: JDBC rollback failed

Beyond Software Architecture: Creating and Sustaining Winning Solutions: Security Viruses, Hackers, and Pirates Digital Identity Management Transaction Security Software Security Information Security Secret Algorithms or Secret Keys?...

解决Missing artifact javax.transaction:jta:jar:1.0.1B: 1. 解压文件得到：jta-1_0_1B-classes.zip 2. cmd进入zip文件所在目录 ...mvn install:install-file -Dfile=./jta-1_0_1B-classes.zip -DgroupId=javax.transaction -DartifactId=jta -Dversion=1.0.1B -Dpackaging=jar

Database and Transaction Processing Performance: 描述如何开展数据库的相关测试，针对数据库事务处理测试方法和性能的评估方法。

Testing database transaction concurrency: Test DataBase 方法

Distributed Transaction Processing The XA Specification: Distributed Transaction Processing The XA Specification

ABAP BC490: ABAP培训BC490 学习ABAP不错的资料 BC490 ABAP Performance Tuning 0-1 ...ABAP Workbench 0-4 ...Analyzing Transaction Steps: R/3 Workload Monitor 2-7 Analyzing Transaction Steps: Response Time .........

redhat-config-cluster-1.0.0-5.noarch: linux群集软件，设置集群服务名，添加集群成员，设轩心跳线广播等

transactionservice:REST API，用于管理交易: 详细的api规范如下所示： PUT / transactionservice / transaction / $ transaction_id 身体： { " amount " : double , " type " : string , " parent_id " : long } 在哪里： transaction_id是指定新事务的长整数...

Pro.SQL.Server.Internals: Chapter 33: Column-Based Storage and Batch Mode Execution Chapter 34: Columnstore Indexes Part VIII: In-Memory OLTP Engine Chapter 35: In-Memory OLTP Internals Chapter 36: Transaction Processing in ...

Oracle Database Transactions and Locking Revealed(Apress,2014).: Transaction design in turn relies upon a good understanding of how the underlying database platform manages of the locking of resources so as to prevent access conflicts and data loss that might ...

PDO::inTransaction讲解: PDO::inTransaction PDO::inTransaction — 检查是否在一个事务内(PHP 5 >= 5.3.3, Bundled pdo_pgsql) 说明语法 bool PDO::inTransaction ( void ) 检查驱动内的一个事务当前是否处于激活。此方法仅对支持事务的...

Database System Implementation 2nd and solution: This textbook was designed for a second course in the computer science database sequence at Stanford, and is preceded by A First Course in Database Systems , 1997. It covers the implementation of a ...

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ….. this is incompatible with sq: 1、写在开头标题之前我想说一下Linux的mysql真的实在是太坑了。太坑了。总是会出现这样那样的你想不到的问题。崩溃了。首先来罗列一下我遇到过的一些问题吧。 1、大小写敏感 2、连接数超过系统最大连接数 ...

Global site tag (gtag.js) - Google Analytics