Sybase database Transaction mode: chained and unchained

最新推荐文章于 2020-06-01 23:40:24 发布

原创最新推荐文章于 2020-06-01 23:40:24 发布 · 318 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#事务 #模式 #transaction #chained #sybase

Database 专栏收录该内容

24 篇文章

订阅专栏

本文探讨了在使用JDBC适配器时Sybase数据库的事务模式支持问题，特别是如何通过设置属性来切换到未链接模式，这对于运行依赖于该模式的现有存储过程至关重要。

[size=x-small]Support for Sybase database Transaction modes in JDBC Adapter
[url]https://www.ibm.com/developerworks/community/blogs/websphere_adapters/entry/jdbc_adapter_supported_transaction_modes_in_sybase?lang=en[/url]

[color=blue]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.[/color]

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

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

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