Does transaction support isolation levels?

# exposed

[rrader]

Does transaction support isolation levels?

[tKw]

Globally across all transactions or on a per-transaction basis?

[tKw]

You can set isolation level in the data source. As for on a per-transaction basis, I don't think so (could be wrong).

[rrader]

per transaction

[tKw]

Hi @rrader, it does appear that you can change the isolation level per transaction. https://github.com/JetBrains/Exposed/blob/d364436ffdd57da0f39747b8bb4f8c961f048e95/src/main/kotlin/org/jetbrains/exposed/sql/transactions/ThreadLocalTransactionManager.kt#L60

[tKw]

transactionIsolation is the parameter you want to set.

[tapac]

@rrader, per transaction level (https://github.com/JetBrains/Exposed/wiki/Transactions#advanced-parameters-and-usage), also as @tKw mentioned it's possible to change isolation level globally.