Hi!

I'm trying to create persistence objects using the new javax.persistence API (JSR 220) and Hibernate (3.2 RC1, EntityManager 3.1 Beta8).

The problem is that I'm trying to map an entity to an existing DB2 table. Unfortunately, the table has a lot of 'Y'/'N' columns that where used for booleans. Ugly.

I tried to build a clean API around this and wanted to use an enum for this. Is there a possibility to map a column value of 'N' to an enum value named MyEnum#NO and 'Y' to YES?

I tried it and currently Hibernate throws an exception because it can't reslove the 'N' to NO.

Thanks,
KM

There are several ways to do this. My favourite is to tweak StringValuedEnumType. Have a read of http://www.hibernate.org/273.html.

Thanks. But is there a way to do it in a JSR220 way, i.e. without using Hibernate classes in my code?

This doesn't invlolve using hibernate classes in your code. It involves writing code that you put into hibernate. Or rather, that you tell hibernate about. You never use the class that you write, all it does is tell hibernate how to handle your enums. The only reference to the class is in your mapping file.