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")]
Code:
@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")]
Code:
@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")]
Code:
@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]
Code:
@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
Login
FAQ
Search