Filip Lastic
12/15/2021, 9:50 AMfun 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
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/