Hello,

I need do disable an unique constraints for the time of an update.
Consider the following example:

@Entity
  | @Table(uniqueConstraints = @UniqueConstraint(columnNames = { "personID", 
"fieldID" }))
  | public class SomeMappingTable {
  |   private Integer personID;
  |   private Integer fieldID;
  |   // ...
  | }


Ok, assume I have to entries in it
fieldID: 1 ("Mathematics")
  | fieldID: 2 ("English")


The user has 2 combos: in the first Mathematics is selected, in the second one 
English.
Now, if the users switches the values (Mathematics -> English and English -> 
Mathematics) the unique constraint is violated because after the first update 
the table would contain English twice.

So, the only way how to solve the problem is to disable the unique constraint 
for the time of the update. Maybe somebody knows another solution.

Thanks a lot,
Kasperl

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

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

Reply via email to