Re: High number of rollbacks from Tomcat web app

[Mark Matthews]

Karsten,

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

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html