Say I have a HTML front-end based Web application that allows
the user to select a database record on the first page and update
the record.
However, as there are many columns, the users needs to fill in 3 HTML
screens (URLs) before the final page contains the
submit button to save the record.
Is there any way to specify to the database to lock the record so that
other users could not modify the record while the first user is updating
the record?
I thought about implementing this by using my own separate table to keep
the record key (id) and a time stamp column but want to know how this is
normally done.
Can we do this via JDBC 1.1 or 2.0 without doing our own locking
routines ?
TIA.
Regards,
Chee Keong
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
For JSP FAQ, http://www.esperanto.org.nz/jsp/jspfaq.html