Transaction management in JPA/Spring

Propagation is used to defines how transactions relate to each other. Common options

  • Required: Code will always run in a transaction. Create a new transaction or reuse one if available.
  • Requires_new: Code will always run in a new transaction. Suspend current transaction if one exists.

Isolation Defines the data contract between transactions.

  1. Read Uncommitted: Allows dirty reads
  2. Read Committed: Does not allow dirty reads
  3. Repeatable Read: If a row is read twice in the same transaction, result will always be the same
  4. Serializable: Performs all transactions in a sequence

An isolation level is about how much a transaction may be impacted by the activities of other concurrent transactions.It a supports consistency leaving the data across many tables in a consistent state. It involves locking rows and/or tables in a database.

The problem with multiple transactions
  • Scenario 1.If the T1 transaction reads data from table A1 that was written by another concurrent transaction T2.If on the way T2 is a rollback, the data obtained by T1 is invalid one.E.g a=2 is original data.If T1 read a=1 that was written by T2.If T2 rollback then a=1 will be a rollback to a=2 in DB.But, Now, T1 has a=1 but in DB table it is changed to a=2.
  • Scenario2.If a T1 transaction reads data from table A1.If another concurrent transaction(T2) update data on table A1.Then the data that T1 has read is different from table A1.Because T2 has updated the data in table A1.E.g if T1 read a=1 and T2 updated a=2.Then a!=b.
  • Scenario 3.If T1 transaction reads data from table A1 with a certain number of rows. If another concurrent transaction(T2) inserts more rows on table A1.The number of rows read by T1 is different from rows on table A1

Scenario 1 is called Dirty reads.
Scenario 2 is called Non-repeatable reads.
Scenario 3 is called Phantom reads.

So, isolation level is the extent to which Scenario 1, Scenario 2, Scenario 3 can be prevented. You can obtain complete isolation level by implementing locking.That is preventing concurrent reads and writes to the same data from occurring.But it affects performance.The level of isolation depends upon application to application how much isolation is required.

  1. ISOLATION_READ_UNCOMMITTED: Allows to read changes that haven’t yet been committed.It suffers from Scenario 1, Scenario 2, Scenario 3
  2. ISOLATION_READ_COMMITTED: Allows reads from concurrent transactions that have been committed. It may suffer from Scenario 2 and Scenario 3. Because other transactions may be updating the data.
  3. ISOLATION_REPEATABLE_READ: Multiple reads of the same field will yield the same results until it is changed by itself.It may suffer from Scenario 3.Because other transactions may be inserting the data
  4. ISOLATION_SERIALIZABLE: Scenario 1,Scenario 2,Scenario 3 never happens.It is complete isolation.It involves full locking.It affects performance because of locking.


  1. Interesting information and attractive.This blog is really rocking... Yes, the post is very interesting and I really like it.I never seen articles like this. I meant it's so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job.
    Kindly visit us @
    Sathya Online Shopping
    Online AC Price | Air Conditioner Online | AC Offers Online | AC Online Shopping
    Inverter AC | Best Inverter AC | Inverter Split AC
    Buy Split AC Online | Best Split AC | Split AC Online
    LED TV Sale | Buy LED TV Online | Smart LED TV | LED TV Price
    Laptop Price | Laptops for Sale | Buy Laptop | Buy Laptop Online
    Full HD TV Price | LED HD TV Price
    Buy Ultra HD TV | Buy Ultra HD TV Online
    Buy Mobile Online | Buy Smartphone Online in India

  2. Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up. 
    Authorized apple service center in Chennai | apple service center in chennai | Authorized apple service center in Chennai | apple service center in chennai | ipad service center in chennai | iphone water damage service in chennai

  3. The article is very interesting and very understood to be read, may be useful for the people. I wanted to thank you for this great read!! I definitely enjoyed every little bit of it. I have to bookmarked to check out new stuff on your post. Thanks for sharing the information keep updating, looking forward for more posts..
    Kindly visit us @
    Madurai Travels
    Best Travels in Madurai
    Cabs in Madurai
    Tours and Travels in Madurai

  4. Excellent Blog. I really want to admire the quality of this post. I like the way of your presentation of ideas, views and valuable content. No doubt you are doing great work. I’ll be waiting for your next post. Thanks .Keep it up! Kindly visit us @ Christmas Gift Boxes | Wallet Box | Perfume Box Manufacturer
    Candle Packaging Boxes
    Luxury Leather Box
    Luxury Clothes Box
    Luxury Cosmetics Box
    Shoe Box Manufacturer
    Luxury Watch Box

  5. Wow, what an awesome spot to spend hours and hours! It's beautiful and I'm also surprised that you had it all to yourselves! we are the one of the best HIV treatment hospital in India..Click here for more details Best HIV Treatment in India | Top HIV Hospital in India | HIV AIDS Treatment in Mumbai | HIV Specialist in Bangalore | HIV Positive Treatment in India | Medicine for AIDS in India

  6. You have shared a nice article. Your service is very interesting and useful.I liked it.
    Tablet Repair Nj

  7. Very good and informative article. Thanks for sharing such nice article, keep on updating such good articles.
    Basic Computer Course in Chromepet | Basic Computer Course in Chennai

  8. Great work man you have post a great post it will help people very much keep it do more for people like that iPhone 8 Plus screen replacement.

  9. Great informative blog. is reliable platform for the phone repairs and many others services. Visit here mobile phone repairs sutherland shire

  10. I would like to bookmark the page so i can come here again to read you, as you have done a wonderful job. If you are looking for a professional tablet screen repairs shop in the UK then is the best option for you. For more iPhone XR Screen Repair Shop UK

  11. Great post, Which you have shared here. This information very important for every person those really interesting in. If you know more about us go through Drag Queen Phone Cases

  12. Awesome post! This is helpful post. This article is clear and with lots of useful information. we provide austin cell repair at affordable prices.for more info visit our website.

  13. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Opt to buy Moto G8 Power Lite Cases & Covers at

  14. An Eternity Experience,Escorts Agency in Gujarat Being by themselves in a particular place can be terrifying sometimes.Escorts contact number in Gujarat Nevertheless, you want to flee the ordinary and become Top Call Girls in Agra with someone not the same as the rest.Escorts Rate in Indore You could have the right company, you could have that escapade with someone,Escorts Rate in Haridwar and you could have an eternity experience and become happy, Escorts Rate in Goa can make your dreams become a reality.

  15. Extremely useful information which you have shared here about business voip providers.This is a great way to enhance knowledge for us, and also beneficial for us. Thank you for sharing an article like this.