https://kotlinlang.org logo
#exposed
Title
# exposed
f

Filip Lastic

12/15/2021, 9:50 AM
Why the default transaction level for MSSQL is different that other databases?
Copy code
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
            }
Copy code
const val DEFAULT_ISOLATION_LEVEL = Connection.TRANSACTION_REPEATABLE_READ