Subject | Re: [firebird-support] Transaction Isolation Level - ReadUncommitted |
---|---|
Author | Ivan Prenosil |
Post date | 2008-12-30T23:01:17Z |
> It's stated on Firebird's developer documentation ( http://www.firebirdsql.org/dotnetfirebird/transaction-isolation-Since Firebird does not support ReadUncommitted, obviously provider can't support it too.
> levels.html ) that ANSI/ISO Read Uncommitted isolation level (dirty
> read) was not supported and Firebird's ReadUncommitted level behaves
> like ReadCommitted on Oracle and MSSQL. Firebird's ReadCommitted level
> waits for uncommitted transactions to complete.
> I have an application running via OLDB (LCPI.IBProvider). What I need
> is exaclty ReadUncommitted isolation level (of Firebird) but when I
> choose that option providers says that level is not supported. Is that
> a provider problem or Firebird's?
> Or is there a way to stop waitingYes, instead of
> for uncommitted transactions.
READ COMMITTED NO RECORD_VERSION
use
READ COMMITTED RECORD_VERSION
Ivan.