This is a MySQL issue. In particular make sure you are using
the table type that supports this.
MySQL didn't even support transactions until recently.
Also this is not a JCA problem.
thanks for ur response
we r using InnoDB,
and 98% of our transactions commit successfully.
Since JBOSS begins the transaction,it should commit also, but here sometimes it shows some in-between commits and rollbacks in the
MySQL query log.
We just want to confirm that the problem is not from the JBOSS side, is it so??