Hi All,

I have table A ,Table B and Table C

table B and Table C has parent and children association .

where as Table A does not have any assocition with reamining table .


here my issue is I have a column "DOC_ID" in table A stores Table B's primary Key .

I would like to get some name from the table C by refering Table A's Doc_ID .

I am using <seT> in the TAble A's hbm.xml


like

<Set name='...'>
<key column ="..">
<one-many..../>
</set>


It always trying to refer Table A's primary key....


How can I achieve ???????????????????????????
Can any one suggest me plzzzz....

Hi,
It seems to me that you don't want to post your business information in the forum. But if you can relate your business model to any thing generic like Employee and Business Units, Bids and Items etc..then it might be helpful for someone to answer back.
-Srilatha.

Please try the following:

<property name="docID" column="DOC_ID" type="long"/>
<bag name="nameFromTableC" table="TABLE_C">
<key property-ref="docID"/>
<element type="string" column="NAME" />
</bag>

---
Please rate

hi Lin,
sorry for the late replay.

It is workking fine.

Thx for ur post .


Well

Hi latha,

I thought of my example looks simple .My intention is to make clearer .
So only I have give simple example.