• Post Reply Bookmark Topic Watch Topic
  • New Topic

Transaction Isolation level and Concurrent access problems ?

 
lalit upadheyay
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I googled for transaction isolation levels. I came to know of the fact that Nonrepeatable read and Phantom read problems can occur when transaction isolation level is
READ_COMMITTED. I thought and searched around this but couldn't find satisfactory explanation. Can someone please explain by giving some example ?
 
Dejan Mratinkovic
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
lalit upadheyay wrote:searched around this but couldn't find satisfactory explanation.


http://en.wikipedia.org/wiki/Isolation_%28database_systems%29

Top rated on Google for both "Phantom read" and "Nonrepeatable read". Explained in detail with simple examples. Is this what you look for or you need further explanations on something?
 
lalit upadheyay
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Dejan Mratinkovic. Yes, simplicity is the key. I was searching using more technical terms.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!