This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori 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.