通过JDBC语句执行DDL“alter table score add constraint外键（注册_id）引用注册（id）”时出错

Question

我有一个有分数表的注册班。我试图引用Score类，但通过JDBC语句执行DDL“alter table Score add constraint…foreign key（registration_id）references registration（id）”时出错，原因是：java。sql。SQLException:无法打开引用的表“enrollment”。运行应用程序后，会在数据库中创建分数表，但缺少注册表，并且分数的注册id列不是外键。我怎样才能解决这个问题？我试图用@Cache注释，并忽略表的双重创建，但没有成功。我正在使用MySQL。

@Entity
@Table(name = "enrollment")
public class Enrollment {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    public int id;
    
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "student_id")
    public Student student;
    
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "date", nullable = false)
    public Date date;

    @Column(name = "rank", nullable = false)
    public int rank;
    
    @OneToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "specialty_id", referencedColumnName = "id")
    public Specialty specialty;
    
    @Lob
    @Basic(fetch = FetchType.LAZY)
    @Column(name = "files", columnDefinition = "BLOB", nullable = false)
    private byte[] files;
    
    @OneToMany(mappedBy = "enrollment", fetch = FetchType.LAZY)
    public List<Score> scores;
    
    @Column(name = "state", length = 50, nullable = false)
    public String state;
   
}

@Entity
@Table(name = "score")
public class Score {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    
    @OneToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "score_forming_object_id", referencedColumnName = "id")
    private ScoreFormingObject scoreFormingObject;
    
    @Column(name = "score", nullable = false)
    private double score;
    
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "enrollment_id")
    private Enrollment enrollment;
}

Answer 1

https://stackoverflow.com/a/64316793/14644191@Rajib Garai的回答对我有用。我在application.properties中添加了spring.jpa.properties.hibernate.globally_quoted_identifiers=true，问题得到了解决。

Answer 2

检查您的注册实体类是否位于应用程序类的同一目录或子目录中。