aspose file tools*
The moose likes JDBC and the fly likes records modified by more than one users Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "records modified by more than one users" Watch "records modified by more than one users" New topic
Author

records modified by more than one users

Ricky Murphy
Ranch Hand

Joined: Oct 16, 2007
Posts: 31
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

Joined: Jan 16, 2008
Posts: 25
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

Joined: Oct 16, 2007
Posts: 31
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

Joined: Jan 16, 2008
Posts: 25
Hi,

I skimmed this article and I think it would be helpful for you too:
Optimistic Locking pattern for EJBs
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: records modified by more than one users