• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

read access locks

 
Maan Suraj
Ranch Hand
Posts: 299
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Bosun Bello
Ranch Hand
Posts: 1510
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Maan Suraj
Ranch Hand
Posts: 299
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks....
Is there anything i could do with transaction here to solve the problem
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64618
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is no transaction support in servlets. Are you thinking about EJBs?
 
Maan Suraj
Ranch Hand
Posts: 299
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic