Why the default transaction level for MSSQL is dif...

# exposed

[Filip Lastic]

Why the default transaction level for MSSQL is different that other databases?

fun getDefaultIsolationLevel(db: Database): Int =
            when (db.vendor) {
                SQLiteDialect.dialectName -> Connection.TRANSACTION_SERIALIZABLE
                OracleDialect.dialectName -> Connection.TRANSACTION_READ_COMMITTED
                PostgreSQLDialect.dialectName -> Connection.TRANSACTION_READ_COMMITTED
                PostgreSQLNGDialect.dialectName -> Connection.TRANSACTION_READ_COMMITTED
                else -> DEFAULT_ISOLATION_LEVEL
            }

const val DEFAULT_ISOLATION_LEVEL = Connection.TRANSACTION_REPEATABLE_READ

[Filip Lastic]

The default isolation level for all SQL Server databases is Read Committed

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-serve[…]-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/