A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
video training course this week in the
JDBC and Relational Databases
difference between transaction Isolation Level 1 & 2
Joined: Jul 21, 2004
Oct 29, 2004 07:13:00
What is difference between transaction Isolation Level 1 & 2 which is commited Read and Repeatable Read.... I am a bit confuse about that.
Joined: Jan 29, 2003
Oct 29, 2004 07:45:00
We had much confusion on our team because
, DB2 and Oracle all use different words for the same thing and have different levels of support. Here's a
that I found helpful.
Some of my notes:
Repeatable Read (RR) locks all the rows an application references within a
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
JDBC DB2 SERIALIZABLE == Repeatable read REPEATABLE READ == Read stability READ COMMITTED == Cursor stability READ UNCOMMITTED == Uncommitted read
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
Joined: Oct 17, 2001
Oct 29, 2004 12:56:00
I'm going to move this to the
forum seeing as though this is about various Database isolation levels.
So please post your replies there, thanks!
It is sorta covered in the
JavaRanch Style Guide
subject: difference between transaction Isolation Level 1 & 2
Difference betn transaction isolation level 1 & 2
REPEATABLE READ Vs READ COMMITTED
Problem In EJB Transaction Management
Transaction isolation level
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015