File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

difference between transaction Isolation Level 1 & 2

Manish Jaju

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

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!
I agree. Here's the link:
subject: difference between transaction Isolation Level 1 & 2
Similar Threads
Difference betn transaction isolation level 1 & 2
Problem In EJB Transaction Management
Transaction Isolation
Transaction isolation level