Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Concurrency Issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Concurrency Issue" Watch "Concurrency Issue" New topic

Concurrency Issue

Vaibhav G Garg
Ranch Hand

Joined: Sep 23, 2011
Posts: 141
I have to work upon the scenario. Suppose there are 2 users. 1st user opens up a page and updates some data. The 2nd user also opens up the same page and updates the same data. The first user submits the data first and then the 2nd user submits the data. So, it corrupts the data in the database. So, how to handle such scenarios.
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3733

The scenario you've described is usually called "lost update". Optimistic locking can often be used to avoid it.
I agree. Here's the link:
subject: Concurrency Issue
It's not a secret anymore!