transaction options for a JDBC data source
The transaction protocol for a JDBC data source determines how
connections from the data source are handled during transaction
processing. For more information, see Transaction Options
Note: If the data source uses an XA JDBC driver to create
database connections, connections from the data source will support the
two-phase commit transaction protocol only. No other transaction options
are available for data sources that use an XA JDBC driver.
To configure transaction options for a JDBC data source:
If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
Domain Structure tree, expand
Services > JDBC, then select Data
Summary of Data Sources page, click the data
Configuration: Transactions tab.
Select global transaction options:
Supports Global Transactions - Select
this check box (the default) to enable global transaction support in
this data source. Clear this check box to disable (ignore) global
transactions in this data source. In most cases, you should leave
the option selected.
If you selected Supports Global
Transactions, select an option for transaction
Logging Last Resource - Select this
option to enable a non-XA JDBC connection to participate in global
transactions using the Logging Last Resource (LLR) transaction
optimization. Recommended in place of Emulate Two-Phase
Emulate Two-Phase Commit - Enables a
non-XA JDBC connection to emulate participation in distributed
transactions using JTA. Select this option only if your application
can tolerate heuristic conditions.
One-Phase Commit - Select this option
to enable the non-XA connection to participate in a global
transaction as the only transaction participant.
To activate these changes, in the Change Center of the Administration Console, click Activate Changes. Not all changes take effect immediately—some require a restart (see Use the Change Center).