Skip to content

Instantly share code, notes, and snippets.

@prashant4224
Created May 28, 2020 12:53
Show Gist options
  • Save prashant4224/c7f87d5ef58bfa4329a7d66c82132e66 to your computer and use it in GitHub Desktop.
Save prashant4224/c7f87d5ef58bfa4329a7d66c82132e66 to your computer and use it in GitHub Desktop.
Transaction Isolation levels:
Voilations:
Dirty Reads - A updates,B reads, A rollbacks
Non-Repeatable Reads - A reads, B Updates, A reads found 2 records for same.
Phantom Reads - A reads with where critaria, B insert new record which falls in that where critaria, A reads records with same.
TRANSACTION_READ_UNCOMMITTED
TRANSACTION_READ_COMMITTED
TRANSACTION_REPEATABLE_READ
TRANSACTION_SERIALIZABLE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment