• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

records modified by more than one users

 
Ricky Murphy
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello:

I have a method to modify a record in an Oracle database using JDBC. Chances are that one record can be opened and updated by more than one person, certainly whoever modified the last will get his/her modification into the DB. how would I pop a message to let others know that the record has changed and please reload or something like that? I am thinking that this might not be even possible given the user are at client side when they are modifying data. optimistic locking does not seem to be able to do anything in this case either. Please advise if what I wanted is possible?

Thank you

-Ricky
 
Vesa Tanhua-Tyrkk�
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

To get information about modified record your client should be polling(with version information of client objects) from server if someone has modified records and I think that optimistic locking can do this.
 
Ricky Murphy
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Vesa. I did several searches and didn't get anything in related to your suggestion. Any further information that you can provide?

Thank you.

-Ricky
 
Vesa Tanhua-Tyrkk�
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I skimmed this article and I think it would be helpful for you too:
Optimistic Locking pattern for EJBs
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic