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

[prateek urmaliya]

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")]

@OneToMany(fetch = FetchType.LAZY)
@JoinColumn(name = "id_a", nullable = false)
  public Set<B> getB() {
    return b;
  }
  
@OneToMany(fetch = FetchType.LAZY)
@JoinColumn(name = "id_a", nullable = true)
  public Set<C> getC() {
    return c;
  }    

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

    
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "id_a", nullable = false, insertable = false, updatable = false)
    public A getA() {
      return this.a;
  }

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

    
@AttributeOverrides( { @AttributeOverride(name = "id_a", column = @Column(name = "id_a", nullable = false)),
        @AttributeOverride(name = "id_c", column = @Column(name = "id_c", nullable = false))})
        public CompositeId getId() {
    return id;
  }

CompositeId.java [@Embeddable]

    
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "id_a", nullable = false, insertable = false, updatable = false)
    public A getA() {
      return this.a;
  }

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