Chee Keong wrote:
> 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
Depending on your database, you may be able to do 'select for update ...'
cc
===========================================================================
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
