java.sql.Connection.TRANSACTION_READ_UNCOMMITED doesn't work in Oracle?

Posted on 2004-11-03
Last Modified: 2008-01-09
Hello experts,
Using JDBC to connect to an oracle db.

when I set the transaction isolation level for my connection object as:

then run time error said:
Message: READ_COMMITED and SERIALIZABLE are the only valid transaction levels

Does that mean I can't use TRANSACTION_READ_UNCOMMITED level with Oracle???
Question by:dttai
    LVL 15

    Assisted Solution

    Yes - Oracle does not support READ UNCOMMITTED.
    LVL 2

    Accepted Solution

    Oracle only supports READ_COMMITED and SEARIALIZABLE as being very obvious in your error msg.
    To see it for yourself, you can read this chapter from Oracle doc
    In case the link doesn't work, you can go to Oracle site and find the followng document:

    Oracle® Database Application Developer's Guide - Fundamentals
    10g Release 1 (10.1)

    Read chapter 5 (pretty short)

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now