I'm using HIbernate 3 running against DB2.

I wonder if there is a way to map an enum without creating a user type, for instance, could I use a component mapping?

I have a Java enum defined thus:


I tried the following mapping:



This compiled correctly and generated the following table definition:

create table PSD.NORM_REC (
NORM_REC_ID bigint generated by default as identity,
myCreateDate timestamp,
EVENT_DATE_IS_APPROX smallint,
EVENT_MAX_DATE timestamp,
EVENT_MIN_DATE timestamp,
EVENT_DATE timestamp,
myId integer,
value varchar(255),
mySourceId varchar(255),
primary key (NORM_REC_ID)
);

I'm just not sure if this will correctly store and retrieve the enum value.

TIA.

Larry

I don't know if this will help, but I took a different approach. I mapped the enumerated value to an int, and then created an accessor to make the enum available (I'm obviously using annotations, but it would work with mappings the same way):



Now the accessor translates:



IMO it may be awhile before frameworks start fully integrating Java 5 concepts and types. As another example, I needed to work around the enumerations in betwixt as well.