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