Multiple unique-key constraints on a single column

vs94063 · **Joined:** Mon Sep 27, 2010 6:27 pm **Posts:** 1

Is it possible to map multiple unique-key constraints where one of the column is shared by 2 or more constraints?

For example a table with:

columnA
columnB
columnC

Where there is a unique constraint "Unique_A_B" on columns "columnA" and "columnB" and another unique constraint "Unique_A_C" on columns "columnA" and "columnC". How can we map this in hibernate mapping file?

MartinDavey · **Posted:** Tue Sep 28, 2010 12:55 pm

Hi,
I haven't solved your problem, and apologies in advance if you know this already - but in case it helps.

The annotations for the unique keys work for me as follows:-

Code:

@Table(name = "STUFF", uniqueConstraints = {
      @UniqueConstraint(name = "Unique_A_B", columnNames = { "COL_A", "COL_B" }),
      @UniqueConstraint(name = "Unique_B_C", columnNames = { "COL_B", "COL_C" }) })

I have run the hibernate tool <hbm2hbmxml/> on this annotated file but the generated stuff.hbm.xml file did not define the constraints.

Again, sorry if this was obvious to you, but I thought it might help in some way. Martin.