Administration Console Online Help

Configure global
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).

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
processing:

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
Commit.