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:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

General question using the following code

tx begin
Oldbj = session.find(1 , XX.class);
session.delete(Oldobj);
session.save(new Newobj("JJJ"));
tx end;

The output of the sql is the insert is issued first then the delete when showsql= true ? Why is this ? The Oldobj is detached object that exists in the database .. and of course the Newobj has not been saved to the database.

post hibernate generated SQL queries.

it's just plain insert into a table and delete ... but not in the expected order
delete from XX where id = ...
insert into XX values ...

sorry it was
insert then delete .. but the expectation was delete then insert

you can change
tx begin
Oldbj = session.find(1 , XX.class);
session.delete(Oldobj);
session.save(new Newobj("JJJ"));
tx end;

to
tx begin
Oldbj = session.find(1 , XX.class);
session.delete(Oldobj);
session.flush();
session.save(new Newobj("JJJ"));
tx end;