Or you could add a numeric field to the database and when the user grabs the
info for updating set it to 1. If anyone else tries to grab the record and
the numeric field has a 1, deny access to that record. After the user
updates the info set the field back to 0.
cboyd
-----Original Message-----
From: Ellis Miller [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 09, 2000 10:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Database Record Locking
"select xxx...for update..." will allow for level of row locking
-----Original Message-----
From: John Dixon [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 09, 2000 7:46 AM
To: [EMAIL PROTECTED]
Subject: Database Record Locking
Hello,
Just trying to figure this out:
The App:
I have a JSP page that collects data from a database and displays it in
textfields. The user can change the data. click OK and the database is
updated.
The question: How do I lock the record in the database so that another
user
cannot change the data whilst this user is in the midst of changing the
data. Using MSSQLServer.
Many thanks!
JD
========================================================================
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
