I have a method in stateful session bean, which is set transaction "Required". It inserts a few records into serveral tables. The problem is when a insert statement in the middle fails because there's a column missed in the table, the method is still get committed. All the other records get saved except the failed one. If the same procedure but the failed statement is because it violates the check constraint, all the records rollback.
I'm wondering if this is a bug in JBOSS? I'm using Oracle database 8.1.7.