Hello
I m uisng Hibernate 3.2.5 and i m new to hibernate technology
I want to know how to map Primary key and foreign key in my .xml file
Following is the table structure

Products
pid----> PK (has been referred as FK in 3 tables)
name
etc

Discounts
did---> PK
pid---> FK from products table

How do write XML for mapping these two tables

this is the code in Discount.hbm.xml
<hibernate-mapping>
<class name="discounts" table="discounts_tbl">
<id name="did" type="int" column="did" >
<generator class="assigned"/>
</id>

<id name="productId" type="int" column="productId" >
<generator class="foreign"/>
</id>
<many-to-one name="prd" class="products" column="productId"/>


<property name="quantityFrom">
<column name="quantityFrom"/>
</property>
<property name="quantityTo">
<column name="quantityTo"/>

.....
....
.....

etc

Please HELP.
Regards Vikram

Your mapping seems to be quite OK. Try with this mapping and let us know if you have any issues.

?????

From the Discount.hbm.xml u specified remove the
<id name="productId" type="int" column="productId" >
<generator class="foreign"/>
</id>

Then your mapping is fine.

Thank you


It worked fine
Do i need to make any changes in products.hbm.xml
this is the code for products.xml

<hibernate-mapping>
<class name="products" table="products_tbl">
<id name="productId" type="int" column="productId" >
<generator class="assigned"/>
</id>
<property name="productShortName">
<column name="productShortName" />
</property>
<property name="productDescription">
<column name="productDescription"/>
</property>
<property name="unitOfMeasurement">
<column name="unitO....

..
..

I have one more problem .If you can spare 5 mins for me...it would be really great.

products mapping also seems fine.