Re: [q] TRANSACTION_READ_UNCOMMITTED supported?

A copy of this was sent to swansma_at_my-deja.com (if that email address didn't require changing) On Sun, 26 Sep 1999 16:00:08 GMT, you wrote:

>Hello,
>
>I'm trying to set the isolation level (JDBC) (Oracles' classes111.zip)
>to TRANSACTION_READ_UNCOMMITTED and I get the exception:
>
>java.sql.SQLException: setTransactionIsolation: Only supports
>TRANSACTION_READ_UNCOMMITTED
>

No, Oracle does not support dirty reads.

We always have non-blocking reads (which is the reason other vendors implement a "dirty read" -- to avoid queries that contend for data with inserts/updates/deletes) so the need for dirty reads just isn't there.

>Is there some sort of bug with the type-4 drivers from Oracle?
>
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Sep 26 1999 - 13:01:21 CDT