Subject | Re: [Firebird-Architect] Supported transaction isolation levels? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2005-04-05T15:20:07Z |
Nando,
I believe
;-)
The reason why I'm asking is:
- The term "REPEATABLE READ" isn't used in any isolation level related
documents with Firebird/InterBase I've found
- Helen's book says (p. 523): "Mapping to the standard governance of
REPEATABLE READ and SERIALIZABLE is not possible."
So, where is the difference between SNAPSHOT and REPEATABLE READ. ;-)
Thanks,
Thomas
> TS> Looking through different Firebird related documentations (Helen's book,I know.
> TS> IBP pdf set, ...), it seems that Firebird doesn't support the
> TS> SQL-compliant transaction isolation level "REPEATABLE READ". Is this
> TS> correct?
>
> Boy, Firebird is about the only DBMS that has supported it decently,
> i.e. without blocking writers, since day 0.
I believe
> isc_tpb_concurrency + isc_tpb_wait is what you're after. BTW that'sI know.
> the default setting.
;-)
The reason why I'm asking is:
- The term "REPEATABLE READ" isn't used in any isolation level related
documents with Firebird/InterBase I've found
- Helen's book says (p. 523): "Mapping to the standard governance of
REPEATABLE READ and SERIALIZABLE is not possible."
So, where is the difference between SNAPSHOT and REPEATABLE READ. ;-)
Thanks,
Thomas