On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,584 Users
  • 2,269,760 Discussions


Does oracle support TRANSACTION_READ_UNCOMMITTED level?

426225 Member Posts: 3
I am using oc4j drivers with jdbc for oracle 9i
I could not set the transaction isolation level to TRANSACTION_READ_UNCOMMITTED.

Does oracle support this transaction level ?
(SQL Server support it)

Here is the stack trace of the error:

java.sql.SQLException: READ_COMMITTED et SERIALIZABLE sont les seuls niveaux de transaction valides
java.sql.SQLException: READ_COMMITTED et SERIALIZABLE sont les seuls niveaux de transaction valides
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.setTransactionIsolation(OracleConnection.java:1681)

Thanks for any help...


  • Avi Abrami
    Avi Abrami Member Posts: 2,218
    The error message, you have posted, seems very clear -- the only valid values are READ_COMMITTED and SERIALIZABLE. This is also documented in the "Oracle9i JDBC Developer’s Guide and Reference", chapter 19 [Coding Tips and Troubleshooting], in the section entitled "Transaction Isolation Levels and Access Modes". Here is an excerpt:

    the Oracle server supports only the TRANSACTION_READ_
    COMMITTED and TRANSACTION_SERIALIZABLE transaction isolation levels

    As someone who moved from Oracle to Informix, I can tell you from my experience, that different RDBMS's have the same functions, but each works differently. So while you probably needed to use the TRANSACTION_READ_UNCOMMITTED isolation level with "SQL Server", you don't need it for Oracle.

    What you need to do is forget how you do things with "SQL Server", and learn how to do things the Oracle way. As you have seen, trying to transfer "SQL Server" code to Oracle doesn't always work.

    The Oracle documentation is available from


    Good Luck,
This discussion has been closed.