Hi there,

I have a small question. Supposing I wanted to make three/four
columns in a table unique - i.e 3/4 columns "together" need to be
unique. How do I declare the mapping for it ?

TIA,
sanjeev.

Use composite key mapping:

see http://www.hibernate.org/hib_docs/reference/en/html/mapping.html#mapping-declaration-compositeid

Thanks for the prompt reply.
I am aware of compoosite keys which means
I need another column as the composite key column.
Can I not avoid having another column.
Or better still can I use the primary key as the composite key?
Hope I was articulate enough.
TIA,
sanjeev.

I'm sorry I don't understand what you after.
How about showing an outline of the table definition and decrible what columns need to be unique.

Hi
After reading the doco properly - came to the
conclusion that I don't really need another column.
I can simply bunch the 3/4 columns and declare a
composite key on them.
Am I correct ?

TIA,
Sanjeev.

Yes.

hmm...thanks.
Problem solved for the moment.
Thanks again.