[jboss-user] [EJB 3.0] - Re: How to define unique constraint on foreign keys ?

[chawax]

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 = {@UniqueConstraint(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