Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

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:

  1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
  2. In the Domain Structure tree, expand Services, then select Data Sources.
  3. On the Summary of Data Sources page, click the data source name.
  4. Select the Configuration: Transactions tab.
  5. 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 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.
    • 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.
  6. Click Save.
  7. 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).

Back to Top