hi i am trying group columns together in a table so they have unique value

Mysql ddl looks like this

CREATE TABLE table1(
id bigint(20) NOT NULL auto_increment,
col1 bigint(20) NOT NULL,
col2 bigint(20) NOT NULL,
col3 bigint(20) NOT NULL,
col4 bigint(20) NOT NULL,
UNIQUE KEY (col2,col3,col4),
PRIMARY KEY(id)
) TYPE=MyISAM;

these r the ways i found in the HBRD
1) "A unique-key attribute can be used to group columns in a single unit key constraint " -- 15.1.1 Hibernate Reference Documentation 2.1.3 ( this is what i think i should use )

2) 5.1.5 Composit-id

using composit-id would make it more complex than it should be.
I think its possible to use unique-key to achive this. But there is just not enough about it in the HBRD. Only one line :( (1)

could some one please help me figure out how i could use unique-key to do this. just a simple hbm.xml for the above mentioned table would do.

Thanx a lot.

add unique-key="something" to all properties which have to be unique in combination.

unique-key is not a valid attribute of property
gave it a try any way, didn't work
thanx a lot for trying once u get to know it please dont forget to tell me

Oh please show some initiative man! We are not here to hold your hand.

The unique-key attribute applies to column mappings, It is trivial to write:

This solution could easily have been found by searching the forum.

thanx a lot Gavin. should have figured it out just by staring at the dtd a bit longer. knock knock.

this is not what we want
<property name="foo">
<column name="FOO" unique-key="FOOBARUK"/>
</property>

<property name="bar">
<column name="BAR" unique-key="FOOBARUK"/>
</property>

create table EVENTS (uid BIGINT not null, foo VARCHAR(255), BAR VARCHAR(255), primary key (uid), unique (title, location))

mysql will complain how big the key is

what we want is this
<property name="foo">
<column name="FOO" length="50" unique-key="FOOBARUK"/>
</property>

<property name="bar">
<column name="BAR" length="50" unique-key="FOOBARUK"/>
</property>

create table EVENTS (uid BIGINT not null, foo VARCHAR(50), bar VARCHAR(50), primary key (uid), unique (title, location))