- Joined
- Nov 24, 2004
- Messages
- 147
- Reaction score
- 2
Hi there,
I have a question about concurrency in Java - JDBC.
Currently i have this SQL query, i don't use Hibernate in my codes so im looking for other alternative. I read about optimistic locking but not sure how to implement it
When two user click Update button at the same time.
select * from myTable where id = 1
update myTable set test = '1' where id = 1
When user A execute the following
select * from myTable where id = 1
update myTable set test = '1' where id = 1
The test column updated to 1
When user B execute the following
select * from myTable where id = 1
update myTable set test = '2' where id = 1
The test column updated to 2
In this case, I'm trying to prevent user B from updating test column to 2 as the row has already been updated to 1 by user A
Is there a way I can prevent user B from updating?
I have a question about concurrency in Java - JDBC.
Currently i have this SQL query, i don't use Hibernate in my codes so im looking for other alternative. I read about optimistic locking but not sure how to implement it
When two user click Update button at the same time.
select * from myTable where id = 1
update myTable set test = '1' where id = 1
When user A execute the following
select * from myTable where id = 1
update myTable set test = '1' where id = 1
The test column updated to 1
When user B execute the following
select * from myTable where id = 1
update myTable set test = '2' where id = 1
The test column updated to 2
In this case, I'm trying to prevent user B from updating test column to 2 as the row has already been updated to 1 by user A
Is there a way I can prevent user B from updating?