Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Locking Considerations

In a multi-user environment, record locking can become an issue that an application needs to handle. When one application is updating a record, that record is “locked” so that no other application can change it. This is critical in maintaining the integrity of the data.

Apache Derby supports four isolation levels: uncommitted read (UR), cursor stability (CS), read stability (RS), and repeatable read (RR). Insert, update, and delete operations always behave the same, no matter what the isolation level is. Only the behavior of SELECT statements varies depending on the isolation level.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint