Hibernate map enum to varchar

hibernate enums hibernate-mapping varchar
ipavlic picture ipavlic · Mar 23, 2012 · Viewed 16k times · Source

Suppose I have this enum:

public enum TestEnum { EXAMPLE, FURTHER_EXAMPLE, LAST_EXAMPLE }

With this mapping in the .hbm:

<property name="testEnum" column="TEST_COLUMN">
    <type name="org.hibernate.type.EnumType">
        <param name="enumClass">p.a.c.k.TestEnum</param>
    </type>
 </property>

The enum is sent to the database as 0, 1, 2. I'd like the values to be instead stored as EXAMPLE, FURTHER_EXAMPLE or LAST_EXAMPLE in a varchar column.

How can I map enum to a varchar column?

Answer

bvulaj picture bvulaj · Mar 23, 2012

Add this as a parameter of EnumType:

<param name="type">12</param>

This is because 12 is equivalent to java.sql.Types.VARCHAR

Related questions

Adding an enum as a class property in HBM

I am trying to create a class in HBM file which contains an Enum as a field. The HBM is similar to this: <class name="a.b.c.myObject" table="OBJECT" > <property name="myEnum" column="EXAMPLE" type="…

Read More
How to make key value like enum in java

I need to make an Enum containing some strings with spaces and their values in int like: public enum status{ Active(1), Inactive(2); } because I am using it with hibernate and also will convert it to JSON for alpaca js forms. …

Read More
Mapping enum to string in hibernate

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 …

Read More