mysql - 无法找到逻辑名为 : propertymasterfk in org. hibernate.mapping.Table(mastertable) 的列及其相关的超表和辅助表

Question

这是一个使用 hibernate 和 mySql 创建的 spring boot 项目，::设想::在要存储在父表中的公寓详细信息中，子表包含街区、楼层、公寓的起始和结束编号。 Click Here to see form sample

我创建了2个表，这是我需要在给定的父表中建立父表与子表的关系

@OneToMany @JoinColumn(name="propertyid",referencedColumnName="propertymasterfk") private List blockListPropSub;

此栏需要与此栏目建立联系

@Column(name="propertymasterfk") private int propertymasterfk;

这是完整的代码片段父表EntPropertyMaster

@Entity
@Table(name="Property_Master")
public class EntPropertyMaster implements Serializable{

    private static final long serialVersionUID = 6162594257264775391L;
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="propertyid")
    private int property_id;

    @NotNull
    private String property_name;

    @NotNull
    private String address1;

    @NotNull
    @Column(columnDefinition="varchar(15) default'None'")
    private String address2;

    @NotNull
    private String city;

    @NotNull
    private String state;

    @NotNull
    private String country;

    @NotNull
    private int zipcode;

    @OneToMany(cascade=CascadeType.ALL)
    @JoinColumn(name="propertyid",referencedColumnName="propertymasterfk")
    private List<EntPropertySub> blockListPropSub;
}

这是子表EntPropertySub

@Entity
@Table(name="propertysub")
public class EntPropertySub implements Serializable {

    private static final long serialVersionUID = 810618405796553525L;
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="propertysubpk")
    private int propertySub_pk;

    @Column(name="propertymasterfk")
    private int propertymasterfk;

    @NotNull
    private String blockname;

    @NotNull
    private int floors;

    @NotNull
    private String flatstart;

    private String flatend;
}

当我执行时，错误提示无法映射集合com.vfraternity.process.entity.EntPropertyMaster.blockListPropSub

这是完整的错误日志

Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled. 2017-10-20 12:35:43.638 ERROR 17844 --- [ main] o.s.boot.SpringApplication : Application startup failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.AnnotationException: Unable to map collection com.vfraternity.process.entity.EntPropertyMaster.blockListPropSub at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1702) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1083) ~[spring-context-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:858) ~[spring-context-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:122) ~[spring-boot-2.0.0.M4.jar:2.0.0.M4] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.0.0.M4.jar:2.0.0.M4] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:386) [spring-boot-2.0.0.M4.jar:2.0.0.M4] at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) [spring-boot-2.0.0.M4.jar:2.0.0.M4] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1245) [spring-boot-2.0.0.M4.jar:2.0.0.M4] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1233) [spring-boot-2.0.0.M4.jar:2.0.0.M4] at com.vfraternity.VfSpringBootMain.main(VfSpringBootMain.java:12) [classes/:na] Caused by: org.hibernate.AnnotationException: Unable to map collection com.vfraternity.process.entity.EntPropertyMaster.blockListPropSub at org.hibernate.cfg.annotations.CollectionBinder.bindCollectionSecondPass(CollectionBinder.java:1604) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.cfg.annotations.CollectionBinder.bindOneToManySecondPass(CollectionBinder.java:871) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.cfg.annotations.CollectionBinder.bindStarToManySecondPass(CollectionBinder.java:786) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.cfg.annotations.CollectionBinder$1.secondPass(CollectionBinder.java:725) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.cfg.CollectionSecondPass.doSecondPass(CollectionSecondPass.java:54) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1621) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1589) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:278) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:858) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:885) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) ~[spring-orm-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:358) ~[spring-orm-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:384) ~[spring-orm-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:373) ~[spring-orm-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1761) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1698) ~[spring-beans-5.0.0.RC4.jar:5.0.0.RC4] ... 16 common frames omitted Caused by: org.hibernate.cfg.RecoverableException: Unable to find column with logical name: propertymasterfk in org.hibernate.mapping.Table(property_master) and its related supertables and secondary tables at org.hibernate.cfg.Ejb3JoinColumn.checkReferencedColumnsType(Ejb3JoinColumn.java:831) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.cfg.BinderHelper.createSyntheticPropertyReference(BinderHelper.java:243) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] at org.hibernate.cfg.annotations.CollectionBinder.bindCollectionSecondPass(CollectionBinder.java:1594) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] ... 31 common frames omitted Caused by: org.hibernate.MappingException: Unable to find column with logical name: propertymasterfk in org.hibernate.mapping.Table(property_master) and its related supertables and secondary tables at org.hibernate.cfg.Ejb3JoinColumn.checkReferencedColumnsType(Ejb3JoinColumn.java:826) ~[hibernate-core-5.2.10.Final.jar:5.2.10.Final] ... 33 common frames omitted

请任何人帮忙解决这个问题..

Answer 1

此更改将会起作用...对于父表

@OneToMany(cascade=CascadeType.ALL)
    @JoinTable(name="propertysub",joinColumns=@JoinColumn(name="propertyid"),
    inverseJoinColumns=@JoinColumn(name="propertysubpk"))
    private List<EntPropertySub> blockListPropSub = new ArrayList<EntPropertySub>();

对于子表

@ManyToOne(cascade=CascadeType.ALL)     
private EntPropertyMaster propertymasterfk = new EntPropertyMaster();