> I never mentioned the app was writing to the same record -- in fact, I
> specifically state that only one thread writes to the same record
> everytime -- i.e.
>
> thread 1 -- enter CS, insert record A, commit, leave CS, enter CS,
> delete record A, commit, leave CS, loop
> thread 2 -- enter CS, insert record B, commit, leave CS, enter CS,
> delete record B, commit, leave CS, loop
> ... --> same goes for thread 3 and 4, but updating record C and D
> respectively
>
> I'm not seeing a conflict there, even if firebird doesn't support
> optimistic locking. Every update transaction is performed in a
> critical section -- i.e. only one thread performs update transaction
> at one time.
>
> Should I expect a conflict in such a case?
>

do you have a separate connection per thread?
Alan