Annotation @Column(unique=true) does not prevent duplicate insertions

[pdhaigh]

I have a simple model class:

@Entity
@Table(name = "destinations")
public class Destination implements Serializable
{
        private static final long serialVersionUID = 1L;

        @Id
        @GeneratedValue
        private Long id;
        @Length (max=75)
        private String title;
        @Length (max=500)
        private String description;
        @Length (max=1000)
        private String keywords;
        
        @Length (max=100)
        @Column (name="name",unique=true)       
        private String name;
//snip

I expected this would prevent persistance of destinations with duplicate names.. however, the application still allows me to add as many destinations with the same name as I like.

How can I use the @Column(unique=true) annotation to enforce this?

[quaidbrown]

Not sure, but I use the @NaturalId annotation for this.

[francof]

I am a newbie to Seam, Hibernate ... , so I might be wrong.

unique=true is only needed if you intend to generate your schema from your entity class.

See this post http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073319#4073319

I went with approach D since my unique column is my surrogate key.

[quaidbrown]

Ya, I think the constraint on that field is only put in place if you let it create the tables for you when you start up, by specifying create-drop or something similar in persistence.xml.

I don't think it will add a constraint after the table already exists. So that's something to try.