| Subject | Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock |
|---|---|
| Author | Gabor Boros |
| Post date | 2016-04-28T18:16:13Z |
2016. 04. 28. 17:46 keltezéssel, Thomas Steinmaurer ts@...
[firebird-support] írta:
(SELECT ... WITH LOCK and UPDATE ...)). But failing with the real
application(SP).
Try to utilize WITH LOCK because I need many unique number generators in
a table field. Like a generator/sequence but under transaction control.
Gabor
[firebird-support] írta:
> What happens if you are running Read Committed WITH record version?No error with 10 concurrently instances of the test app (2 SQL lines
(SELECT ... WITH LOCK and UPDATE ...)). But failing with the real
application(SP).
Try to utilize WITH LOCK because I need many unique number generators in
a table field. Like a generator/sequence but under transaction control.
Gabor