MySQL enum with hibernate

Question

I have a database table using an enum. This is already working with hibernate (using XML), and I'm trying to convert it to annotations as this is one of the last pieces to still be using xml notation.

The column definition:

enum('Active','Pending','Cancelled','Suspend')

The following works:

<property
    name="status"
    column="STATUS"
    type="string"
    not-null="true" />

This does not work:

@Column(name = "status")
public String status;

The annotation-style leads to the following exception upon startup: org.hibernate.HibernateException: Wrong column type in UserDTO for column status. Found: enum, expected: varchar(255)

Is there any way for me to force this to accept a String as it did using the XML notation?

Jesse · Accepted Answer · 2009-07-02 20:58:45Z

20

I figured it out. It should be:

@Column(name="status", columnDefinition="enum('Active','Pending','Cancelled','Suspend')")
public String status;

answered Jul 2, 2009 at 20:58

Jesse

1,4951 gold badge12 silver badges21 bronze badges

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

2 Comments

kornicameister Over a year ago

your solution is correct at least for MySQL database, but fails for H2 databases used in tests for instance (case for automatic schema creation). It seems that is nor 100% portable, as far as I remember there are problems on PostgresSQL as well (at least if we expect that schema'd auto generated).

asgs Over a year ago

It works for me, too. I had an additional annotation @Enumerated(EnumType.STRING) but it resulted in an error was annotated as enumerated, but its java type is not an enum [java.lang.String]

Collectives™ on Stack Overflow

MySQL enum with hibernate

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related