You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Spring Boot项目JPA @JoinColumns映射异常：无法找到逻辑列ID_HOL

avatar
云上老周
2026-7-30
Hibernate映射异常：无法在hol_juri中找到逻辑名称为ID_HOL的列

问题场景

我有一个仅包含3个实体类的Spring Boot项目，运行时抛出以下异常：

org.hibernate.MappingException: Unable to find column with logical name: ID_HOL in hol_juri

实体类代码 

@Data
@Entity
@Table(name="HOL")
public class Holding  implements Serializable{

    private static final long serialVersionUID = 1110819289093936782L;

    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="ID_HOL")
    private Long idHolding;

    @Column(name="NOMBRE_HOLDING", unique = true, nullable = false, length = 50)
    private String nombre;
}

@Data
@Entity
@Table(name="HOL_JURI", uniqueConstraints = {@UniqueConstraint(columnNames = { "ID_HOL_JURI", "ID_HOL"})})
public class HoldingJurisdiccion implements Serializable{

    private static final long serialVersionUID = 3441056203408582532L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="ID_HOL_JURI")
    private Long idHoldingJurisdiccion;
    
    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="ID_HOL")
    private Holding holding;
    
    @Column(name="NOMBRE", nullable = false, length = 50)
    private String nombreHoldingJuridiccion;
}

@Data
@Entity
@Table(name="ENTIDAD")
public class Entidad  implements Serializable{

    private static final long serialVersionUID = -1038561346897695629L;

    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="ID_ENTIDAD")
    private Long idEntidad;

    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumns({
        @JoinColumn(name="ID_HOL_JURI", referencedColumnName = "ID_HOL_JURI"),
        @JoinColumn(name="ID_HOL", referencedColumnName="ID_HOL")
    })
    private HoldingJurisdiccion holdingJurisdiccion;
}

完整异常栈 

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.MappingException: Unable to find column with logical name: ID_HOL in hol_juri
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) ~[spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:734) ~[spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408) ~[spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) ~[spring-boot-2.7.5.jar:2.7.5]
    at com.example.springBootTest.SpringBootTestApplication.main(SpringBootTestApplication.java:10) ~[classes/:na]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
    at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
    at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.7.5.jar:2.7.5]
Caused by: org.hibernate.MappingException: Unable to find column with logical name: ID_HOL in hol_juri
    at org.hibernate.cfg.Ejb3JoinColumn.checkReferencedColumnsType(Ejb3JoinColumn.java:865) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.cfg.BinderHelper.createSyntheticPropertyReference(BinderHelper.java:126) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.cfg.ToOneFkSecondPass.doSecondPass(ToOneFkSecondPass.java:104) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processEndOfQueue(InFlightMetadataCollectorImpl.java:1750) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processFkSecondPassesInOrder(InFlightMetadataCollectorImpl.java:1694) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1623) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:295) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1460) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1494) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.3.23.jar:5.3.23]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.3.23.jar:5.3.23]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-5.3.23.jar:5.3.23]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) ~[spring-orm-5.3.23.jar:5.3.23]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.23.jar:5.3.23]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.23.jar:5.3.23]
    ... 21 common frames omitted

已尝试的解决方法

  • 为关联列名添加反引号
  • 在application.properties中设置spring.jpa.properties.hibernate.globally_quoted_identifiers=true

以上方法均未解决异常。

问题原因及解决方案

问题根源

Entidad类中使用@JoinColumns联合关联HoldingJurisdiccion时，referencedColumnName="ID_HOL"是错误的：HoldingJurisdiccion的实体主键只有ID_HOL_JURI，ID_HOL是该实体关联Holding的外键列，但并未作为HoldingJurisdiccion自身的映射字段存在，因此Hibernate无法在HoldingJurisdiccion的逻辑列中找到ID_HOL。

方案一：仅关联HoldingJurisdiccion的主键

如果Entidad只需要关联HoldingJurisdiccion，无需额外关联Holding，直接修改Entidad中的关联代码：

@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="ID_HOL_JURI", referencedColumnName = "ID_HOL_JURI")
private HoldingJurisdiccion holdingJurisdiccion;

这样仅通过HoldingJurisdiccion的主键建立关联，后续可通过holdingJurisdiccion.getHolding()获取关联的Holding数据。

方案二：将HoldingJurisdiccion设置为复合主键

如果数据库表ENTIDAD确实需要同时通过ID_HOL_JURI和ID_HOL关联HoldingJurisdiccion，需要将HoldingJurisdiccion定义为复合主键实体：

  1. 创建复合主键类：
@Embeddable
public class HoldingJurisdiccionId implements Serializable {
    private static final long serialVersionUID = 1L;

    @Column(name="ID_HOL_JURI")
    private Long idHoldingJurisdiccion;
    
    @Column(name="ID_HOL")
    private Long idHolding;

    // 必须实现equals和hashCode方法
    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        HoldingJurisdiccionId that = (HoldingJurisdiccionId) o;
        return Objects.equals(idHoldingJurisdiccion, that.idHoldingJurisdiccion) &&
                Objects.equals(idHolding, that.idHolding);
    }

    @Override
    public int hashCode() {
        return Objects.hash(idHoldingJurisdiccion, idHolding);
    }

    // getter和setter方法
    public Long getIdHoldingJurisdiccion() {
        return idHoldingJurisdiccion;
    }

    public void setIdHoldingJurisdiccion(Long idHoldingJurisdiccion) {
        this.idHoldingJurisdiccion = idHoldingJurisdiccion;
    }

    public Long getIdHolding() {
        return idHolding;
    }

    public void setIdHolding(Long idHolding) {
        this.idHolding = idHolding;
    }
}
  1. 修改HoldingJurisdiccion实体：
@Data
@Entity
@Table(name="HOL_JURI", uniqueConstraints = {@UniqueConstraint(columnNames = { "ID_HOL_JURI", "ID_HOL"})})
public class HoldingJurisdiccion implements Serializable{

    private static final long serialVersionUID = 3441056203408582532L;

    @EmbeddedId
    private HoldingJurisdiccionId id;
    
    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="ID_HOL", insertable = false, updatable = false)
    private Holding holding;
    
    @Column(name="NOMBRE", nullable = false, length = 50)
    private String nombreHoldingJuridiccion;
}
  1. 保持Entidad中的联合关联代码不变即可，此时Hibernate能正确识别复合主键中的ID_HOL列。

内容的提问来源于stack exchange，提问作者Miguel Arias

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分)， 限时 9.9 元起

产品介绍相关文档
相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分)， 限时 9.9 元起

产品介绍相关文档
火山引擎 最新活动
全面开放
Doubao-Seedance-2.5全新模型升级

模型再升级,30秒超长叙事, 模态参考扩容

HOT
方舟Codingplan

模型自由，工具不限，最新支持 Deepseek-V4 系列、GLM-5.3 系列

HOT
方舟Agent plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列

HOT
新用户特惠专场

大模型19元起，Al应用9.9元畅享，新人首购爆款尽享优惠

最近更新时间：2026.07.30 09:07:36