Re: High number of rollbacks from Tomcat web app
Posted by: Mark Matthews
Date: March 13, 2008 08:12PM


Many connection pools (DBCP included) issue a rollback when the connection is returned to the pool from the application, to ensure that all locks and resources are released, especially if the application had a bug where it forgot to do this itself.

For our JDBC driver, adding "useLocalSessionState=true" to your JDBC URL configuration parameters will prevent the rollback from actually being sent if no transaction is in progress, and you're using MySQL-5.0 or newer.


Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools

Options: ReplyQuote

Written By
Re: High number of rollbacks from Tomcat web app
March 13, 2008 08:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.