Hibernate联接表“无效列名”[重复]

Question

我有两张桌子。CategoryMaster和PotentialProject

PotentialProject [potentialProjectID, typeOfProject]

CategoryMaster  [CategoryID, CategoryName]

我想加入typeOfProject和CategoryID。

@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

看来这是对的

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

但这是不正确的

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

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

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