Hibernate non-negative value constraint

Question

I have the table, the snippet below.

    package test;

    import javax.persistence.Column;
    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.Id;
    import javax.persistence.Table;
    import javax.persistence.UniqueConstraint;

    @Entity
    @Table(uniqueConstraints = { @UniqueConstraint(columnNames = "code")},
           name = "coupons")
    public class Coupon implements  Serializable {

        private static final long serialVersionUID = 5534534530153298987L;

        @Id
        @GeneratedValue
        @Column(name = "id")
        private long id;

        @Column(name = "available_count")
        private Integer availableCount = 1;

        public Integer getAvailableCount() {
            return availableCount;
        }

        public void setAvailableCount(Integer availableCount) {
            this.availableCount = availableCount;
        }
    }

How to make constraint to allow for availableCount be only non-negative?

axtavt · Accepted Answer · 2011-01-18 14:46:36Z

5

If you need an actual database constraint, and your schema is generated by Hibernate, you can use @Check annotation:

@Entity
@Table(uniqueConstraints = { @UniqueConstraint(columnNames = "code")},
        name = "coupons")
@Check(constraints = "available_count >= 0")
public class Coupon implements  Serializable { ... }

answered Jan 18, 2011 at 14:46

axtavt

243k42 gold badges518 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Péter Török · Accepted Answer · 2011-01-18 14:37:48Z

3

make use of Hibernate Validator project

edited Jan 18, 2011 at 14:37

Péter Török

117k31 gold badges277 silver badges332 bronze badges

answered Jan 18, 2011 at 14:29

lweller

11.3k3 gold badges37 silver badges39 bronze badges

Comments

Sebastian D'Agostino · Accepted Answer · 2017-11-24 02:01:28Z

2

You can use @Min.

public class Coupon implements Serializable {

    @Min(0)
    @Column(name = "available_count")
    private Integer availableCount = 1;

}

Min documentation: The value of the field or property must be an integer value greater than or equal to the number in the value element

Check all JPA constaints here

They are valid to be used in Hibernate

answered Nov 24, 2017 at 2:01

Sebastian D'Agostino

1,6752 gold badges29 silver badges45 bronze badges

Comments

Christian Kuetbach · Accepted Answer · 2011-01-18 14:39:12Z

1

The easy way would be to make it like this:

public void setAvailableCount(Integer availableCount) {
    if(availableCount < 0){
        throw new IllegalArgumentExcpetion("Must be possive value");
    }
    this.availableCount = availableCount;
}

This won't create a databse constraint.

edit:

If you take use of JPA-Annotations, you can create an @PrePerist-Annotated method:

@PrePersist
public void something(){
    if(availableCount < 0){
        throw new IllegalArgumentExcpetion("Must be possive value");
    }
}

The commit should fail, loading should work.

edited Jan 18, 2011 at 14:39

answered Jan 18, 2011 at 14:31

Christian Kuetbach

16.1k5 gold badges45 silver badges80 bronze badges

6 Comments

sergtk Over a year ago

:) I do now in exactly such way, but it seems ugly for me - I am looking for something hibernate native, e.g. as in SQL we have CONSTRAINT

Adrian Smith Over a year ago

I have had problems enforcing constraints in setters in Hibernate. If you try to load an object from the database, and availableCount has a negative value (ideally obviously that won't happen... but Murphy's law will intervene, at least in my case it does) then when Hibernate loads an object from the DB, it will call this method, the exception will be thrown, and the loading of the object will fail. This also gives you no chance to correct the invalid data, apart from going directly to the database without using Hibernate.

Christian Kuetbach Over a year ago

It seems to be ugly. In fact I don't know a beauty way to do this.

sergtk Over a year ago

@Adrian Smith Anyway how did you enforce constraint? Can you please add a reference here?

Adrian Smith Over a year ago

I think I wrote two methods, setAvailableCount, used by Hibernate, and I made it private (Hibernate could still use it, but people using my code couldn't), and then created another method, like updateAvailableCount, which was available to people using my code, and which contained the if statement. But I wasn't very happy with this solution. The updated answer includes the @PrePersist - I dind't know about that - that would seem to be a better solution.

|

Collectives™ on Stack Overflow

Hibernate non-negative value constraint

4 Answers 4

Comments

Comments

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related