I'm working with JBoss5 and Oracle11g. I do a couple of inserts and a select inside a stateless bean's method. More precisely:
-insert into A values (...);
-select * from A where ...;
-insert into B values (...).
The first insert succeed, the second fails because of a ConstraintViolationException. That's because the second insert took some value from the select, one of those fields is a foreing key (refers to table A). How do I avoid this problem? Does anybody know how to force a commit inside a Stateless bean's method? Is commit the solution? TIA.