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

Hey,

http://www.hibernate.org/hib_docs/v3/re ... ompositeid

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.accuserverx.accucharge.dao.hibernate.sale"
not-null="true" />

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


Hey batman give me credit as well...

many-to-one requres all the columns of the parent's key. so if you have 2 attributes in your composite-key, you need to reference back 2 columns in the many-to-one.

Otherwise your many-to-one could actually return more than one parent.

Sorry, I can't. Only the poster (you on this case) has access to the vote... Helpers can only receive credits. Try to help some others reading their post, you'll that there's nowhere to click like in this thread.


I totally agree about referencing all the columns of the composite key, but are you sure it's possible to use more than one column attribute? I thought it was not possible, first because XML would not permit it. Well, however I'm sure something like this one would work :

At least, that's the syntax used in the ref doc : http://www.hibernate.org/hib_docs/v3/re ... ompositeid

HTH

yeah, you're right about the xml syntax, I wasn't paying attention. just copying and pasting.

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


but i get an error


Error while initializing hibernate: Could not read mappings from resource: /com//dao/hibernate/Sales.hbm.xml


since the column attribute is defined twice in the above and is invalid...













<hibernate-mapping>
<class
name="org.example.composite.SalesLocation"
table="saleLocation">

<!-- applicationPK is another class the implements Serializable -->

<composite-id
name="salePK"
class="org.example.composite.ApplicationPK" >

<key-property name="store_id" column="store_id" type="string" />
<key-property name="storeLocId" column="storeLocId" type="integer"/>

</composite-id>

</class>

</hibernate-mapping>


Here is an example of the Composite key class
public class Application {
private ApplicationPK applicationPK;
//declare other properties
//declare constructor
}
public class ApplicationPK implements Serializable {

//declare composite properties
// declare constructor

}

How to call the query
Note you need to set the required setter method in the composite key class
ht.load(Application.class,applicationPK)

Suzie, please read my answer to what kochcp said. There is a mistake in what he gave, use the following form instead:


And please, please use the code tags, above the edit window, so as to make you more readable.

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]

batmat I did what you said if you see my posting above but I get an error in the getter and setter... I am not sure what I should have in javabean for the composite key... since I get the error....

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

org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:27)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:128)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:161)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:889)
org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:857)
org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
org.hibernate.type.EntityType.resolve(EntityType.java:303)
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113)
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
org.hibernate.loader.Loader.doQuery(Loader.java:717)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2150)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1550)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:298)
org.hibernate.impl.CriteriaImpl$Subcriteria.list(CriteriaImpl.java:143)
com.web.SearchSalesAction.execute(Unknown Source)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

which is not due to the column since I put them as you said above

It's just saying that it can't find the row in the db you're asking for. Are you sure the instance you're requesting in the db? Did you valued both keys of your javabean before trying to retrieve it ?


According to this mapping:

your javabeans should have set/getStore_id() and set/getStoreLocId() methods.

i get the same error if i do that for the mapping

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


as if dont have a getter and setter for sale... all these combinations dont work and when i remove the composite key and

i have the mapping now i get result for this but not for composite...

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

it didnt work batmat