Hi

I am observing interesting behaviour while using Hibernate 2.1.1 within JBoss with a Hypersonic DB - I scanned the FAQ, so apologies if I missed it. This might also be expected behaviour for HsqlDB, in which case I'll rest my case :)

When performing a Session.saveOrUpdate() on a simple object (I tried plain objects, even bi-directional many-to-many which all work!), I see from the log that Hibernate is attempting to perform an UPDATE, but in the end does a DELETE and then INSERT operation.

Is this expected? I have dynamic-updates="true" and mutable="true" on my object... My concern is the impact on referential integrity etc. etc.

Thanks,
Hendrik

How does the log look like?

The JBoss log contains the following:

2004-01-13 14:17:11,329 INFO [STDOUT] Hibernate: update USER set password=?, browserType=?, enableAutoRefresh=?, styleSheet=?, renderOperationResultAsHTML=?, refreshInterval=?, username=?, email=? where id=?
2004-01-13 14:17:11,369 INFO [STDOUT] Hibernate: update ROLE set name=? where id=?
2004-01-13 14:17:17,418 INFO [STDOUT] Hibernate: update USER set password=?, browserType=?, enableAutoRefresh=?, styleSheet=?, renderOperationResultAsHTML=?, refreshInterval=?, username=?, email=? where id=?
2004-01-13 14:17:17,438 INFO [STDOUT] Hibernate: update ROLE set name=? where id=?

Hypersonic's default.script however, contains the following corresponding statements:

DELETE FROM USER WHERE ID=0
INSERT INTO USER VALUES(0,'opentier','default',false,'default',false,30,'admin','testAddress')
DELETE FROM ROLE WHERE ID=0
INSERT INTO ROLE VALUES(0,'Admin')
DELETE FROM USER WHERE ID=1
INSERT INTO USER VALUES(1,'opentier','default',false,'default',false,30,'user','testAddress')
DELETE FROM ROLE WHERE ID=1
INSERT INTO ROLE VALUES(1,'User')

Am I misusing the Session object somehow? Currently I create a Session, get the object and close the Session. I then change the object, create a new Session, and saveOrUpdate() the object...

Any help is very much appreciated!

-Hendrik

This is just Hypersonic, it never stores UPDATEs in its script file, allways first a delete and then an insert with new data. Only the hibernate log shows the SQL really executed by hibernate.

Hi

That explains it then... Thank you very much!!

-Hendrik