Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

JDBC Isolation level?

 
Ranch Hand
Posts: 10192
3
Mac PPC Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys,

What is called a JDBC Isolation level?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Its the level of isolation a transaction uses. Databases support different isolation levels that usually represent a trade of of data integrity vs. performance. For example the isolation level TRANSACTION_SERIALIZABLE means the database treats the transactions as if they are serial (i.e. one transaction at a time) so you get high guarentees of data integrity, but poor performance. At the other end you have TRANSACTION_READ_ UNCOMMITTED which allows other transations to read data that has yet to be committed. So you will get what are know as "dirty reads", but much improved performance since nothing is blocking a read.

Have a read of the JavaDocs for java.sql.Connection, it has some static variables defining the transaction isolation levels a database may support.
 
Joe Harry
Ranch Hand
Posts: 10192
3
Mac PPC Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I understood your explanation. But what would be the choice to go?? Level 4 or Level 0?? or does it purely depend on the necessity to use either Level 4 or Level 0??
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by Jothi Shankar Kumar Sankararaj:
But what would be the choice to go?? Level 4 or Level 0?? or does it purely depend on the necessity to use either Level 4 or Level 0??


Yes. You will know if your application can support dirty reads, or needs the absolute data integrity supplied by serializable isolation. Have a read of this.
 
Joe Harry
Ranch Hand
Posts: 10192
3
Mac PPC Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'll try the link and post if any further doubts that I might have.

Thanks for the link!
 
Any sufficiently advanced technology will be used as a cat toy. And this tiny ad contains a very small cat:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic