Here my application is relation between Item and Bid. There will be more than one bid for single item. I am explaining problem in detail below.

First table ITEM(Item_Id(primary key) Type Integer, Item_name Type String)

I have two table Second table BID (Bid_Id(primary key) Type Integer ,Item_Id(foreign key) Type Integer , Bid_name Type String )

I have used <many-to-one> tag in my bid.hbm.xml , Now i am able to access aBid.getItem, see the code shown below

[code]
Item item =new Item();
Bid bid=new Bid();
bid=(Bid)session.get(Bid.class, Bid_Id)
item=bid.getItem();
System.out.println(item.getItem_name());
bid.get(Bid.
[/code]

Now its all working fine, but i need to identify my Bid class using the Item_Id (which is Foreign key in BID table)
i.e
session.get(Bid.class, Item_Id)
I hope i have to make some changes at <id> tag in my bid.hbm.xml
. I am showing the bid.hbm.xml below

[code]
<hibernate-mapping>

<class name="com.hibernateproject.bean.Bid" table="jayachandra.BID" >
<id name="bidId" type="int" column="BID_ID" >
</id>
<many-to-one name="item" column="ITEM_ID" class="com.hibernateproject.bean.Item" not-null="true"/>

<property name="item1" type="java.lang.String" column="ITEM"></property>
</class>

</hibernate-mapping>
[/code]


Thanks in advance

JC

HI Jayachandra,

You're many-to-one mapping is correct, however you've got a small error with the next line, which should be mapping the BID_NAME column from the BID table to the name property in your Bid class. This gives you a bid.hbm.xml mapping file as follows:



By default hibernate will pick up the id entity in the corresponding Item.hbm.xml mapping file.

Hope this helps

Andy