0 Replies Latest reply: Feb 23, 2012 10:35 AM by fpezzati RSS

    force a commit in EJB3

    fpezzati Newbie

      Hello everybody,

       

      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.

       

      Francesco