title: Synchronized access to database?
body: <p>I am writing a little shop administration software for my uncles fishing shop. It supports multiple clients which access a single database in a local network. I am currently searching for a way to synchronize the access to the database. One solution would be to write a server program which manages the db access. But I have no experience in network programming, so I would like to find an other solution. I came up with the following:</p>
  
  <p>Every entry in the database has a timestamp that informs about the last time it was edited. Before a client edits an entry it reads the timestamp to check whether the entry has been modified by another client. If that is the case, the client does not write to the database but informs the user. The user has to merge his local changes with the modified db entry. The process of reading the timestamp, checking the timestamp and writing to the database would be implemented as a single jdbc transaction.</p>
  
  <p>What do you think, would that work?</p>