check constraint annotation for allowed values in hibernate

Question

I have Consumer table in database where I have check constraint on consumer_type column like below:

ALTER TABLE consumer
    ADD CONSTRAINT Check_consumer_consumer_type CHECK (consumer_type IN ('ACCOUNT','ORGANIZATION'))

Now from hibernate side I want to add check constraint annotation which will allow only "ACCOUNT" and "ORGANIZATION" value in consumer type table.

Which hibernate / jpa annotation I should use for this purpose?

Bohuslav Burghardt · Accepted Answer · 2015-10-27 12:44:20Z

6

Assuming that you have the consumer type represented using String in your entity you could easily replace it with an enum and Java's type safety would ensure that you will not be able to pass anything else to it.

Using EnumType.STRING, the values will be stored as Strings in your database (and mapped back to enum when you load the entity), so no change to your data would be required.

Example

@Entity
public class Consumer {

    public static enum ConsumerType {
        ACCOUNT, ORGANIZATION
    }

    @Enumerated(EnumType.STRING)
    @Column(name="consumer_type", nullable=false)
    private ConsumerType consumerType;

    // Other properties, getters/setters, ...
}

edited Oct 27, 2015 at 12:44

answered Oct 27, 2015 at 12:19

Bohuslav Burghardt

35.1k7 gold badges130 silver badges115 bronze badges

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

Collectives™ on Stack Overflow

check constraint annotation for allowed values in hibernate

1 Answer 1

Example

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Example

Comments

Your Answer

Sign up or log in

Post as a guest

Related