Composite unique keys

[keeyes]

Hi
I know how to generate a composite primary key. I am using a concrete Pk class with @Embeddable annotation. In the entity class I just call getPk and everything is fine

How do I create a composite unique key constraint?

I want a combination FIELD_A, FIELD_B both unique but with a single Constraint name CONSTRAINT_AB

Any help is appreciated

[bill.burke]

composite keys cannot be autogenerated.

[epbernard]

@Table(unique=...) // allows unique constraint on several columns

[keeyes]

Bill
In that case, I suppose the only way is to manually alter the database
to generate that constraint

epbernard
Although I am using this option in many places, In this case I want to check Field_A + Field_B = unique and I suppose that can't be done using @Table(uniqueConstraint = ....)

Also how can I give a constraint name of myself instead of the auto generated name.

[epbernard]

It can. UniqueConstraint get an array string as column names
But you can't define your own name.