Hi,

I have a table A which has a foreign keys x,y which is constrained to a table B (whose Primary keys are x,y).

How do I do this with Hibernate?

Any help would be appreciated.

Thanks

An Example to read for your problem:

<?xml version='1.0' encoding='utf-8' standalone="no"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<class name="Letter" table="LETTERS">
<id name="andicator" column="andicator">
<generator class="assigned"/>
</id>
<!-- foreign key decleration refrences to primary key in next class-->
<many-to-one
name="type_id"
column="type_id"
class="Letter_Type"
fetch="join"
access="property"
not-null="false"
not-found="ignore"
/>
</class>

</hibernate-mapping>

Primary key in other class:

<?xml version='1.0' encoding='utf-8' standalone="no"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<class name="Letter_Type" table="Letter_Type">
<id name="type_id" column="TYPE_ID">
<generator class="assigned"/>
</id>
<property name="letter_type"/>

</class>


</hibernate-mapping>

How did you map class A and class B ? You should have a look here. http://www.hibernate.org/hib_docs/v3/re ... ompositeid

If you define a composite id, it should be sufficient to reference directly property of other table.

Thanks saeed and batmat.
I have given credits to you both :)