Oracle Sequences and ACID...

From: Peter Buzanits <peter_at_icb.co.at>
Date: Tue, 04 May 1999 15:12:10 +0200
Message-ID: <372EF22A.649C353E@icb.co.at>

Do transactions using sequences meet the ACID-requirements for transactions?

As I understand, a rollback does NOT undo an increment of a sequence during the transaction.

BUT: Doesn't this behaviour violate the ACID-requirements of a transaction? A means Atomicity. A transaction is performed eighter completely or NO changes are made at all. If you rollback a transaction, sequence numbers remain increased (=updated). This can produce gaps in the sequence, that could be a bad surprise for a developer who relies on the Atomicity...

I means Isolation. No change made during a transaction can bee seen outside. But a sequence increment done by transaction X must be seen by transaction Y for avoiding double-use of a number...

So do transactions using sequences meet the ACID-requirements?

Peter
--

---

DI Peter Buzanits

mailto:peter@icb.co.at       http://peter.icb.co.at

AOL-IM: Buzanits      Keys available on PGP-Servers


---------------------------------------------------

Received on Tue May 04 1999 - 08:12:10 CDT