HIbernate check constraint name through JPA

Question

Consider the following

@Entity
@Table
@Check(constraints = "A IS NOT NULL OR B IS NOT NULL")    
public class Model {

@Id
private Long id;

private A a;

private B b;

}

Problem is I do not know how I can name the checkConstraint ? What I want is something like @Check(constraints = @Constraint("name"="CHK_CONST_1", "A IS NOT NULL OR B IS NOT NULL"))

According to the Hibernate documentation this is not possible. — Simon Martinelli, Nov 10 '18 at 01:41
did you try this one https://stackoverflow.com/questions/31983454/hibernate-check-annotation — Supun Kavinda, Nov 10 '18 at 19:40
@SimonMartinelli - I too tend to believe so , but thanks for confirming — avenugopalan, Nov 12 '18 at 18:44

score -1 · Answer 1 · answered Nov 10 '18 at 19:49

-1

I think you should used @Column and name attribute to specify the name of columns.

@Entity
@Table
@Check(constraints = "COL_A IS NULL OR COL_B IS NOT NULL")    
public class Model {

   @Id
   private Long id;

   @Column(name = "COL_A")
   private A a;

   @Column(name = "COL_B")
   private B b;

}

check this :- Hibernate Check Annotation

answered Nov 10 '18 at 19:49

Supun Kavinda

308
1
6
20

1

I believe OP is after Constraint name, not column name? – pirho Nov 11 '18 at 17:52
That is right. My question was to name the check constraint. But thanks for missing @Column for it to work – avenugopalan Nov 12 '18 at 18:43

HIbernate check constraint name through JPA

1 Answers1