title: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true
body: <p>Im using Jboss5.0 with mysql in my application. and there will be lot of concurrent actions and DB contains considerably lot of records. 
  this error is coming frequently.. every now and then.</p>
  
  <pre><code> com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:
   Can't call rollback when
   autocommit=true    at
   com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
      at
   com.mysql.jdbc.Connection.rollback(Connection.java:5192)
      at
   org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:97)
      at
   org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.tidyup(TxConnectionManager.java:783)
      at
   org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:453)
      at
   org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:734)
      at
   org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:362)
      at
   org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:155)
  </code></pre>
  
  <p>can anyone help?</p>
  
  <p>Thanks in advance</p>