0

I recently learned that when we do an explicit flush the data is moved to DB but its isolated and only visible to current transaction and hidden from other threads and transactions.

So my question is if I have a multi-threaded application

  1. First thread in Transaction1 updates an entity and flushes but haven't finished the transaction
  2. Second thread in Transaction2 updates the same entity and flushes, this transaction is cannot see the data flushed by the Transaction1 so will this cause an Optimistic Lock Exception?
Nick Div
  • 5,338
  • 12
  • 65
  • 127

1 Answers1

0

This depends on the transaction isolation level. For example, in read-comitted level (the most common one), the second thread will be blocked until the first transaction completes, because they update the same row.

Dragan Bozanovic
  • 23,102
  • 5
  • 43
  • 110