1 entity - 2 tables

srbox · **Joined:** Sat Sep 16, 2006 8:05 am **Posts:** 2

Hibernate version: in JBoss 4.0.4ga

Name and version of the database used: Oracle 10 XE

Hi,
I was digging around the docs, but still unable to answer this one.

Is it posible to map the same POJO class on 2 tables with the same structure. It's not an example of inheritance or splitting data from one class on several tables. Is it possible to save the same type of entities in diffrent tables? And if it is, what annotation && EntityManager behaviour would it take to work (I can probably find that on my own, but can someone just tell me if I'm on a wild goose chase)?

emmanuel · **Posted:** Sun Sep 17, 2006 10:22 pm

it is possible through entity-name but not with annotations, you'll have to use hbm.xml files

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

what about @SecondaryTable ?

srbox · **Joined:** Sat Sep 16, 2006 8:05 am **Posts:** 2

Tnx emmanuel, I'll have to digg some more to make it work. I was working with annotations from the start, so I have to look into xml configurations.

@SecondaryTable would split fields of one instance over several tables. I need to store a whole instance either in table1 or table2.

andydale · **Posted:** Thu Oct 05, 2006 4:33 am

Hi,

I also have the same requirement to save a complete entity in 2 tables, and I currently trying to get it to work with entity-name in hbm.xml mapping files (and the hibernate mbean).

I read this page
http://www.hibernate.org/hib_docs/v3/reference/en/html/persistent-classes.html#persistent-classes-dynamicmodels
And saw it used a Session object and Transaction object to save the maps, but i would like to get it to work with the EntityManager i.e. em.Persist(), is this possible ??

Cheers,

Andy