I was asked a question in the interview..the question was like say 2 Users(say user A and user B) access a JSP page.This JSP page will display "count" and say currently the "count" value is 10.So both Users see "count" value as 10.Now this JSP has a "submit" button,and when the user clicks on that submit button,then their count should be increased by 1.Now the User A clicks on submit button,and the count increases by 1,so the count value becomes "11".But User B still sees 10,and now say User B hits submit button as well.Now instead of count increasing to "12",we should display an error message to the User B saying someone has already updated the "count" variable. How can this be achieved...
I thought either through timestamp or may be transaction.
Someone says "Impossible is nothing". The man next him says "Let me see you licking your elbow tip!"
Yes. Using a timestamp will do. The timestamp rill be updated on save. Before saving though, check the timestamp to see if it has changed. If it's the same as when data was read, proceed with update. Else, re-read the count, then do the update.
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Joined: Dec 20, 2007
Is there anything i could do with transaction here to solve the problem
Hmm....i have no idea what is the solution of this question....so am really not sure in which forum to put this question in...And please dont expect me to put the same question in all forums...The main thing i have posted this question was since i had no CLUE of the answer....so i need help there