CODEWITHSUNDEEP
springdatabasetransactionsspring-transactions
Syed
Syed

Reputation: 2597

Isolation level use cases in real world

I've gone through multiple tutorials and articles about different isolation levels. I understood the concept, but I don't understand the real world scenario where to use which level. Are there any simple use cases where they can be demonstrated? Any ideas would be greatly appreciated.

Thanks in advance

Upvotes: 3

Views: 591

Answers (1)

asgarov1
asgarov1

Reputation: 4098

Isolation levels are not a Spring concept - spring only supports it, this is a database concept. You need to work with databases to understand why dirty reads are a problem and why therefore Read Committed Isolation level is necessary etc. I can recommend you articles but without practical experience with databases you will have hard time getting it.

If you do want to understand the topic, install an Oracle database and play with setting different isolation levels and seeing what effects does that make if you for example open 2 sessions with 2 SQLPlus Windows and try to update/read same rows.

Upvotes: 2

Related Questions