Hi. I've been all over the net, but for some reason I can not find the answer I am looking for.
I'm developing a small, open-source POS application and I need to ensure that no two users can update the same record at the same time. Here's the question : How do I ensure that two users can not EDIT a record at the same time ? Is there some SQL command I need to use to lock a record or a way to check if a record IS currently locked as read-only ? Any direction will help, I've been through the JDBC tutorials, but they all deal with single connections. My problem is in dealing with multiple connections where information can change quickly, like for instance stock levels in the inventory as sales are rung up. I've got the H2 database up as a server, everything is working brilliantly and I have three machines all accessing the same database. The way it runs as a Windows service is just brilliant! If I missed a post (I did search :) on the group about this problem, feel free to a) Direct me to the relevant post b) Flame me, of course Thank you Ewald --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
