Subject | Generator |
---|---|
Author | Michael Vilhelmsen |
Post date | 2005-04-12T10:44:34Z |
Hi
A Generator is (as I recall) not part of a transaction.
That means, that if I have a trigger BEFORE INSERT that calls a
generator to return a number to a field in my table, and I latter in
the program do a rollback, then the generator is still updated by 1,
right ?
If so - Can I get a Deadlock on this generator, if two machines try to
insert a record in the same table at the same time (A deadlock on a no
wait transaction) ?
Regards
Michael
A Generator is (as I recall) not part of a transaction.
That means, that if I have a trigger BEFORE INSERT that calls a
generator to return a number to a field in my table, and I latter in
the program do a rollback, then the generator is still updated by 1,
right ?
If so - Can I get a Deadlock on this generator, if two machines try to
insert a record in the same table at the same time (A deadlock on a no
wait transaction) ?
Regards
Michael