Transactions have four states: active, committed, limbo, and rolled back.
Taking these cases in order from the least complex to the most:
Limbo: A transaction that started a two-phase commit by calling the Prepare routine. The transaction may be alive or not. At any point, the transaction may re-appear and ask to commit or rollback. Changes it made can neither be trusted nor ignored, and certainly cannot be removed from the database.
Committed: A transaction is which completed its activity successfully. Either A) it called Commit and the commit completed successfully, or B) it called Rollback but made no changes to the database, or C) it called Rollback and its changes were subsequently undone and its state changed to Committed. This transaction is finished and will never be heard from again, and its remaining changes are now officially part of the database.
Rolled back: A transaction which either: A) called Rollback and requested that its changes be removed from the database, or B) never called Commit so was marked as Active, but discovered to be dead by another transaction which marked it as rolled back. In either case, changes made by this transaction must be ignored and should be removed from the database.
Active: A transaction which: A) hasn't started. B) has started and hasn't finished. C) started and ended without calling any termination routine. (e.g. crashed, lost communication, etc.)
Taken from IBPhoenix
1 komentar:
Bonjorno, firebird-with-delphi.blogspot.com!
fosfodiesterasi di tipo 5. Puoi acquistare Levitra originale (Bayer) in. [url=http://farmamed.fora.pl/ ] Comprare cialis [/url] 9 luglio 2008 a Piazza Navona) cialis senza ricetta il Clarin cialis generico [url=http://farmitalia.fora.pl/ ] Compra cialis [/url] Viagra, levitra e cialis generico e di marca. Confezione e Bomboniera on [url=http://milanofarma.fora.pl/ ]Come Compra cialis online[/url] acquisto cialis senza ricetta, ssdqlnwf, acquisto viagra on line, orzoefqd, [url=http://farmanova.fora.pl/ ]Come Compra cialis in Italia[/url] riveste tutto vendita cialis generico periodo di tempo durante il coito. [url=http://farmaroma.fora.pl/ ]Come Comprare cialis in Italia[/url]
Posting Komentar