|
I have a webapp which allows a user to retrieve a record from our AS400 using SQL 'and prepared statements'. I also can write / update records in the database. How do I handle 'record-locking'? As an RPG-programmer, I was lucky that this is done by the AS400 itself. Sure, I can add a statusfield 'locked Y/N' - which can be changed to 'Y' when record is read - which can be changed to 'N' when record is updated/deleted But... when user reads a record (locked = 'y') 1) he can close the browser without doing the update... 2) he can keep the session open without doing anything... 3) the connection can be lost... 4) servlet-programming error can occur... please advice...
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
