• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 708
  • Last Modified:

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

Hello experts,
Using JDBC to connect to an oracle db.

when I set the transaction isolation level for my connection object as:
myConnection.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITED);

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

Does that mean I can't use TRANSACTION_READ_UNCOMMITED level with Oracle???
0
dttai
Asked:
dttai
2 Solutions
 
andrewstCommented:
Yes - Oracle does not support READ UNCOMMITTED.
0
 
vn77Commented:
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
https://cwisdb.cc.kuleuven.ac.be/ora10doc/appdev.101/b10795/adfns_sq.htm#1007214
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)
G'luck,
vn
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now