> -----Original Message----- > From: KARR, DAVID (ATTCINW) > Sent: Friday, December 04, 2009 4:46 PM > To: [email protected] > Subject: Issues mapping numerous tables to a single entity? > > In Hibernate and JPA, I'm used to looking at scenarios where I map a > single table to a single entity, along with relationships to other > entities with various multiplicities. > > I'm now looking at a situation where I'm going to need to develop a JPA > mapping for a pretty large collection of entities, where the largest > entities actually are defined by an aggregation of numerous tables > (like > 20). What provisions are there in JPA and OpenJPA for mapping multiple > tables to a single entity? I'm not talking about an inheritance > hierarchy, but where the numerous tables are linked by a common PK > value.
I think I figured this out. Using "secondary-table" for all but one table, and having each "column" reference the table it's in, should cover it.
