Sorry forgot to mention that, I'm running JBoss 4.0.5 and JDK5
Couple of things to check:
* Are you using a transaction-aware table type in MySQL? For instance, MyISAM is not, InnoDB is.
* Is MySQL set to auto-commit? Must not be.
Hope one of these might help you out.