• 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
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!