This chapter describes Microsoft Transaction Server and Oracle Database integration.
This chapter contains these topics:
Microsoft Transaction Server is a proprietary component object model (COM) transaction processing system that runs on an Internet or network server. Microsoft Transaction Server deploys and manages application and database transaction requests on behalf of a client computer. Microsoft Transaction Server provides:
ActiveX/distributed component object model (DCOM) programming model to develop distributed applications and a runtime environment in which to deploy these applications.
Atomicity, Consistency, Isolation, and Durability (ACID) properties for components in transactions.
Access to performance-enhancing features such as component caching and database connection pooling.
Microsoft Transaction Server is a component of the three-tiered, server-centric architecture model. This model lets you separate the presentation, business logic, and data elements of applications onto different computers connected in a network. Microsoft Transaction Server functionality is also implemented in COM+ and Enterprise Services. Oracle Services for Microsoft Transaction Server, or OraMTS, support Microsoft Transaction Server, COM+, and Enterprise Services.
See Also:
Microsoft documentation for additional information about Microsoft Transaction ServerOracle Services for Microsoft Transaction Server supports distributed transactions set to a serializable and read-committed isolation level.
Oracle Services for Microsoft Transaction Server works with Microsoft Distributed Transaction Coordinator (DTC), which is part of the Enterprise Services component of .NET. DTC implements a two-phase commit protocol that makes sure that the transaction outcome is consistent across all data resources involved in a transaction.
Without any special integration, you can deploy applications that were created using Win32, Win64, COM, or Microsoft .NET in a Microsoft Transaction Server that connects to an Oracle Database. To use either of the following features, however, you must install Oracle Services for Microsoft Transaction Server (OraMTS):
Register the Win32, Win64, COM or .NET application as transactional and have Microsoft Transaction Server control the transaction. You can do this by using the Properties dialog box of the component in the Microsoft Management Console Explorer.
Use client-side connection pooling in Microsoft Transaction Server.
After you have installed Oracle Services for Microsoft Transaction Server, an Oracle MTS Recovery Service is also automatically installed on the same computer. The Oracle MTS Recovery Service helps in the recovery of in-doubt transactions left in Oracle Database instances that originated from this computer. On each connected database:
Create the Microsoft Transaction Server administrator user account.
Schedule a database-level transaction recovery job.
This enables the database to participate in Microsoft Transaction Server-started transactions.
Create the COM component with any of the following Oracle products:
Access the Oracle Database using any .NET application using Oracle Data Provider for .NET (ODP.NET).
You are now ready to use Microsoft Transaction Server with a database. To get started quickly, follow these steps:
Install the Oracle and Microsoft products required for Microsoft Transaction Server and database integration.
Migrate from a previous release of Oracle Services for Microsoft Transaction Server.
Create the Microsoft Transaction Server administrator user account.
Schedule a Microsoft Transaction Server transaction recovery job.
Run the Microsoft application demo.
See Chapter 4, "Running the Microsoft Application Demo" for information about running an application demo that:
Uses transactional components hosted by Microsoft Transaction Server
Accesses a database in a transaction controlled by Microsoft Transaction Server
Create Microsoft Transaction Server-hosted applications.
See Chapter 5, "Programming with Microsoft Transaction Server and an Oracle Database" for instructions on using OCI, OO4O, Oracle ODBC Driver, or Oracle Provider for OLE DB with COM-based applications.
Learn about using Microsoft Transaction Server on the different Windows operating systems.