• 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: 42970
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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!