MySQL ENUM与AttributeConverter在InheritanceType.JOINED中的映射IllegalArgumentExceptionon Hibernate 5.3.6 (JPA 2.1+)：无枚举常数

Question

我正在映射继承层次结构，如下所示：

​

​

这里的问题是，DB包含用于个人、俱乐部和竞技场的单字符ENUM值“P”、“C”和“A”，但是要使用的Java枚举值应该是PERSON、CLUB和ARENA。

这需要使用一个AttributeConverter来执行DB值- Java转换(请参见下面的映射)：

联络实体：

@Entity
@Table(name="Contacts")
@Inheritance(strategy=InheritanceType.JOINED)
public abstract class Contact extends BaseIdEntity
{
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column
    protected Integer id;

    @Convert(converter=ContactTypeConverter.class)  // <-- !!! ... see below
    @Enumerated(EnumType.STRING)
    @Basic(optional=false)
    @Column
    protected ContactType type;  // actually a discriminator, but for JOINED inheritance, it is not required to annotate the class with @DiscriminatorColumn

    ...
}

ContactType ENUM：

public enum ContactType
{
    PERSON,  <-- fully written, but data is single-char
    CLUB,
    ARENA;
}

个人实体：

@Entity
@Table(name="Persons")
public class Person extends Contact
{
    private static final long serialVersionUID = 1L;

    @Basic(optional=false)
    @Column(name="first_name")
    private String firstName;

    @Basic(optional=false)
    @Column(name="last_name")
    private String lastName;

    ...
}

俱乐部实体：

@Entity
@Table(name="Clubs")
public class Club extends Contact
{
    private static final long serialVersionUID = 1L;

    @Basic(optional=false)
    @Column
    private String name;

    @Basic(optional=false)
    @Column
    private String code;

    @Basic
    @Column(name="website_url")
    private String websiteUrl;

    ...
}

竞技场实体：

@Entity
@Table(name="Arenas")
public class Arena extends Contact
{
    private static final long serialVersionUID = 1L;

    @Basic(optional=false)
    @Column
    private String name;

    @Basic
    @Column
    private Integer capacity;

    ...
}

ContactType属性转换器

@Converter( autoApply = false )
public class ContactTypeConverter implements AttributeConverter<ContactType, String>
{
    @Override
    public String convertToDatabaseColumn( ContactType contactType )
    {
        System.out.println( "convertToEntityAttribute(" + contactType + ")" );

        switch ( contactType )
        {
            case PERSON:
                return "P";

            case CLUB:
                return "C";

            case ARENA:
                return "A";

            default:
                throw new IllegalArgumentException( "Unknown enum value: " + contactType );
        }
    }

    @Override
    public ContactType convertToEntityAttribute( String value )
    {
        System.out.println( "convertToEntityAttribute(\"" + value + "\")" );

        switch ( value )
        {
            case "P":
                return PERSON;

            case "C":
                return CLUB;

            case "A":
                return ARENA;

            default:
                throw new IllegalArgumentException( "Unknown DB value: " + value );
        }
    }
}

以下是MySQL的DDL +数据：

CREATE TABLE `Contacts`(
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `type` ENUM('P', 'C', 'A') NOT NULL,
  PRIMARY KEY (`id`));

CREATE TABLE `Arenas` (
  `id` INT(11) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `capacity` INT(11) NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `arenas_contacts_fk`
    FOREIGN KEY (`id`)
    REFERENCES `Contacts` (`id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE);

CREATE TABLE `Clubs` (
  `id` INT(11) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `code` VARCHAR(5) NOT NULL,
  `website_url` VARCHAR(64) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `clubs_contacts_fk`
    FOREIGN KEY (`id`)
    REFERENCES `Contacts` (`id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE);

CREATE TABLE `Persons` (
  `id` INT(11) NOT NULL,
  `first_name` VARCHAR(50) NOT NULL,
  `last_name` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `persons_contacts_fk`
    FOREIGN KEY (`id`)
    REFERENCES `Contacts` (`id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE);

数据：

INSERT INTO `Contacts` (`id`, `type`) VALUES
(  1, 'P'),
(  2, 'P'),
(  3, 'P'),
( 26, 'P'),
( 99, 'P'),
(101, 'C'),
(102, 'C'),
(103, 'C'),
(201, 'A'),
(202, 'A'),
(203, 'A');

INSERT INTO `Persons` (`id`, `first_name`, `last_name`) VALUES
(  1, 'Kay', 'Wundrak'),
(  2, 'Joe', 'Locke'),
(  3, 'Ahmed', 'Thiab'),
( 26, 'Seb', 'Gottwalk'),
( 99, 'Test', 'Test');

INSERT IGNORE INTO `Clubs` (`id`, `name`, `code`) VALUES
(101, 'TV Dieburg', 'DIEB'),
(102, 'SC Rist Wedel', 'RIST'),
(103, 'BBG Herford', 'HERF');

INSERT IGNORE INTO `Arenas` (`id`, `name`, `capacity`) VALUES
(201, 'Schlossgartenhalle', NULL),
(202, 'Steinberghalle', NULL),
(203, 'Halle am Gymnasium', NULL);

我咨询过许多消息来源。

https://www.nurkiewicz.com/2013/06/mapping-enums-done-right-with-convert.html MAIN

https://thoughts-on-java.org/jpa-21-type-converter-better-way-to/

https://thoughts-on-java.org/jpa-21-how-to-implement-type-converter/

https://www.baeldung.com/jpa-persisting-enums-in-jpa

http://eloquentdeveloper.com/2016/07/18/persisting-enums-using-jpa-attribute-converter/

所有人都这么说，但不起作用。当我加载一份名单时，我会看到：

Caused by: java.lang.IllegalArgumentException: No enum constant net.bbstats.entity.ContactType.P
    at java.lang.Enum.valueOf(Enum.java:238)
    at org.hibernate.type.descriptor.java.EnumJavaTypeDescriptor.fromName(EnumJavaTypeDescriptor.java:84)
    at org.hibernate.metamodel.model.convert.internal.NamedEnumValueConverter.toDomainValue(NamedEnumValueConverter.java:39)
    at org.hibernate.metamodel.model.convert.internal.NamedEnumValueConverter.readValue(NamedEnumValueConverter.java:69)
    at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:250)
    at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:119)
    at org.hibernate.type.AbstractType.hydrate(AbstractType.java:91)
    at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:3007)
    at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1746)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1672)
    at org.hibernate.loader.Loader.getRow(Loader.java:1561)
    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:731)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:990)
    at org.hibernate.loader.Loader.doQuery(Loader.java:948)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)
    at org.hibernate.loader.Loader.doList(Loader.java:2689)
    at org.hibernate.loader.Loader.doList(Loader.java:2672)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)
    at org.hibernate.loader.Loader.list(Loader.java:2501)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)
    at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)
    at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)
    at org.hibernate.query.Query.getResultList(Query.java:135)
    at net.bbstats.framework.service.Repository.findByNamedQuery(Repository.java:184)
    at net.bbstats.framework.service.BaseEntityService.findByNamedQuery(BaseEntityService.java:382)
    at net.bbstats.framework.service.BaseEntityService.findByNamedQuery(BaseEntityService.java:368)
    at net.bbstats.framework.service.BaseEntityService.findByNamedQuery(BaseEntityService.java:344)
    at net.bbstats.framework.service.BaseEntityService.findAllByQueryWithFetchGraph(BaseEntityService.java:300)
    ... 179 more

看一看线：

java.lang.IllegalArgumentException: No enum constant net.bbstats.entity.ContactType.P

完全不正确或者根本不.？

问题：

这里怎么了？我几乎百分之百肯定，映射是正确的.

-> 是Hibernate bug吗？是因为继承映射吗？也许不和InheritanceType.JOINED一起工作

在任何情况下，一个观察都是，不管发生什么，属性转换器是--从不调用，也就是说，在ContactTypeConverter中从来没有到达断点，也没有任何sysout被打印到控制台/日志中。

安装程序: WildFly 14.0.1，结束，Hibernate 5.3.6

Answer 1

根据这的说法。

JPA显式禁止使用属性标记为AttributeConverter的@Enumerated。因此，在使用AttributeConverter方法时，请确保不要将属性标记为@Enumerated。