equivalent of for update nowait in Oracle

Dev Shed Forums Sponsor:

December 31st, 2003, 05:43 AM

elecoest

Junior Member

Join Date: Dec 2003

Location: France

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

equivalent of for update nowait in Oracle

Hi,

What is the syntax in Firebird to have a lock on select (not on update, delete).

For example :
user 1 : select.. for update nowait

user 2 : select .. for update nowait -> exception on lock select.

I am this comportment in Oracle and I'd like to have the same in Firebird.

Thanks.

January 1st, 2004, 03:50 AM

goreXP

Contributing User

Join Date: Jun 2003

Location: Bucharest

Posts: 72

Time spent in forums: 2 h 18 m 28 sec
Reputation Power: 10

you have it!

see http://www.ibphoenix.com/downloads/...eleaseNotes.pdf

Quote:

(1.5) Explicit locking
Nickolay Samofatov
The addition of the optional WITH LOCK clause provides a limited explicit pessimistic locking capability
for cautious use in conditions where the affected row set is a) extremely small (ideally, a singleton)
and b) precisely controlled by the application code.
NOTE The need for a pessimistic lock in Firebird is very rare indeed and should be well understood
before use of this extension is considered.
Syntax
SELECT ... FROM <sometable>
[WHERE ...]
[FOR UPDATE [OF ...]]
WITH LOCK;

around page 13/14

__________________
Romania it's a beautiful country ... too bad that it's populated with ... peoples!

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > equivalent of for update nowait in Oracle

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump