Patent ID: 6799188
Filing Date: 2004-09-28
Classification: G06F,Y10S

Abstract:
An improved method for providing two-phase commit protocol (2PC) in a transaction processing system in communication with at least two databases, the method comprising:in response to a transaction initiated by a client in a transaction processing system comprising at least a three-tier system including at least one client, a middle-tier application server and at least two databases allocating connections to databases participating in said transaction without use of 2PC; reading in records required in said transaction from said databases; determining at the middle-tier application server whether or not said transaction results in changes to more than one database; if said transaction results in changes to no more than one database, completing said transaction without use of 2PC and without use of XA connecitons to databases participating in the transaction; and if said transaction results in changes to more than one database using XA connections to databases participating in the transaction and using 2PC to complete said transaction at all databases participating in the transaction.