休眠@MapKeyColumn和表继承导致未知列类型异常
我正在从休眠4.2.5.Final升级到4.3.6.Final,4.3.6休眠库导致mysql未知列类型异常。以下类已得到简化,因为我无法完整地显示我的公司生产代码。
@Entity
@Table(name = "area")
public class Area {
private Integer id;
private Map<BasicType, BasicConfiguration> configurationsMap =
new HashMap<BasicType, BasicConfiguration>();
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@OneToMany(fetch = FetchType.EAGER, cascade = {CascadeType.ALL}, orphanRemoval = true)
@JoinTable(name = "area_configuration", joinColumns = {@JoinColumn(name = "area_id")},
inverseJoinColumns = {@JoinColumn(name = "basic_configuration_id")})
@MapKeyEnumerated(EnumType.STRING)
@MapKeyColumn(name = "type")
public Map<BasicType, BasicConfiguration> getConfigurationsMap () {
return configurationsMap;
}
其中 BasicType 只是一个枚举
public enum BasicType {
TYPE1, TYPE2, TYPE3, TYPE4, TYPE5;
}
基本配置是:
@Entity
@Table(name = "basic_configuration")
@Inheritance(strategy = InheritanceType.JOINED)
@DiscriminatorColumn(name = "type", discriminatorType = DiscriminatorType.STRING)
public abstract class BasicConfiguration {
private Integer id;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
}
我有一个测试,试图将区域对象持久化到mysql db中,这会产生以下错误:
**Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'type' in 'field list'**
at sun.reflect.GeneratedConstructorAccessor73.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jd
生成的休眠代码显示它正在尝试将类型值插入到basic_configuration表中,而不是area_configuration表中:
**Hibernate: insert into basic_configuration (entity_version, type) values (?, TYPE1)**
Tests run: 9, Failures: 0, Errors: 9, Skipped: 0, Time elapsed: 0.208 sec <<< FAILURE! -
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
at sun.reflect.Ge
此错误似乎是在休眠版本4.2.9.Final中引入的,低于4.2.9.Final的版本似乎没有这个问题,谁知道我该如何解决这个问题?非常感谢。