This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: difference between transaction Isolation Level 1 & 2
It's not a secret anymore!