Hi!

We have a problem inserting and updating 2 entities (in same transaction) when a trigger is attached on a table of one of those entities table.

This is the scenario:

entityADao.save(entA); //---> entity is on database and entA has that id. So it produce an update
entityBDao.save(entB); //----> entity is not on database. So it produce an insert
//Trigger on insert or update or delete on entB table update some values of entA table

Then the hibernate log is this:
1) insert into ENTB...
2) update ENTA....

So trigger is executed on step 1 (updating ENTA table), then step 2 overwrite the updates values of the trigger.

The relation between entA and entB is entaA 1------0..N entB

So why the statements are inverted when hibernate make the queries? Is there a way to surround this problem?

The only approach that came to my mind is to fetch between step 1 and step 2.

Thanks,
Francisco.

The order that Hibernate executes the SQL statements are documented here: http://docs.jboss.org/hibernate/core/3. ... e-flushing

The solution to your problem is to explicitly call flush() before entB is saved.

When I said fetch I mean flush.

Thanks for you reply. It was very helpful.