Hi Linda, Mark,
> > Regarding the unique index vs unique constraint argument: A unique Index always implies a unique constraint, but not the other way around, isn't? In reality afaik most JPA providers already generate a unique index even if you only use @UniqueConstraint. Btw, I don't see adding a @Index(unique=true) making things worse. People will find out pretty soon if they defined too many indices.
> >
>
> I don't think it makes things worse, but I don't see that it contributes much either. I'm ok with going either way
> on this, but I'd like to get more input from others on this point though.
One might want to allow (and require) dropping the columnNames if the
name of a UniqueConstraint coincides with that of an Index and thus go
without a unique attribute for Index. This would avoid duplication and
not put too much burden on the developer.
Best regards
Rainer
---
Rainer Schweigkoffer SAP AG Walldorf
Java Persistence TIP Core JI
Core Java Infrastructure Dietmar-Hopp-Allee 16
Technology & Innovation Platform D-69190 Walldorf
Building 3, I.3.14 phone: +49 6227 7 45305
rainer.schweigkoffer_at_sap.com fax: +49 6227 7 821177
Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Werner Brandt, Bill
McDermott (Co-CEO), Gerhard Oswald, Vishal Sikka,
Jim Hagemann Snabe (Co-CEO)
Vorsitzender des Aufsichtsrats/Chairperson of the SAP
Supervisory
Board: Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269
Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse
oder sonstige vertrauliche Informationen enthalten.
Sollten Sie diese E-Mail irrtuemlich erhalten haben, ist
Ihnen eine Verwertung des Inhalts, eine Vervielfaeltigung
oder Weitergabe der E-Mail ausdruecklich untersagt. Bitte
benachrichtigen Sie uns und vernichten Sie die empfangene
E-Mail. Vielen Dank.
This e-mail may contain trade secrets or privileged,
undisclosed, or otherwise confidential information. If you
have received this e-mail in error, you are hereby
notified that any review, copying, or distribution of it
is strictly prohibited. Please inform us immediately and
destroy the original transmittal. Thank you for your
cooperation.