0 Replies Latest reply on Dec 2, 2009 11:31 AM by Shalom Kazaz

    Transaction retry

    Shalom Kazaz Newbie

      Hi
      we are trying to solve a problem with MySQL deadlocks, as suggested by the MySQL team the solution is to retry the transaction.

      A transaction deadlock causes InnoDB to roll back the entire transaction. You should normally retry the whole transaction when this happens

      http://dev.mysql.com/doc/refman/5.0/en/innodb-error-handling.html

      we tried finding a solution, or how to install a global transaction interceptor that will work for all applications running on that JBoss instance. but we could not find a way to do that.
      is adding an interceptor to ejb3-interceptor the solution suggested by the JBoss team?

      could someone please advice a good solution?

      we are using jboss 4.2 and ejb 3

      Thank you.