Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

SQLServerDialect doesRepeatableReadCauseReadersToBlockWriters impelmentation

Description

The SQLServerDialect always returns false for doesRepeatableReadCauseReadersToBlockWriters which is not correct.

By default, SQL Server uses 2PL for all four classic isolation levels. Only for READ_COMMITTED_SNAPSHOT and SNAPSHOT, we should return false, for the 2PL isolation levels we should return true.

Activity

Show:

Vlad MihalceaApril 13, 2017 at 10:20 AM

Fixed by the SQLServerSnapshotIsolationConnectionProvider which allows us to use the Snapshot Isolation MVCC Concurrency Control instead of 2PL during testing.

Vlad MihalceaJune 15, 2016 at 10:06 AM

For the moment, this is only used for testing and passing the current Connection to get the actual isolation level is not that easy.

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created June 14, 2016 at 2:16 PM
Updated April 14, 2017 at 10:13 AM
Resolved April 13, 2017 at 10:20 AM