File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC Connection Isolation level query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC Connection Isolation level query" Watch "JDBC Connection Isolation level query" New topic

JDBC Connection Isolation level query

Raga Baskaran

Joined: Sep 16, 2010
Posts: 3

What is the default isolation level of a JDBC connection, Is it dependent on the database driver/ database type we use or can it be controlled programmatically ?

K Abhijit
Ranch Hand

Joined: Mar 03, 2008
Posts: 88
refer this thread for details-

Well not all Isolation levels are supported by all Vendors.....

1. we have methods to check if the particular isolation level is supported or not
2. We can change the run time isolation level.

Also it depends on vendor :: for Oracle default level which get set is TRANSACTION_READ_COMMITED
but when Googled, I found few contradictory statements:

Best way is find out you self: we have API to find it out

This may vary
A. vendor to verndor in (oracle / sql servers / mysql / (Pure Java running outside App servers)
B. JDBC running inside App Containers (websphere / Bea ...) (if App container Vendor tries to override default level set by Database Driver Vendor )

a. App Containers level (Websphere / Bea ...)

Also please do share your observation/results

“The difference between 'involvement' and 'commitment' is like an eggs-and-ham breakfast: the chicken was 'involved' - the pig was 'committed'.”
I agree. Here's the link:
subject: JDBC Connection Isolation level query
It's not a secret anymore!