自动生成实体类的Netbeans@JoinColoumns错误

Question

我已经使用Netbeans 7.4从数据源创建了实体。

我有一个错误，它发生在所有具有复合主键的实体上。错误如下所示。

我已经在堆栈溢出上搜索了这个问题，这通常是因为人们没有定义连接列。但我已经这样做了。我也不确定netbean生成的代码中如何存在错误。

这是我的MySQL数据库的一个图像，我将其向前设计以创建这些实体：

任何帮助都将不胜感激！

这是唯一相关的代码

缺勤实体：

public class Absence implements Serializable {
    private static final long serialVersionUID = 1L;
    @EmbeddedId
    protected AbsencePK absencePK;
    @Basic(optional = false)
    @NotNull
    @Column(name = "idAbsence")
    private int idAbsence;
    @Basic(optional = false)
    @NotNull
    @Column(name = "Date")
    @Temporal(TemporalType.DATE)
    private Date date;
    @Size(max = 35)
    @Column(name = "type")
    private String type;
    @Lob
    @Size(max = 65535)
    @Column(name = "remark")
    private String remark;
    @JoinColumn(name = "TimeTable_Period", referencedColumnName = "Period", insertable = false, updatable = false)
    @ManyToOne(optional = false)
    private Timetable timetable;
    @JoinColumn(name = "Student_idStudent", referencedColumnName = "idStudent", insertable = false, updatable = false)
    @ManyToOne(optional = false)
    private Student student;
    @JoinColumn(name = "Class_idClass", referencedColumnName = "idClass", insertable = false, updatable = false)
    @ManyToOne(optional = false)
    private Class class1; 

缺勤PK实体：

@Embeddable
public class AbsencePK implements Serializable {
    @Basic(optional = false)
    @NotNull
    @Column(name = "Class_idClass")
    private int classidClass;
    @Basic(optional = false)
    @NotNull
    @Column(name = "Student_idStudent")
    private int studentidStudent;
    @Basic(optional = false)
    @NotNull
    @Column(name = "TimeTable_Period")
    private int timeTablePeriod;

    public AbsencePK() {
    }

    public AbsencePK(int classidClass, int studentidStudent, int timeTablePeriod) {
        this.classidClass = classidClass;
        this.studentidStudent = studentidStudent;
        this.timeTablePeriod = timeTablePeriod;
    }

错误：

原因：异常[EclipseLink-7220]（Eclipse持久性服务-2.5.0.v20130507-3faac2b）：org。日食坚持不懈例外情况。ValidationException异常描述：实体类[class com.fyp.simstest.Existence]中带注释元素[字段时间表]上的@JoinColumns不完整。当源实体类使用复合主键时，必须使用@JoinColumns为每个连接列指定@JoinColumn。必须在每个这样的@JoinColumn中指定name和referencedColumnName元素。位于组织。日食坚持不懈例外情况。ValidationException。未指定完整的JoinColumns（ValidationException.java:1847）

编辑

时刻表

@Entity
@Table(name = "timetable")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "Timetable.findAll", query = "SELECT t FROM Timetable t"),
    @NamedQuery(name = "Timetable.findByPeriod", query = "SELECT t FROM Timetable t WHERE t.timetablePK.period = :period"),
    @NamedQuery(name = "Timetable.findByDay", query = "SELECT t FROM Timetable t WHERE t.timetablePK.day = :day"),
    @NamedQuery(name = "Timetable.findByClassidClass", query = "SELECT t FROM Timetable t WHERE t.timetablePK.classidClass = :classidClass")})
public class Timetable implements Serializable {
    private static final long serialVersionUID = 1L;
    @EmbeddedId
    protected TimetablePK timetablePK;
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "timetable")
    private Collection<Absence> absenceCollection;
    @JoinColumn(name = "Class_idClass", referencedColumnName = "idClass", insertable = false, updatable = false)
    @ManyToOne(optional = false)
    private Class class1;

    public Timetable() {
    }

    public Timetable(TimetablePK timetablePK) {
        this.timetablePK = timetablePK;
    }

时间表PK

Embeddable
public class TimetablePK implements Serializable {
    @Basic(optional = false)
    @NotNull
    @Column(name = "Period")
    private int period;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 45)
    @Column(name = "Day")
    private String day;
    @Basic(optional = false)
    @NotNull
    @Column(name = "Class_idClass")
    private int classidClass;

    public TimetablePK() {
    }

    public TimetablePK(int period, String day, int classidClass) {
        this.period = period;
        this.day = day;
        this.classidClass = classidClass;
    }

编辑两个

Answer 1

考虑一下这一点：

@JoinColumn(name = "TimeTable_Period", referencedColumnName = "Period")
private Timetable timetable;

您已经在您的时间表实体中引用了时段一栏。但是在时间表上。java我没有看到任何与表中的时段列映射的字段。

例如：

@Id // as its the primary key!
@Column(name="Period")
private Long period

对于您在@ManyToOne映射中使用的其他引用实体，这应该是相同的。

Answer 2

您的图表指示TimeTable表有一个由三列组成的主键（周期、日和Class_idClass）。您需要向添加一个注释bsence.time表，如下所示：

public class Absence implements Serializable {
    ...
    @JoinColumns[
        @JoinColumn(name = "TimeTable_Period", referencedColumnName = "Period", ...),
        @JoinColumn(name = "????", referencedColumnName = "Day", ...),
        @JoinColumn(name = "Class_idClass", referencedColumnName = "Class_idClass", ...)
    ]
    @ManyToOne(optional = false)
    private TimeTable timeTable;
    ...
}