Hibernate Exception: Unknown name value for enum class

Question

I'm getting Unknown name value for enum class when trying to retrieve records from DB. Using JSF 2.0, JPA.

The possible values in my DB are 'F' or 'J'

Enum:

public enum TipoPessoa {

    FISICA ("F", "Física"),
    JURIDICA ("J", "Jurídica");

    private final String id;
    private final String descricao;

    private TipoPessoa(String id, String descricao){
        this.id = id;
        this.descricao = descricao;
    }

    public String getId() {
        return id;
    }

    public String getDescricao(){
        return descricao;
    }
}

Entity:

@Column(nullable=false, length=1)
private TipoPessoa tipoPessoa;

public TipoPessoa getTipoPessoa() {
    return tipoPessoa;
}

public void setTipoPessoa(TipoPessoa tipoPessoa) {
    this.tipoPessoa = tipoPessoa;
}

When I try to read the records from DB I got the error

Would you please help me on this issue? thanks

Stack trace:

javax.servlet.ServletException: Unknown name value for enum class br.com.aaa.xxx.entidade.TipoPessoa: F javax.faces.webapp.FacesServlet.service(FacesServlet.java:606) br.com.aaa.filtro.FiltroEncode.doFilter(FiltroEncode.java:26) root cause

javax.ejb.EJBTransactionRolledbackException: Unknown name value for enum class br.com.aaa.xxx.entidade.TipoPessoa: F .... ......

You are doing the mapping wrong. How should Hibernate know how to map the enum type? See e.g. this SO question. — Dominik Sandjaja
– Dominik Sandjaja, Commented Jul 5, 2013 at 17:03

JB Nizet · Accepted Answer · 2013-07-05 17:06:50Z

24

Hibernate doesn't know and care about the id field inside your enum. All it knows about is the ordinal value (0 and 1) and the name (FISICA and JURIDICA). If you want to persist F and J, you'll have to rename your two enum constants to F and J, and annotate the field in the entity like this:

@Column(nullable=false, length=1)
@Enumerated(EnumType.STRING)
private TipoPessoa tipoPessoa;

or use a custom user type to transform F to FISICA or vice-versa.

answered Jul 5, 2013 at 17:06

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

6 Comments

Al2x Over a year ago

Thats great. Worked as expected. But How can I do to let the full names instead F or J ?

JB Nizet Over a year ago

Use a custom user type: docs.jboss.org/hibernate/orm/4.2/manual/en-US/html_single/…

Al2x Over a year ago

RESOLVED* @JB Nizet thank you so much for helping. Im newly in Java and spent some hours trying to fix that. Now its fixed by you :)

Kumaresan Perumal Over a year ago

@JB Nizet when I remove enum string in java. but it is in DB. when I retrieve the records from the DB. It gives a null pointer exception. How to overcome this problem?

JB Nizet Over a year ago

@KumaresanPerumal so you have a value in the database that is supposed to be mapped to an enum, but doesn't have any of the valid enum values? Don't do that. Change the values in the DB to a valid enum value, or leave the enum as it was.

|

Collectives™ on Stack Overflow

Hibernate Exception: Unknown name value for enum class

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related