Subject | wait/nowait transaction settings |
---|---|
Author | Nick Upson |
Post date | 2007-06-18T13:54:25Z |
I have 2 processes which may both try to update the same row in a
table, currently when this happens I get "update conflict ...", so I
though I would change them both to having a wait transaction, which
would do what I need.
One client is isql (given a short script) the other is a C program,
both running on the server (fedora 5). Firebird is 1.5.4
However, the docs (firebird book p537-539) and the interbase apiguide
(p69) both say that both of these client default to a wait transaction
and both currently are using the default.
Either the docs are wrong, my understanding is wrong, or something
piculiar is happening. Help
table, currently when this happens I get "update conflict ...", so I
though I would change them both to having a wait transaction, which
would do what I need.
One client is isql (given a short script) the other is a C program,
both running on the server (fedora 5). Firebird is 1.5.4
However, the docs (firebird book p537-539) and the interbase apiguide
(p69) both say that both of these client default to a wait transaction
and both currently are using the default.
Either the docs are wrong, my understanding is wrong, or something
piculiar is happening. Help