[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Hibernate mapping for table associations with duplicate colu

[ummerh]

We have a table design where child table (Program) has composite PRIMARY KEY(brandId,programId), it has a FOREIGN KEY(brandId) to table (Brand) and another FOREIGN KEY(brandId,programGroupId) to table(ProgramGroup). If you notice carefully here, you'll find that brandId is a repeated column in all the relationships. So when creating Java Objects we have to repeat the "brandId" in all the JPA annotations (@JoinColumn(name="BRD_BRAND")).

Since we repeat the column name, we are forced to use options (insertable=false, updatable=false) while defining the fields. This prevents us from saving the objects successfully with their relationships.

How can we resolve this? We would like to have these objects support "persist()" method.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4024673#4024673

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4024673