Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

difference between transaction Isolation Level 1 & 2

 
Manish Jaju
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is difference between transaction Isolation Level 1 & 2 which is commited Read and Repeatable Read.... I am a bit confuse about that.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We had much confusion on our team because EJB, DB2 and Oracle all use different words for the same thing and have different levels of support. Here's aUniversity Lecture that I found helpful.

Some of my notes:

Repeatable Read (RR) locks all the rows an application references within a unit of work.

Read Stability (RS) locks only those rows that an application retrieves within a unit of work

Cursor Stability (CS) locks any row accessed by a transaction of an application while the cursor is positioned on the row.

Uncommitted read does not lock other applications out of the row it is reading, unless the other application attempts to drop or alter the table


IBM Documentation

Best of luck in this confusing area!
 
Jessica Sant
Sheriff
Posts: 4313
Android IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm going to move this to the JDBC forum seeing as though this is about various Database isolation levels.

So please post your replies there, thanks!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic