Hibernate version:2.1.6

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:MySQL 4.0.20

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

We have the following scenario:

start transaction;
delete a;
insert b;
commit

We noticed that Hibernate is issuing SQL inserts first and then deletes. This is a problem if b is a replacement for a with some keys that are similar and need to be unique in the db. Any ideas how we can tell Hibernate to preserve the order we issues the save's and deletes?

Thanks,

flush the session after the delete is executed.