Hibernate连接表"无效列名"[重复]

Question

我有两张桌子。CategoryMaster和PotentialProject

PotentialProject [potentialProjectID, typeOfProject]

CategoryMaster  [CategoryID, CategoryName]

我想加入项目类型和类别ID。

@Entity
@Table(name="CategoryMaster")
public class CategoryMaster
{
    @Id
    @Column(name="CategoryID")
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Integer CategoryID;
    private String CategoryName;

    @OneToOne
    @JoinColumn(name="typeOfProject")
    private PotentialProject potentialProject;

    //getter 
    //setter
}

@Entity
@Table(name="PotentialProject")
public class PotentialProject
{
    @Id
    @Column(name="PotentialProjectID")
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Integer potentialProjectID;
    private int typeOfProject;

    @OneToOne(mappedBy="potentialProject")
    private CategoryMaster categoryMaster;

    //getter 
    //setter
}

Hibernate中的错误消息是无效的列名typeOfProject。请给我一些建议。谢谢你。

Answer 1

谢谢你兄弟@RC

@OneToOne
@PrimaryKeyJoinColumn  
private CategoryMaster categoryMaster;

在CategoryMaster中无需执行任何操作。

谢谢兄弟们。

Answer 2

看来这是正确的

@OneToOne(mappedBy="potentialProject")
private CategoryMaster categoryMaster;

但这是不正确的

@OneToOne
@JoinColumn(name="typeOfProject")
private PotentialProject potentialProject;

name是外键列的名称！所以你的代码应该是这样的

@OneToOne
@JoinColumn(name="fk_potential_project")
private PotentialProject potentialProject;