Does MetaMatrix control transactions?

Solution Verified - Updated -

Environment

  • MetaMatrix Enterprise Server

Issue

  • Can MetaMatrix control the transaction between different datasource?

Resolution

The MetaMatrix JDBC driver supports three types of transactions from a client perspective – global, local, and request level. All three of these are implemented by the MetaMatrix Server as XA transactions.

The underlying enterprise information system and connector must support XA transactions. The JDBC XA Connectors supplied with the MetaMatrix System support transactions.

MetaMatrix supports the following JDBC data sources in distributed transactions. Other data source types are not yet supported. Some of these data sources require preparation in order to be involved in an XATransaction.
                •   Oracle
                     Version 9i
                     Version 10g
                     Version 11g
                 •   SQL Server
                     Version 2000
                     Version 2005
                 •   DB2
                     Version 8.1 or later
                 •   Sybase
                     Version 12.5 or later
                 •   MySQL
                     Version 5.x
                 •   PostGreSQL
                     Version 8.1

For more information regarding Transactions please refer to the MetaMatrix Client Developer's Guide.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments