• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

same primary key as foreign key in two table[Hibernate Mapping]

 
prateek urmaliya
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

schema

TABLE_A
=========
id_a[PK]
tx_a_desc

TABLE_B
=========
id_b[PK]
id_a[FK]
tx_b_desc

TABLE_C
=========
id_c
id_a[FK]
tx_c_desc

With id_c and id_a as composite primary key for TABLE_C

What should be the best way to map these?
It�s not normal but I can't change the schema.

I am trying something like this for now

A.java [@Table(name = "TABLE_A")]


B.java [@Table(name = "TABLE_B")]


C.java [@Table(name = "TABLE_C")]


CompositeId.java [@Embeddable]


It works but it's wrong and may break in certain cases.
Ideally nullable should be false in both the cases in A's mapping,
But when I try this I get Repeated column in mapping

Please help
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic