| Subject | Re: table lock |
|---|---|
| Author | Roman Rokytskyy <rrokytskyy@acm.org> |
| Post date | 2003-02-06T13:05:21Z |
Nickolay,
either table locking or dummy update are the only solution to lock
group of records.
Best regards,
Roman Rokytskyy
> But you should be aware that this method of locking records (dummyThanks for pointing this out. However, before FB 1.5 is released,
> updates) is very likely to generate "Update conflict" exception
> during concurrent locking/updating.
>
> Explicit locks in FB1.5 never produce update conflicts
> in isc_tpb_read_committed+isc_tpb_wait modes.
>
> Implicit and explicit record locks are not equivalent in Firebird
either table locking or dummy update are the only solution to lock
group of records.
Best regards,
Roman Rokytskyy