Moving objects between different tables

dinotoa · **Joined:** Mon Apr 03, 2006 4:54 am **Posts:** 4

For a road traffic information management application we need to retain created objects for archiving purposes, therefore we have 'active' objects and 'archived' objects, only distingued by a flag.
The object graph is quite complex.
Is there a method to move archived objects (for performance reasons) from one sets of tables to another one without creating a fake class hierarchy?
Thanks in advance.

steckemetz · **Posted:** Mon Apr 03, 2006 5:25 am

You may try entity names for this purpose.
The mapping will look like:

Code:

<class name="MyClass"
entity-name="MyEntity"
      table="mytable">

Saving is like:

Code:

session.save("MyEntity", myClass);

Just as a starter.

dinotoa · **Joined:** Mon Apr 03, 2006 4:54 am **Posts:** 4

Looks interesting, thanks.
One question: In such a case how can I manage one-to-many and many to many relationships? The objects they point to are supposed to be archived as well.

steckemetz wrote:

You may try entity names for this purpose.
The mapping will look like:

Code:

<class name="MyClass"
entity-name="MyEntity"
      table="mytable">

Saving is like:

Code:

session.save("MyEntity", myClass);

Just as a starter.

steckemetz · **Posted:** Mon Apr 03, 2006 11:45 am

I never used collection mapping togehter with entity-names,
but the documentation says e.g. for many-to-one:

Code:

<many-to-one
...
        entity-name="EntityName"            

that you can specify an entity name.
Hope this helps.

dinotoa · **Joined:** Mon Apr 03, 2006 4:54 am **Posts:** 4

Thanks.
One final question: how can this be applied to ejb3?

steckemetz wrote:

I never used collection mapping togehter with entity-names,
but the documentation says e.g. for many-to-one:

Code:

<many-to-one
...
        entity-name="EntityName"            

that you can specify an entity name.
Hope this helps.

steckemetz · **Posted:** Tue Apr 04, 2006 3:11 am

I do not use ejb3,
but there might be some annotations for entity-names.