Till now I used Enums in domain objects with no problem,
Just add the Hibernate annotation:
@Enumerated(EnumType.STRING)

And the domain field saved to the db as selected by the EnumType

Now I am working on different application and trying to use enum in one of my domain object fields

For example:
My domain class is :




The application uses “hbm” files and I am trying to set the hbm to work with the Enum field (NoteType) so I configured set the hbm like:





But it wont work, the application keep throwing these exceptions:
“Arithmetic overflow error converting varbinary to data type numeric”

After half day goggling on this matter I found another suggestion :
http://forum.hibernate.org/viewtopic.php?p=2377095



this code throws this Exception:
MappingException: "Could not determine type for": org.hibernate.type.EnumType

I published the question in other ORM forum but didn't get an answer..
Hope you guys can help

Sharon

I ran into this, too. The class you're using, org.hibernate.type.EnumType, is not part of the Hibernate Core jar, it's in one of the jars for Hibernate Annotations. So even if you're not using annotations, include the annotation jar files in your classpath, and the XML mapping you have should work.

Hi
I added the Hibernate-annotation.jar, indeed the "MappingException" gone
But it still won't accept the hbm settings:




I get ERROR org.hibernate.util.JDBCExceptionReporter - Invalid column name 'myfield'.

If i add getter and setter to access "myfield" that return Integer (its ordinal),Everything is working fine.

Please advice
Thank you
Sharon

Going back to your original post, use this:



Your field "type" should be of the enum type, not an Integer.

Two things I should also mention: I use access="field", but I think this will work fine with access="property" as well. Make sure the setter and getter use the enum type, not Integer.

Also, this stores the enum in the database as a String, and the length= attribute specifies how long the string needs to be to hold the longest string representation of the enum. I don't know how to store the enum as an ordinal Integer. Maybe that's controlled by the line above, and a number other than 12 would mean "integer". But that's just a guess. In my project, I wanted to store Strings, not numbers.

Good luck!

Sorry for nudging..
I changed the mapping and added the access="field, and also tried access="property"

Also, currently as long as its working... I dont care if its saving string or int ordinal to the database.

My problem is that this Enum Mapping not working,
I keep getting Exception :



I added the Hibernate-annotation.jar to the classpath
change the configuration in the HBM file as following:




I have getter and setter for the Enum in the domain Obj as flow :




Please help
Sharon

The only thing I see wrong is that the name of the enum class in the XML file doesn't match the full name of your enum type. You have in your entity class, and in the XML file.

Except for that, it looks like you are doing exactly what I am doing. I'm using Hibernate 3.2.6.GA and Hibernate Annotations 3.3.1.GA. If your versions are different, maybe the problem lies there. I'm new to Hibernate myself, this is my first project. Good luck!

HI grimarr
this is Just a Typo while copying..
the actual xml is Ok

I will be glad to take a peek of your mapping file & Domain Obj

Thank you

Sharon

Check your getter and setter: the field name is myfield and your getter and setter are getMyfieldEnum, setMyfieldEnum