Hibernate xml mapping one key to two other tables

Question

I've got the 3 following tables:

    Table1:
    keyA; keyB; keyC; (primary key is A+B+C)

    Table2:
    keyA; keyC; (primary key is A+C)

    Table3:
    keyA; keyB; (primary key is A+B)

With hibernate xml mapping I want for my Table1 to be linked to both Table2 and Table3 using these keys. Can I do that?

score 0 · Answer 1 · answered Feb 13 '18 at 15:32

0

simply describe a link many to many between the table 2 and 3 by the jointable table 1. cf this example: enter link description here

answered Feb 13 '18 at 15:32

titiabackup

9
2

score 0 · Answer 2 · answered Feb 13 '18 at 15:41

Well in your first Table Table1 you have (primary key is A+B+C), and you are asking:

With hibernate xml mapping I want for my Table1 to be linked to both Table2 and Table3 using these keys. Can I do that?

Yes, you can do that, but your two other tables Table2 and Table3 must have all the keys/columns that represent the Primary key of Table1, so they must contain the three columns keyA, keyB and keyC along with a OneToMany mapping between Table1 and both Table2 and Table3.

Hibernate xml mapping one key to two other tables

2 Answers2