Table A{
id INT;
type INT;
AB_id INT;}


B extends A

Table B{
id INT;
Name String;}

C extends A

TABLE C{
id INT;
description String;}



As you see, this is simple inheritance but i can't find how to say that join between A and B, A and C must be via column A.ab_id = B.id and A.ab_id=C.id.

Any ideas?

Hi





Amila

(Don't forget to rate if helps)

No. This is not a decision.

My be this is impossible with Hibernate!!!!????

Hi

why not




Amila

Hi
I don't know why.
My be this is bug.
But when i have only

..
join table="B">
<key column="id"/>
<propertie name="name" column="name"/>
</joint>
..
generated SQL is some like:

..
FROM
A somename0_
LEFT OUTER JOIN
B somename0_1_
ON
somename0_.id= somename0_1_.id
..

when :
..
join table="B">
<key column="id" property-ref="ab_id"/>
<propertie name="name" column="name"/>
</joint>
..

generated SQL is absolutely identical

..
FROM
A somename0_
LEFT OUTER JOIN
B somename0_1_
ON
somename0_.id= somename0_1_.id
..

THE property-ref="ab_id" don't change nothing.

The general question is:
How to join a table using a foreign key other than the primary key

This is a fundamental and essential feature of SQL.