paul@bcsfse.UUCP (Paul Hardiman) (11/02/88)
I need some expertise on a locking issue. My project is investigating moving from a database connection environment to one that is transaction oriented. The issue has to do with locks on rows. It is a relatively simple matter to hold a lock for the duration of a connection session, but the picture changes in a transaction environment. So, how do transaction systems preserve locks on one transaction and release it on a later transaction from the same user. We have considered the possibility of using conceptual locks by tagging a field on a row with something unique like the user's id. However, at first glimpse, this method seems to detract from the eloquence of the system. Thank you for any assistance. -- Paul Hardiman ...!uw-beaver!ssc-vax!voodoo!bcsfse!paul