> Hi Set,
>
> > Sounds like getting those 15 counter values may happen within the same
> > transaction. No other transaction will be allowed to update that
> > record until the transaction that did the update commits. Neither will
> > those other transactions be allowed to update the record until they
> > can see the most recent version (depending on transaction isolation).
>
> Yes, it sounds like that. But no, I am sure it's not the same
> transaction. Every call for a new counter value starts a new transaction
> that is either ended with a commit or rollback.

just remember that calls to generators (i.e. the resultant generated value)
is outside transaction control - the generation of values has nothing to do
with transactions - they are merely serialised responses to calls in a
queue.
Alan

>
> --Heiko