Hi,

This is kinda related to a couple of earlier posts involving attempts to migrate data from one database to another...

According to the documentation, delete() on a persistent object should revert its state to Transient so it should be able to delete an object using a Session from SessionFactoryA (configured for database 1) then save it to another DB by calling save() on a Session from SessionFactoryB (configured for database 2).

Unfortunately I get a telling me that there was a problem synchronizing the database state with the Session.

This is the same kind of exception that I would expect if delete() wasn't called implying that the state change back to Transient is conceptual and hibernate doesn't actually do anything to null out IDs etc.

Anyone had similar or contrary experiences.