In multiuser system I want to know about locking of a record
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Manoj_Agrawal
Posted On:   Wednesday, April 11, 2001 08:19 AM

In multi user system if same time two user symultenniously retrive a record and then both are going to update that record then first user information is overwrite by another user, How do I prevent this. please suggest.

Report | Quote This | Send private message | Reply | Print

Re: In multiuser system I want to know about locking of a record

Posted By:   Thanabalasingam_Kamalanesan  
Posted On:   Monday, April 16, 2001 10:13 PM

why do you bother about locking.it will be handled by dbms .
you can use binary locks.that mean a integer contains two state(0,1).

if 0 locked by some one.if it is 1 then no lock.then change to 0 and update.after update change to 1.but it has some problems also.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact