Trying to set up a joining of two tables. Using Hibernate 3.1.2 with the following signature:


I have a Hibernate mapping against a database table which is working. However I have another table which contains extra information. I've tried a join in the mapping file but somehow it fails.

Lets call them Table1 og Table2.
Table1 has an attribute TAB1_Var_ID(not a primary key) and not defined as foreign key either(its an performance issue)
Table2 has a primary key TAB2_Var_ID which is connected to the TAB1_Var_ID
There is a many-to-one relationship.
Table1 can contain many TAB2_Var_ID

I am fairly new with Hibernate and don't have a clue what the cause of my problem is. Heres is my join mapping(with pseudonyms)



The variable someText and tab1VarID is in the SomeParentClass which SomeChildClass extends. SomeParentClass is not mapped.

The hibernate mapping is working without the join, but I need the someText value also in that mix.

I have tried reversing it with by mapping SomeParentClass and using <joined-subclass> with SomeChildClass, but I then get a syntax error on joined-subclass