This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?
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.