Multi Tables on One Entity

Question

I've got three tables as the following example:

Table A
- ID (PK)
- ID_B
- ID_C
- Description

Table B
- ID (PK)
- Description

Table C
- ID (PK)
- Description

The ID's from Table A are not mapped as Foreign Key, but they are (And I Can't change that), how can I map them in only one entity? I tried SecondaryTable but it request me to use the PK of the Table A with the PK of Table B, I tried to reference another field of the table but I wasn't able to do it.

Anybody can help me?

Thanks in Advance!

did you tried this answer ? : http://stackoverflow.com/questions/18283919/is-possible-map-a-single-entity-with-multiple-tables-using-jpa — ThierryC, Jun 28 '16 at 14:49
Yes i Did, but in this solution, Table A,B, C got the Same ID/Field as primary key in all tables, in my case they're not the same field. — user3633580, Jun 28 '16 at 14:53
and with table inheritance ? 1 Abstract entity and 3 child classes maybe ? — ThierryC, Jun 28 '16 at 15:00
This I Didn't, I'll do a little research and answer here latter, thanks! — user3633580, Jun 28 '16 at 15:12
http://stackoverflow.com/questions/997203/jpa-how-to-use-the-same-class-entity-to-map-different-tables — ThierryC, Jun 28 '16 at 15:12
Thanks for the advice but I can use it...I need to code everything on one entity only... — user3633580, Jun 28 '16 at 15:22

score 0 · Answer 1 · answered Jan 11 '17 at 19:16

0

If you could define a view with appropriate join clauses, you could define an entity corresponding to the view and treat it as if it were a table.

answered Jan 11 '17 at 19:16

Jonathan Rosenne

2,159
17
27

Multi Tables on One Entity

1 Answers1