Hi all,
I've got a small question which gives a real headache...
i've got 2 tables, say A and B.
A has an ID and NAME
B has an ID and A_ID which is a foreign key to A

now i've create an object named B_OBJ and i wanna hold in it ID, A_ID and NAME (which should comes from A table..)
does anyone knows how to do that?
I've tried using formula and join and no success (probably doing something wrong..)

any help will be appriciated..
Y.

You should have someting like this in your mapping file.

<!-- bi-directional many-to-one association to Table A-->
<many-to-one
name="TABLEA"
class="com.xxx.TableA"
not-null="true"
>
<meta attribute="use-in-equals">true</meta>
<meta attribute="field-description">
@hibernate.many-to-one
not-null="true"
@hibernate.column name="A_ID"
</meta>
<column name="A_ID" />
</many-to-one>

And your pojo will have an private attribute of class com.xxx.TableA and a get and set method.

Hope this helps.

Thanks
Sudhakar