Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

do we need to change transaction isolation level during life of a connection?

 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Thank you for reading my post.
As we have several transaction isolation level in jdbc connections, I want to ask is there some cases that we need to change transaction isolation level during life of a connection?

for example we use a connection to insert some student and now we change the isolation level to fetch some students?


Thanks
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It would be very unusual to change the isolation level during the connection lifetime. While there may be a benefit in very high performance environments, that would require very careful planning up front, and a solid understanding of the internals of the database being used. In general there should be no need to do this.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic