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:
XA eXtended Architecture An X/Open standard for distributed transaction handling. For more information, visit:
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.
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.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40