Robert DiFalco wrote:

>a. thread 1 - create transaction
>b. thread 2 - create transaction
>c. thread 1 - read object under transaction
>d. thread 2 - remove object under transaction
>e. thread 2 - commit transaction
>f. thread 1 - modify object
>g. thread 1 - write back object under transaction
>h. thread 1 - commit transaction
>
>Will thread 2 remove the object only to have it recreated by thread 1?
>

No. The result will depend on the transaction mode, but in no case
(that I can think of) will the record reappear. In "repeatable read"
transaction 1 will get an error at step g.
In "read committed" when Transaction one goes back to the object at step
f., the object will be gone.

Regards,


Ann