• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database locking

 
Sarath Koiloth Ramath
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends,

I have 3 clients which is updating my database,these three cleints is changing the data in the database at the same time.i want to to solve make the updation one by one with out using the thread mechanism(like synchronization ).

can anyone help me to solve this issue
 
Scott Selikoff
author
Saloon Keeper
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not manage the information using an in-memory cache, which periodically dumps to the database? If you really want all 3 to have simultaneous access, database ACID principles are probably going to cause some users to get stale data exceptions. Alternatively, you could catch stale data exceptions and transparently refresh the user's data.
 
Jelle Klap
Bartender
Posts: 1952
7
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It depends on the system in question, but generally speaking there are two way to go: an optimistic locking strategy or a pessimistic locking strategy.
You'll need to determine if collisions are expected to occur frequently in your multi-user system and what's an acceptable way of dealing with them when they do. The first strategy seems like the most obvious candidate for a foolproof solution, but a pessimistic approach risks compromising the performance of the system as a whole, which is something to be wary of.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic