This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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

Win a copy of Building Microservices this week in the Design forum!
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: JDBC Connection Isolation level query
It's not a secret anymore!