Progress
DataServer
for ORACLE Guide
Two-phase Commit
If you access more than one database in a transaction (for example, a Progress database and an ORACLE database), Progress uses a two-phase commit protocol to minimize the chances of database corruption. The DataServer supports two-phase commit in a configuration that uses Progress networking and includes one ORACLE database and any number of Progress databases. If a configuration uses SQL*Net or Net 8, the DataServer supports two-phase commit to multiple ORACLE databases.
The DataServer treats a distributed ORACLE database as a single database. Any ORACLE tables accessed through database links do not count as additional database connections. The DataServer ensures a two-phase commit to the first ORACLE instance; the ORACLE RDBMS and SQL*Net or Net 8 are responsible for distributing the COMMIT to all linked instances.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |