Hibernate unable to save entity with one of the fields as enum

Question

Here is the exception - pastebin

Caused by: java.sql.SQLException: Unknown Parameter: 13
    at com.google.cloud.sql.jdbc.ParameterMetadata.getParameterType(ParameterMetadata.java:45)
    at org.hibernate.type.EnumType.nullSafeSet(EnumType.java:121)
    at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:155)
    at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2705)
    at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2682)
    at org.hibernate.persister.entity.AbstractEntityPersister$4.bindValues(AbstractEntityPersister.java:2863)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
    ... 111 more

Enum's in my hibernate mapping -

<property name="userStatus" column="user_status" insert="true" update="true" index="true">
  <type name="org.hibernate.type.EnumType">
    <param name="enumClass">com.tutorial.enums.UserStatus</param>
    <param name="type">12</param>
  </type>
</property>
<property name="userType" column="user_type" insert="true" update="true" index="true">
  <type name="org.hibernate.type.EnumType">
    <param name="enumClass">com.tutorial.enums.UserType</param>
    <param name="type">12</param>
  </type>
</property>

My entity has UserType and UserStatus as enums. Hibernate is not able to convert enums properly. Should I switch back to hibernate 3 because in another project(with hibernate 3)I had my own custom type and it was working perfectly fine. I'm right now using hibernate 4.1.7.

Marek · Accepted Answer · 2013-01-02 17:16:00Z

2

Add

<param name="useNamed"></param>

and it should work fine.

<property name="userType" column="user_type" insert="true" update="true" index="true">
   <type name="org.hibernate.type.EnumType">
     <param name="enumClass">com.tutorial.enums.UserType</param>
     <param name="type">12</param>
     <param name="useNamed"></param>
   </type>
</property>

EDIT:

<param name="useNamed"></param>

must be there, but if you leave it blank then Enums will be serialized as Ordinals which is not very helpful if you do manual work on database, so if you want to get names then it must be

 <param name="useNamed">true</param>

edited Jan 2, 2013 at 17:16

answered Nov 5, 2012 at 22:33

Marek

1,87814 silver badges20 bronze badges

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

3 Comments

Marek Over a year ago

Now I see that you asked that same question earlier and I already answered there but I already answer here as well so let's leave it be...

Shwetanka Over a year ago

I'm not getting any error now but none of the enum values are getting populated in the mysql table.

Shwetanka Over a year ago

And when I set it's value to true it gives me 'data truncated for column' error. While my table definition is absolutely correct. I guess this version of hibernate is very buggy and am trying out ebean.

Collectives™ on Stack Overflow

Hibernate unable to save entity with one of the fields as enum

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related