• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Connection Isolation level query

 
Raga Baskaran
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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 ?


Regards.
 
K Abhijit
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
refer this thread for details-
http://www.coderanch.com/t/306014/JDBC/java/JDBC-Isolation-level


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
http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html
getDefaultTransactionIsolation

This may vary
JDBC :
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 )

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

Also please do share your observation/results



 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic