hi guys:
In a table i want to map using hibernate, there is a business key made of two columns. Considering database issues, the table should have a composite unique constrains.
The issue is that should i use a composite properties mapping in mapping file, for example:

<properties name="keyPair"
unique="true">
<property
name="keyword"
type="string"
update="true"
insert="true"
column="KEYWORD"
not-null="true"
/>
<property
name="serviceNumber"
type="string"
update="true"
insert="true"
column="SERVICE_NUMBER"
not-null="true"
/>
</properties>
after doing that, i have to refer column keyword in hql like this:
className.keyPair.keyword.
I think that this is boring just to make a composite unique declaration.
thanks!

I don't know what you mean but maybe the stuff I told someone else an hour ago can be of help.

http://forums.hibernate.org/viewtopic.p ... 28882591d1

You should make a composite-id declaration. There is nothing more exciting than that :)