Oracle's driver has incorrect isolation mapping
Posted: 14.01.2006, 19:25
Hi.
I just began to play with ZeosDB 6.5.1 alpha (cvs of 10.2005) and found that Oracle's transaction isolation level mapping is incorrect.
Correct mapping is:
tiReadCommitted:
SQL := 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED';
Isolation := OCI_TRANS_READWRITE;
tiRepeatableRead:
Oracle doesn't support this level.
tiSerializable:
SQL := 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE';
Isolation := OCI_TRANS_SERIALIZABLE;
May be no body has found this because default isolation level is read commited.
Regards.
I just began to play with ZeosDB 6.5.1 alpha (cvs of 10.2005) and found that Oracle's transaction isolation level mapping is incorrect.
Correct mapping is:
tiReadCommitted:
SQL := 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED';
Isolation := OCI_TRANS_READWRITE;
tiRepeatableRead:
Oracle doesn't support this level.
tiSerializable:
SQL := 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE';
Isolation := OCI_TRANS_SERIALIZABLE;
May be no body has found this because default isolation level is read commited.
Regards.