order by on composite key

ramps · **Joined:** Mon Nov 20, 2006 2:09 am **Posts:** 1

hey guys!
Can anyone help me with using composite key in hibernate. i have a composite key in my hbm, code as follows
<class name="AnswerSet" table="ANSWER_SET_MEGA_TABLE" >
<composite-id name="answerPK"
class="com.hp.ckmds.dao.hibernate.AnswerPK" >

<key-property name="UniqueId" column="UNIQUE_IDENTIFIER" type="string" />
<key-property name="CodifiedValue" column="CODIFIED_VALUE" type="string"/>

</composite-id>

Now in my code using HQL i want to sort the records using order by and that too on the composite key. how can i do that?

Thanks,

gskempes · **Joined:** Mon Nov 22, 2004 11:21 am **Posts:** 42

You have to use the name of the composite key or "id" as qualifier for the PK columns, e.g.:

Code:

from AnswerSet
order by answerPK.UniqueId, answerPK.CodifiedValue

or:

Code:

from AnswerSet a
order by a.answerPK.UniqueId, a.answerPK.CodifiedValue

or:

Code:

from AnswerSet a
order by a.id.UniqueId, a.id.CodifiedValue

Regards,
Georg