Oracle's driver has incorrect isolation mapping

[ssamayoa]

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.