Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

IsolationLevel Enumeration..???

Posted on 2004-07-31
3
Medium Priority
?
313 Views
Last Modified: 2008-02-26
I don't understand about all of property of IsolationLevel Enumeration.....I see it on MSDN but...I can't understand....so can you explain for me about these property and Examples about these property.....
0
Comment
Question by:sonbinary
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Expert Comment

by:gregoryyoung
ID: 11688653
what exactly do you not understand about it ? MSDN has a fairly clear explanation on the differences here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataIsolationLevelClassTopic.asp. Perhaps a more specific question on what needs clarification ?
0
 

Author Comment

by:sonbinary
ID: 11691782
Yes....I want more clarification for those explain.....I want a compare with those property so I can understand its....Can you give me some example case adn situation for that property..???
0
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 2000 total points
ID: 11695293
These are mostly the ANSI defined isolation levels

Chaos
 The pending changes from more highly isolated transactions cannot be overwritten.
this is fairly obvious

ReadCommitted
 Shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in non-repeatable reads or phantom data.
You only see committed data

ReadUncommitted
 A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored.
you read the data whether or NOT it has been committed

RepeatableRead
 Locks are placed on all data that is used in a query, preventing other users from updating the data. Prevents non-repeatable reads but phantom rows are still possible.
places a Write lock on the row being modified so that no other database user can update the row in the database (aka pessimistic locking during your transaction)

Serializable
 A range lock is placed on the DataSet, preventing other users from updating or inserting rows into the dataset until the transaction is complete.
this would be used during a process such as serialization so that when you are serializing out the data noone else can change the data ... this allows you to make whats called a snapshot of the data. This is needed due to the fact that after I write out table1 if you insert into table2 which has a p->c relationship with table1 and then insert the parent into table1 when I get to table2 my output will be erroneous as the relationship constraint would not have been met


Unspecified
 A different isolation level than the one specified is being used, but the level cannot be determined.
I do not think that this needs much more explanation .....

further explanation is given here
http://media.datadirect.com/download/docs/odbc/odbcref/locking.html
http://www.winnetmag.com/SQLServer/Article/ArticleID/5336/5336.html
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question