Transaction management

The Adapter for JDBC supports both local and XA transactions.

In the adapter, a transaction is an isolated interaction with the back-end database, or enterprise information system (EIS). A transaction can consist of multiple operations on the database that are performed as an atomic unit. These operations are not affected by simultaneously occurring operations from other client applications of the database.

The Adapter for JDBC supports transactions only if the back-end database supports transactions. The types of transactions that are supported are local and XA transactions:

The adapter supports XA transactions for IBM(R) DB2(R) and Oracle databases.

Use the properties XADataSourceName and XADatabaseName with XA transactions. See the "J2C connection factory properties" in the "Reference" section for details about these properties.
Note: If you are using a DB2 database, you must configure the XADatabaseName property.

The "Reference" section has example values for properties used with local and XA transactions.

Related reference
J2C connection factory properties
Reference

Terms of use |

Last updated: Thu Mar 23 13:24:30 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)