TransactionModule
Summary
Oracle/DB2 integration with MTS and stress testing.
Details
The aim was to develop a new component that enables to process Two-Phase Transactions for Oracle and DB2 servers. Using this component it is possible to execute a single transaction across more then one Oracle or DB2 databases. We utilized Microsoft Distributed Transaction Coordinator (DTC) like a transaction manager and COM+/MTS components to access Oracle or DB2 databases, in order to perform required two-phase transactions. In addition, a set of developed stress tests could help to check the performance of a specific configuration of the component. During the work on this project we acquired a unique experience facing with some specific integration issues. The developed solution offers broad benefits, such as enhanced scalability, security and application logic reuse.