• Post Reply Bookmark Topic Watch Topic
  • New Topic

Transaction Levels

 
Joe Harry
Ranch Hand
Posts: 10128
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Level

0 None Anything is permitted; the database or transactions.
1 Read Uncommitted Dirty, nonrepeatable, and phantom reads
2 Read Committed Nonrepeatable reads and phantom reads
4 Repeatable Read Phantom reads are permitted.
8 Serializable The rule must be obeyed absolutely.

What does dirty, phantom reads mean? Please help guys!
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!