Problem solve Get help with specific problems with your technologies, process and projects.

What exactly is a multi-phase commit?

What exactly is a multi-phase commit? We have a requirement that we use a RDBMS that supports multi-phase commits. Can ORACLE 8i do that?
A multi-phase commit is not simply a database concept. In any case where more than one server connection -- literally a socket connection -- and more than one commit step bounds the transaction scope a multi-phase commit occurs. The challenge is implement rollback mechanics when any part of the chain fails. Transaction Process Monitors (TPM's) are used to monitor transaction steps and indicate status at the buisness process, i.e., the multi-phase level. However, backing out a failed transaction generally means writing logic for compensating transactions, which are used to back out individual transaction steps in a multi-phase rollback. I do not believe that Oracle has any multi-phase capability, because this is not an aspect of either the SQL language or its low level OCI library. However, I would check with Oracle tech support for a definitive answer.
This was last published in March 2002

Dig Deeper on Application integration architecture



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.