The transaction is nowait mode...
I expected to get a deadlock. But nothing happen, the other select for update with lock works where I expected the deadlok (it's looks like there is no Lock on the record's)... But if I try to do a update sql statement the deadlock occurrs... So why don't occurrs when I make the select for update with lock???

I don't understand. The ideia of select for update with lock is the pessimistic lock. I thing that when I do one select for update with lock, I will get one deadlok if I try to do another one on the other transaction!!!


---------------------------------------------------------
Jean Derrie Rigo
rigo@...
---------------------------------------------------------

----- Original Message -----
From: Julio Cesar
To: firebird-support@yahoogroups.com
Sent: Friday, July 25, 2003 10:46 AM
Subject: Re: [firebird-support] Select for update with lock


The clause FOR UPDATE WITH LOCK is designed to cause a persimistic lock of
record, but if your transaction have a parameter wait and the time of
transaction is very short your users don't see difference....



Julio Cesar
julio_gyn@...
ICQ: 149863922
Grafcenter Informática LTDA.
Sistemas de Gestão Comercial


----- Original Message -----
From: "Jean Derrie Rigo" <rigo@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, July 25, 2003 10:32 AM
Subject: [firebird-support] Select for update with lock


> I'm using Firebird 1.5 RC4. Dialect 3.
> Windows 2000 Service Pack 4.
>
> I do on ISQL:
> select * from banco_movimento for update with lock;
>
> then I try the same on IBConsole:
> select * from banco_movimento for update with lock;
>
> and there is no lock on the records... It's just cause deadlock if I try
to
> update banco_movimento...
>
> How can I lock the records on the select statement... I was thinking that
is the
> select for update with lock that's do it...
>
> ps..: sorry about the english...
> ---------------------------------------------------------
> Jean Derrie Rigo
> rigo@...
> ---------------------------------------------------------
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]