Sybase database Transaction mode: chained and unchained

[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]