Tables
Bid (buyer_id,seller_id, amount, date....)
Person(id, name , ...)

buyer_id and seller_id are references to person

In the Bid class I need to show
Buyername, sellerName , amount and date


How do I map this
thanks

une an unmapped getter whitch do buyer.getName()

would'nt a <one-to-one> relation for each of the id's solve the problem? You can then access the buyer name by bid.buyer.name etc.

It'll force you to have the Bid object to contain a "Buyer" as well as a "Seller" object of the same type "Person".

Have never tried it but I guess that should work.

-Anand

A many to one actually. But that was not the asked question.

I am thinking of using buyer = bid.getBuyer(), and then buyer.getName() and buyer.getEmail(), etc. Can anyone help me to complete the mapping below,


<class name="Bid" table="BID">

<id name="id" type="long" column="ID">
<generator class="sequence">
<param name="sequence">BID_ID_SEQ</param>
</generator>
</id>
<property name="sellerId" column="SELLER_ID"/>
<property name="buyerId" column="BUYER_ID"/>
<property name="....>

<set name="buyer" lazy="true"><one-to-one class="Person"/>......</set>
<set name="seller" lazy="true"><one-to-one class="Person">......</set>
</class>

<many-to-one name="buyer" class="Person" key_column="BUYER_ID"/>

I don't know why it's many-to-one not one-to-one though.

it's many-to-one because many of the same buyers in the bid table can point to the one and only one person.