In general I need to lock whole table so only one session can perform update. I'm looking for solution that will work in both C++ and Java.
Will 'SELECT FOR UPDATE' lock whole table? As per 'LOCK' will lock released if connection get closed abnormally? ( example: hard crash on the client side, network interruptions, etc.) Can LOCK be used in JDBC or it's SQL92 standard? Thanks a lot. Mark --- Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Thu, Dec 23, 2004 at 11:56:26AM -0800, Mark wrote: > > > Is it possible to lock row(s) when updating a table, so another > call > > for update( from different session) will be rejected and to be on > > hold until lock get released ? > > The UPDATE statement automatically acquires locks, but if you need > more control then you could use SELECT FOR UPDATE or LOCK. For > more information see the "Concurrency Control" chapter in the > documentation. > > What problem are you trying to solve? Depending on what you're > doing, you might not need to use explicit locking. > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
