Mapping enum to string in hibernate

Question

I've got a Category Hibernate model:

@Entity
@Table(name = "category")
public class Category {

    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    @Column(name = "id")
    private long id;

    @Column(name = "type")
    private String type;

which have a type string field. Also I've got a Java enum which represent a type of a category:

public enum CategoryType {
    INCOME, OUTCOME;
}

which I would like to use instead of the string type. The SQL accepts two distinct values in the varchar parameter: either CategoryIncome or CategoryOutcome. I would like the Category model class to accept an enum variable - and map it somehow to the string whenever hibernate asks for it.

Is it possible?

dcernahoschi · Accepted Answer · 2013-04-13 13:39:06Z

248

Yes, is possible. It should be:

@Enumerated(EnumType.STRING)
@Column(name = "category_type")
private CategoryType categoryType;

answered Apr 13, 2013 at 13:39

dcernahoschi

15.3k5 gold badges40 silver badges62 bronze badges

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

6 Comments

membersound Over a year ago

You can even go further and, now as JPA 2.1 is released, use

@Converter(autoApply = true) public class CategoryTypeConverter implements javax.persistence.AttributeConverter <CategoryType, String>

ZeroOne Over a year ago

For anyone who might have the same problem..: I had to put this annotation to my getter method instead of the field, like this: @Enumerated(EnumType.STRING) public CategoryType getCategoryType() { return this.categoryType; }.

Arashsoft Over a year ago

I was in hibernate.ddl-auto=update mode and I had to drop my table and let hibernate create it again in order to convert my enum from int to varchar. Hopefully it helps someone with similar issue.

dmytroy Over a year ago

See stackoverflow.com/questions/44864675/… if your enumeration value is being written as ordinal despite Enumerated annotation.

Andrew Over a year ago

I do not put it on the getter. Putting it on the variable declaration works fine, which is good for Lombok using @Data, etc. What if I want to apply this to all Enums without annotating each one?

|

Ahmed Ashour · Accepted Answer · 2020-10-26 15:35:06Z

5

The accepted answer is not sufficient for PostgreSQL. I attach the implementation that worked for me:

https://stackoverflow.com/a/64021041/5279996

edited Oct 26, 2020 at 15:35

Ahmed Ashour

5,66310 gold badges41 silver badges63 bronze badges

answered Sep 25, 2020 at 4:47

Braian Coronel

23k4 gold badges64 silver badges69 bronze badges

Comments

Patrick · Accepted Answer · 2023-11-10 07:46:49Z

0

I had to add

@Column(columnDefinition = "VARCHAR(30)")

to @dcernahoschi solutions to make it work.

@Column(name = "category_type", columnDefinition = "VARCHAR(30)")
@Enumerated(EnumType.STRING)
private CategoryType categoryType

Without I got the Exception

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "

edited Nov 10, 2023 at 7:46

answered Oct 8, 2022 at 11:54

Patrick

1294 bronze badges

1 Comment

Oscar F Over a year ago

Thanks Patrick. Otherwise there is no need to use two @Column annotations. It's does not work. use just one: @Column(name = "category_type", columnDefinition = "VARCHAR(30)").

Collectives™ on Stack Overflow

Mapping enum to string in hibernate

3 Answers 3

6 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related