RE: Locking records in DB2

Do you have a better suggestion than the record lock then in a web app? 
That's not being sarcastic either, I'm open to suggestions :)

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




"Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
2005/10/04 03:15 PM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
"Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>
cc

Subject
RE: Locking records in DB2






>Can anyone help me with understanding what I need to do to use Java and

>SQL to put a record lock on a database file on the iSeries? 

You WANT to put a record lock on a row? And how long do you intend to
hold this lock? The suggestion of "...FOR UPDATE" might work w/in the
servlet or JSP, but once you return to the user there's no guarantee
that the user will be serviced by the same iSeries job next time.

Holding a record lock on a web app is not something you usually want to
do. I guess if you really need to do it, the first thing that comes to
mind is to hold the lock not in the java program, but in a surrogate job
you launch specifically for this task. 

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)