Spring Boot JPA @JoinColumns找不到具有逻辑名称的列

jljoyd4f  于 2023-03-02  发布在  Spring
关注(0)|答案(1)|浏览(82)

我有一个Sping Boot 项目。只有3个类(实体),当我尝试运行该项目时,我得到错误“导致:org.hibernate.MappingException:找不到逻辑名称为““的列
这些类包括:

@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

我尝试在引用的列名中添加反勾号(),还尝试在www.example.com中放置属性spring.jpa.properties. hib. globally_quoted_identifiers=trueapplication.properties,但仍然得到相同的错误

qaxu7uf2

qaxu7uf21#

我知道怎么让它工作了。

@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)
    @JoinColumn(name="ID_HOL_JURI", referencedColumnName = "ID_HOL_JURI")
    private HoldingJurisdiccion holdingJurisdiccion;    

    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="ID_HOL")
    private Holding holding;

}

相关问题