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?
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.
Joined: Oct 16, 2007
Thank you Vesa. I did several searches and didn't get anything in related to your suggestion. Any further information that you can provide?