Concurrency control for database updates

A good blog for reading about database issues with concurrent uupdates and how to resolve it apart from optimistic locking

• A beginner’s guide to database locking and the lost update phenomena
• How to prevent lost updates in long conversations
• How to prevent OptimisticLockException with Hibernate versionless optimistic locking