hibernate 外键引用的列数错误,应为2

wsewodh2  于 2022-11-30  发布在  其他
关注(0)|答案(1)|浏览(130)

这是我的代码
虚拟人

public class VirsualPerson extends Person{

@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@PrimaryKeyJoinColumn(name="VIRSUALPERSON_ID")
private long virsualPersonId;

@ManyToMany(fetch=FetchType.LAZY,cascade=CascadeType.ALL)
@JoinTable(name="Anime_character",catalog="anime",joinColumns={
        @JoinColumn(name="VIRSUALPERSON_ID",nullable=false)},inverseJoinColumns={@JoinColumn(name="ANIME_ID",nullable=false)})
private Set<Anime>animeCharacters=new HashSet<Anime>();

@OneToMany(fetch=FetchType.LAZY,mappedBy="charecter")
private Set<VirsualPeopleComment>comments=new HashSet<VirsualPeopleComment>();

public long getVirsualPersonId() {
    return virsualPersonId;
}
public void setVirsualPersonId(long virsualPersonId) {
    this.virsualPersonId = virsualPersonId;
}
public Set<Anime> getAnimeCharacters() {
    return animeCharacters;
}
public void setAnimeCharacters(Set<Anime> animeCharacters) {
    this.animeCharacters = animeCharacters;
}
public Set<VirsualPeopleComment> getComments() {
    return comments;
}
public void setComments(Set<VirsualPeopleComment> comments) {
    this.comments = comments;
}

}
虚拟人Comment

@Entity
@Table(name="people_comment")
public class VirsualPeopleComment {
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="peopleCommentId")
private long commentId;

@Column(name="content")
private String commentContent;

@Temporal(TemporalType.TIMESTAMP)
@Column(name="POST_TIME")
private Date postTime;

@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="USER_ID")
private User commentUser;

@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="VIRSUALPERSON_ID")
private VirsualPerson charecter;

public long getCommentId() {
    return commentId;
}
public void setCommentId(long commentId) {
    this.commentId = commentId;
}
public String getCommentContent() {
    return commentContent;
}
public void setCommentContent(String commentContent) {
    this.commentContent = commentContent;
}

public Date getPostTime() {
    return postTime;
}
public void setPostTime(Date postTime) {
    this.postTime = postTime;
}

public User getCommentUser() {
    return commentUser;
}
public void setCommentUser(User commentUser) {
    this.commentUser = commentUser;
}
public VirsualPerson getCharecter() {
    return charecter;
}
public void setCharecter(VirsualPerson charecter) {
    this.charecter = charecter;
}

}
这就是错误

从VirsualPeopleComment引用VirsualPerson的外键的列数错误。应该是2我想知道我的注解有什么问题,非常感谢

laik7k3q

laik7k3q1#

我想您还应该在这里指定@JoinColumn:

@OneToMany(fetch=FetchType.LAZY,mappedBy="charecter")
private Set<VirsualPeopleComment>comments=new HashSet<VirsualPeopleComment>();

看起来应该是

@OneToMany(fetch=FetchType.LAZY,mappedBy="charecter")
@JoinColumn(name="peopleCommentId")
private Set<VirsualPeopleComment>comments=new HashSet<VirsualPeopleComment>();

相关问题