Does Instance Per Transaction works like Optimistic Locking, and are transactions rolled back when attempt to update data in the database based on a stale copy held by the client ??
Also what are the effects of using the NoLock and JDBCOptimisticLock locking policies with Instance Per Transaction configuration ??
Thanks very much in advance.
The optimistic lock checks for stale data, NoLock
does not. Both use instance per transaction.