Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.2

I use entity-name to map one object into 2 tables: the "real" objects and the "archived" ones: i duplicate the hbm files, and replace some class="..." with entity-name="...".

Now i want to move a record from the real table into the archived table:
session.delete("real",o); session.save("archived",o);

Actually my object isn't just an object, it's a thing that is mapped to 3 tables (one for the object, one for a related set of objects, and another one-to-one table). So now i have 3 pairs of tables, and 3 pairs of hbm's (looking alike, but slightly different in their many-to-one an one-to-one).

Note that the object also relates to other tables (it has FK's pointing to other tables), which are not duplicated.

1) What's the best way to move a record, with all its related records, from the "real" tables, into the "archived" tables? Since all info is in the mapping files, i think hibernate should be able to do the "deep" copy...

2) What happens with o.getRelatedObjects(), when persistent object o is persisted in table 1, and is suddenly pushed in table 2 by doing save("table2",object)?

3) How can i make my object o transient, without deleting the record from the database? Hibernate.initialize(o.getRelatedObjects()), detach o (close session, and start another one), and invoke save("table2",o) in a fresh session, and cascade="all"?

After much trial and error, i found a sequence that actually does what i need:

1. enable cascade="replicate" (or "all") for the inner-relations between the 3 tables
2. load("real") the object o and all its relations in memory (use Hibernate.initialize)
3. detach this object graph: session.clear()
4. use replicate("archived") to duplicate the object graph o
5. after calling replicate, the persistent object o no longer represents the "real" object but the "archived" object
6. therefore, to delete the "real" object you have to load it again by id.

In code:

I'm still looking for the answers posted in my top post... about what happens to o.getSet() when i call save("archived",o)...

Hi Karel1980: Did you got this functionality working. If Yes, Can you please help me and upload code to this post.