RE: Locking records in DB2

Hi
when you create JDBC connection you can set the
transaction isolation level to achieve this, read the
documentation and select the level you want to use , i
guess you can use serializable.
So if some one is trying to update record other person
may not be able to update it, 
But if you want to block other users from seeing
records untill some one else is viewing it then i
guess you will have to do it programatically use some
application level variables

Ashish

--- "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
wrote:

> >Do you have a better suggestion than the record
> lock then in a web app?
> 
> 
> What are you trying to accomplish?
> 
> -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.)
> 
> 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> RPower@xxxxxxxxxx
> Sent: Tuesday, October 04, 2005 1:52 PM
> To: Java Programming on and around the iSeries /
> AS400
> Subject: 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.)
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400
> (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 



        
                
______________________________________________________ 
Yahoo! for Good 
Donate to the Hurricane Katrina relief effort. 
http://store.yahoo.com/redcross-donate3/