Hi,
I need help...I have a problem like I have 2 unrelated tables...
I associated them using <one -to many>..The main issue is I need to join them on Keys which r not primary or foreign keys...
The tables r not related and there r no common keys..

I specified in hbm file:
<many-to-one property-ref="mykey"/>

Though I specified the key on which to do join using
" property-ref", Hibernate is joining on primary keys of the associated class..How to tell hibernate to do join on my specific keys..
There r no fields commonn to both tables...
Any idea how to do this wuld be grt help..
Thnx,.

Do you really need to have this as an association? You can do the JOIN in the query itself... e.g.:



I don't know if it's possible to make it a proper association (because entities are identified by their ID -> the primary key). But perhaps using a formula/filter on the collection could work.

I guess you could make it work as a join...I'm also having this issue, and am a bit confused as to why it doesn't work. My mapping looks something like the following:



Even though the property-ref is set, it always joins on the User entity's primary key, when what it should be doing (if property-ref does what it says on the tin) is joining on the OBJECT_ID column instead.

Hi,
Thnx for the reply..Ya this kind of join works..

But the condition tht I have specified is in subselect of other query..I have a condition where in the main query iam using a primary key of A for join and in subquery I am using other key of A to join with a different table...

So I have to specify the keys to join on....

Any idea how to do?By the way how do v use filters
Thnx

Can you show your mapping files and the query ?

<hibernate-mapping>

<class name="Appt" table="appt">

<id name="apptId" type="int" column="appt_id" >
<generator class="assigned"/>
</id>

<property name="physId" column="phys_id" type="int" />

<set name="resInfo" lazy="false" table="resInfo" inverse="true">
<key column="res_id"/>
<one-to-many class="ResInfo" />
</set>


</class>

</hibernate-mapping>
_________________________________________
<hibernate-mapping >

<class name="resInfo" table="resInfo">

<id name="resId" column="res_id" >
<generator class="assigned"/>
</id>
< property name="lastName" column="last_name" type="string" />

<many-to-one name="appt" class="Appt" insert="false"
update="false" property-ref="physId" fetch="select" unique="true" /> -->1***
</class>
</hibernate-mapping>

___________________________________________
String SQL_QUERY="select appt.apptId,(select resInfoAppt.lastName from appt.resInfo resInfoAppt ) from ResUnit resunit inner join resunit.apptSet appt ";
_____________________________

SelQuery using Hibernate Query Language
Hibernate:

select
apptset1_.appt_id as col_0_0_,
(select
resInfo2_.last_name
from
resInfo resInfo2_
where
apptset1_.appt_id=resInfo2_.res_id) as col_1_0_ --->2***
from
resunit resunit0_
inner join
appt apptset1_
on resunit0_.appt_id=apptset1_.appt_id

My problem is I have specified in line -->1 above

<property-ref="physId"> which is not primary key..

but in the hibernate's select clause on line -->2 its implicitly joining on
appt's primary key which is appt_id..

Why doesnt hibernate do join like in line -->2

apptset1_.phys_id=resInfo2_.res_id

instead of

apptset1_.appt_id=resInfo2_.res_id

Thnx for your help..pls help me what to do?

_________________________________________________

should be