?
Solved

IsolationLevel Enumeration..???

Posted on 2004-07-31
3
Medium Priority
?
320 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
  • 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] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

Article by: Jorge
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Suggested Courses

592 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