Exposed 0.17.4 released with critical fix related to transaction isolation. Please update.

# exposed

[tapac]

Exposed 0.17.4 released with critical fix related to transaction isolation. Please update.

[jfburdet]

Tried to bump version to 0.17.5 ... now I'm getting a bunch of "SQLite supports only TRANSACTION_SERIALIZABLE and TRANSACTION_READ_UNCOMMITTED." in my tests.

So I had to update my sqlite specific code to this :

fun sqliteConnect(url: String): Database {
    val dataSource = SQLiteDataSource()
    dataSource.url = url
    dataSource.config = SQLiteConfig()
    dataSource.setEnforceForeignKeys(true)
    return Database.connect(dataSource).apply {
        this.transactionManager.defaultIsolationLevel = java.sql.Connection.TRANSACTION_READ_UNCOMMITTED
    }
}

[tapac]

I'll check it, thnx

[tapac]

@jfburdet. it's an well known issue with SQLite3. https://github.com/JetBrains/Exposed/wiki/FAQ#q-sqlite3-fails-with-the-error-transaction-attempt-0-failed-sqlite-supports-only-transaction_serializable-and-transaction_read_uncommitted

I'll look how it can be fixed in a future releases.