Mapping Java enum on Postgres enum with EclipseLink

Question

I am making first attempts with JPA (EclipseLink implementation) and feel quite stuck: In PostgreSQL I have the following db schema ``` CREATE TYPE mood AS ENUM ( 'sad', 'happy', 'enthusiastic' ); CREATE TABLE person ( pk BIGINT PRIMARY KEY, name VARCHAR NOT NULL, mood mood NOT NULL ); CREATE SEQUENCE person_pk_seq INCREMENT BY 100 MINVALUE 100; ``` Which works pretty fine, as this insert shows `INSERT INTO PERSON (PK, mood, name) VALUES (3, 'happy', 'Joe')` (Committing the pk as String makes no difference.) On the JPA side I wrote the following class: ``` package testdb; import java.io.Serializable; import javax.persistence.*; import org.eclipse.persistence.annotations.*; @Entity public class Person implements Serializable { private static final long serialVersionUID = 1L; public enum Mood { sad, happy, enthusiastic; } @Id @SequenceGenerator( name="PERSON_PK_GENERATOR", sequenceName="PERSON_PK_SEQ", allocationSize = 100 ) @GeneratedValue( strategy=GenerationType.SEQUENCE, generator="…

Accepted Answer

Why do you use a `@ObjectTypeConverter`, you can map Enumerations out of the box with eclipse link as shown here. `@Enumerated` is part of JSR-220 whereas `@ObjectTypeConverter` is a proprietary extension from EclipseLink JPA Extensions.

```
@Enumerated(EnumType.STRING)
@Column(name = "mood")
private Mood mood;
```

Mapping Java enum on Postgres enum with EclipseLink

Solution

Problem

Related problems