Distributed Transactions

http://developer.mimer.com

Distributed Transactions

Mimer SQL supports distributed transactions based on the XA interface as defined by Open Group and Microsoft's Distributed Transaction Coordinator (DTC) protocol.

This means that Mimer SQL can participate with other XA and DTC enabled systems to process transactions over different platforms and between databases from different vendors.

Mimer SQL can:

Log-in transaction managers
Associate a connection with a specific transaction
Perform operations on behalf of transactions
Validate transactions and secure them to disk
Rollback transactions
Commit transactions
Release transaction resources
Recover transactions

Note: Support for distributed transactions is not included in the standard Mimer SQL distribution. In order to implement distributed transactions, you must have the correct type of license. Contact Upright Database Technology AB for more information.

Terms and Abbreviations

In the field of distributed transactions, a number of terms and abbreviations are used. Here are the most common ones:

Term/Abbreviation

Short for

Explanation

XA

eXtended Architecture

An X/Open standard for distributed transaction handling. For more information, visit:
http://www.opengroup.org

DTC

Microsoft Distributed Transaction Coordinator

The transaction manager used in Windows environments. DTC is supported in Windows 95/98/NT/2000. For more information, visit: http://msdn.microsoft.com/library

Application Server

N/A

A program that handles all application operations between users and an organization's business applications or databases.

MTS

Microsoft Transaction Server

The Microsoft application server

EJB

Enterprise JavaBeans

The framework for application servers in the Java environment.

Requirements

A Transaction Manager (TM) must be present in the distributed transaction system. The TM handles the 2-phase commit protocol between all the parties involved in the transaction.

Term/Abbreviation	Short for	Explanation
XA	eXtended Architecture	An X/Open standard for distributed transaction handling. For more information, visit: http://www.opengroup.org
DTC	Microsoft Distributed Transaction Coordinator	The transaction manager used in Windows environments. DTC is supported in Windows 95/98/NT/2000. For more information, visit: http://msdn.microsoft.com/library
Application Server	N/A	A program that handles all application operations between users and an organization's business applications or databases.
MTS	Microsoft Transaction Server	The Microsoft application server
EJB	Enterprise JavaBeans	The framework for application servers in the Java environment.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se