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.