how do you create a composite primary key relationship mapping in you hibernate xml files. I have two tables and i want to run the follow sql:

select sale.storeName
from sale sale, storelocation sc
where sale.store_id = sc.store_id
and sale.storeLocId = sc.storeLocId

I don't understand, your problem, is create a composite primary key, isn't it?

You can use the composite-id:

<class name="Foo" table="foo">
<composite-id name="id" class="Person">
<key-property name="name" type="string" column="name"/>
<key-many-to-one name="address" class="Address" column="addr_id"/>
</composite-id>
<property name="age" column="age" type="string"/>
</class>

my issue is how to make the join :

in my mapping:

where sale.store_id = sc.store_id
and sale.storeLocId = sc.storeLocId

It tells about joins, in section 11.3. Associations and joins:

http://www.hibernate.org/hib_docs/refer ... l-examples

You should use a plugin to test the HQL querys more quickly. You can download the best plugin to test your querys from Hibernate page.

Best regards.

i want to do it in the mappings can i do it like this:

but it get errors since the mapping is to the same class


<many-to-one name="store_id "
column="store_id"
class="com..dao.hibernate.sale"
not-null="true" />

<many-to-one name="storeLocId "
column="storeLocId "
class="com..dao.hibernate.sale"
not-null="true" />

Yes this is fully supported. The order is important. You name the columns using multiple nested column tag instead of a column attribute.

Often this question can be easily answered if you use the tools to reverse a simple schema and see what it generates.

Below is my composite key in my StoreLocation class

StoreLocation Class contains --->

and I added a getter and setter for "id" in my StoreLocation java bean



and my Sales Class I have the below since this is joining to the StoreLocation class with the composite key

Store Class contains--->


and I added a getter and setter for "storelocation" attribute in my

but i get an error:


org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.dao.StoreLocation#com.dao.StoreLoaction@1f2c60d]

if i have one table that has a composite key and the other one has a primary key and i join the two do I need a third link table that contains the primary key or can I just join them the two tables...

the join mapping i want to do is below:


select sale.storeName
from sale sale, storelocation sc
where sale.store_id = sc.store_id
and sale.storeLocId = sc.storeLocId

where where store location can have many sales