aspose file tools*
The moose likes JDBC and the fly likes difference between transaction Isolation Level 1 & 2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "difference between transaction Isolation Level 1 & 2 " Watch "difference between transaction Isolation Level 1 & 2 " New topic
Author

difference between transaction Isolation Level 1 & 2

Manish Jaju
Greenhorn

Joined: Jul 21, 2004
Posts: 24
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

Joined: Jan 29, 2003
Posts: 8791
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!


A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Jessica Sant
Sheriff

Joined: Oct 17, 2001
Posts: 4313

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!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: difference between transaction Isolation Level 1 & 2