KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have read about 4 levels of isolation: Isolation Level Dirty Read Nonrepeatable Read Phantom Read READ UNCOMMITTED Permitted Permitted Permitted READ COMMITTED -- Permitted Permitted REPEATABLE READ -- -- Permitted SERIALIZABLE -- -- -- I want to understand the lock each transaction isolation takes on the table READ UNCOMMITTED - no lock on table READ COMMITTED - lock on committed data REPEATABLE READ - lock on block of sql(which is selected by using select query) SERIALIZABLE - lock on full table(on which Select query is fired) below are the three phenomena which can occur in transaction isolation Dirty Read - no lock Nonrepeatable Read - no dirty read as lock on committed data Phantom Read - lock on block of sql(which is selected by using select query) I want to understand where we define these isolation levels : only at jdbc/hibernate level or in DB also PS: I have gone through the links in Isolation levels in oracle , but they looks clumsy and talk on database specific
Tags (comma-separated)
Save Edits
Cancel