CODEWITHSUNDEEP
mysqlspringspring-transactionsisolation-leveltransaction-isolation
samshers
samshers

Reputation: 3660

Precedence of Spring Transaction Isolation level vs Database isolation level

Say, the isolation level for a database is set at READ_COMMITED.
Then through spring transaction management I am setting the transaction Isolation level to
1) READ_UNCOMMITED - then what will be the effective isolation level for this transaction.
2) REPEATABLE_READ - then what will be the effective isolation level for this transaction.

Upvotes: 1

Views: 748

Answers (1)

StanislavL
StanislavL

Reputation: 57381

There is default isolation level set in DB (in your case it is READ_COMMITED) and one transaction isolation level. If it's not explicitly specified default level is used.

Spring just turns on declared isolation level and of course "overrides" default level of DB.

In fact you can do the same without spring by calling SQL

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

Spring just does the same for you

Upvotes: 2

Related Questions