String Enum on Hibernate

Question

I've got an issue about inserting an enum into a VARCHAR field. That's my enum:

public enum StatusPesquisaEnum {

    ATENDIDO("A"),
    ESPERA("E"),
    EMATENDIMENTO("EA"),
    NAOATENDIDO("NA");


    private StatusPesquisaEnum(String codigo){
        this.codigo = codigo;
    }

    private final String codigo;

    public String getCodigo() {
        return codigo;
    }

}

I want to insert A, E, EA and NA into the database. Furthermore I've tried a converter:

@Converter(autoApply = true)
public class StatusPesquisaEnumConverter 
        implements AttributeConverter<StatusPesquisaEnum, String> {

    @Override
    public String convertToDatabaseColumn(StatusPesquisaEnum status) {
        return status.getCodigo();
    }

    @Override
    public StatusPesquisaEnum convertToEntityAttribute(String codigoStatus) {
        return StatusPesquisaEnum.valueOf(codigoStatus);
    }
}

And it's mapped as:

@Column(name = "str_status")
@Enumerated(EnumType.STRING)
@Convert(converter=StatusPesquisaEnumConverter.class)
private StatusPesquisaEnum statusPesquisa;

But it is inserting ATENDIDO, ESPERA, EMATENDIMENTO and NAOATENDIDO into the database.

Remove the @Enumerated as this conflicts with a custom converter. — Tobias Liefke
– Tobias Liefke, Commented Nov 24, 2015 at 13:45
Thank you, It partially worked! I've made some changes and I'll edit the post it! (y) — José Eduardo Kimura
– José Eduardo Kimura, Commented Nov 24, 2015 at 15:52
Please don't add the solution in the question. Either create a new answer or just leave my comment as answer... — Tobias Liefke
– Tobias Liefke, Commented Nov 24, 2015 at 18:57
This is not one of those forums you find on the net with the silly [SOLVED] text. Instead, if there's an answer that solves your problem, mark is as the answer. — Luiggi Mendoza
– Luiggi Mendoza, Commented Nov 24, 2015 at 20:50

Tobias Liefke · Accepted Answer · 2015-11-24 20:48:08Z

3

Remove the @Enumerated as this conflicts with a custom converter:

@Column(name = "str_status")
@Convert(converter = StatusPesquisaEnumConverter.class)
private StatusPesquisaEnum statusPesquisa;

answered Nov 24, 2015 at 20:48

Tobias Liefke

9,0912 gold badges44 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

String Enum on Hibernate

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related