SQL insert with enums?

Question

how can I insert SQL value for eg:

class MyEnum {
    FOO, BAR
}

which is later mapped to a MyEnum property = MyEnum.FOO;

How can I INSERT into XX (property) values ('FOO')?

When I try it like this, I get:

Data conversion error converting "'FOO' (MYENUM INTEGER)";

http://stackoverflow.com/questions/2160700/enum-in-hibernate-persisting-as-an-enum does this help? — user219882, Apr 08 '12 at 19:21

score 1 · Accepted Answer · answered Apr 08 '12 at 19:36

1

you have to map java enum to hibernate. this and this might help.

answered Apr 08 '12 at 19:36

Alex Navasardyan

score 0 · Answer 2 · answered Apr 08 '12 at 19:24

0

you got to convert your enum into a hibernate user type and change the mapping of the column to the UserType class. take a look at this Reference

answered Apr 08 '12 at 19:24

Nitin Chhajer

2 Answers2