Subject | Supported transaction isolation levels? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2005-04-05T14:53Z |
Hi all,
I hope this isn't that much off-topic here, but I do need some type of
confirmation what SQL-compliant transaction isolation levels are
supported in Firebird. ;-)
Looking through different Firebird related documentations (Helen's book,
IBP pdf set, ...), it seems that Firebird doesn't support the
SQL-compliant transaction isolation level "REPEATABLE READ". Is this
correct?
Of course, there is an isolation level called "SNAPSHOT", but are these
equivalent or in particular cases different? I guess there needs to be a
difference, otherwise REPEATABLE READ would have been mentioned.
Thanks for anyone who can share his/her experience.
Regards,
Thomas
I hope this isn't that much off-topic here, but I do need some type of
confirmation what SQL-compliant transaction isolation levels are
supported in Firebird. ;-)
Looking through different Firebird related documentations (Helen's book,
IBP pdf set, ...), it seems that Firebird doesn't support the
SQL-compliant transaction isolation level "REPEATABLE READ". Is this
correct?
Of course, there is an isolation level called "SNAPSHOT", but are these
equivalent or in particular cases different? I guess there needs to be a
difference, otherwise REPEATABLE READ would have been mentioned.
Thanks for anyone who can share his/her experience.
Regards,
Thomas