Thanks. But what I need is a unique constraint on multiple columns, including 
columns that are foreign keys.

Anyway, I solved my problem by using the attribute "name" of the JoinColumn 
annotation instead of the property name. 

@javax.persistence.Table(
  |             name = "UNITE_EMPLOYE",
  |             uniqueConstraints = {
  |                             @javax.persistence.UniqueConstraint(columnNames 
= {"EMPLOYE_FK", "NOEUD_ORGANISATION_FK"})})
  | 

What is strange is that in the Hibernate documentation, it is said :

anonymous wrote : The @Table element also contains a schema and a catalog 
attributes, if they need to be defined. You can also define unique constraints 
to the table using the @UniqueConstraint annotation in conjunction with @Table 
(for a unique constraint bound to a single column, refer to @Column).
  | 
  | @Table(name="tbl_sky",
  | uniqueConstraints = [EMAIL PROTECTED](columnNames={"month", "day"})}
  | )
  | 
  | A unique constraint is applied to the tuple month, day. Note that the 
columnNames array refers to the logical column names.

Am I wrong when I think that logical column name is the property name of the 
entity bean ? Or maybe there's a difference between Hibernate and EJB3 entities 
about this ?

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4095104#4095104

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4095104
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to