| Subject | Re: [firebird-support] Transactions in firebird (on behalf of Slavo) |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2006-04-21T15:58:11Z |
Adam wrote:
In that mode, read/write conflicts are reported as deadlock
errors. For example, you read all of table 1. I add a
a record to table 1, without committing. You read all of
table 1 again. If you're in IBASE_REC_NO_VERSION, you
get a deadlock error. Without that, you see exactly the
same records you saw before.
Which result do you prefer?
Regards,
Ann
>Yes. Don't use IBASE_REC_NO_VERSION.
> Now I use
> ibase_trans(IBASE_WRITE|IBASE_COMMITTED|IBASE_REC_NO_VERSION|IBASE_WAIT,$dbhi
> );
> Can you please help me?
In that mode, read/write conflicts are reported as deadlock
errors. For example, you read all of table 1. I add a
a record to table 1, without committing. You read all of
table 1 again. If you're in IBASE_REC_NO_VERSION, you
get a deadlock error. Without that, you see exactly the
same records you saw before.
Which result do you prefer?
Regards,
Ann