Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Sequences and ACID...
Peter Buzanits wrote:
>
> 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
> ---------------------------------------------------
Yes they do. If you do rollback, you lose a sequence number. Sequences
are
not rolled back.
--
Mladen Gogala
Received on Wed May 05 1999 - 21:37:49 CDT