Spring数据JPA中的类型引用和引用列不兼容

Question

我希望我的ID是uuid，学生和课程之间应该有多对一的关系。我得到不兼容的类型引用列和引用列。

Student.java

package com.test.model;

import java.util.UUID;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.hibernate.annotations.Type;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@NoArgsConstructor
@AllArgsConstructor
@Getter
@Setter
@Entity
@Table(name="student",schema="mydb")
public class Student {
    
    @Id
    @Type(type="uuid-char")
    @Column(name="student_id")
    private UUID studentId;
    
    @Column(name="name")
    private String sudentName;
    
    @ManyToOne
    @JoinColumn(name="course_id")
    private Course course;
    
    @Column(name="course_id",insertable = false,updatable = false,nullable = false)
    private UUID courseId;

}

课程JAVA

package com.test.model;

import java.util.UUID;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.Type;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@NoArgsConstructor
@AllArgsConstructor
@Getter
@Setter
@Entity
@Table(name="course",schema="mydb")
public class Course {
    
    @Id
    @Type(type="uuid-char")
    @Column(name="id")
    private UUID id;
    
    @Column(name="courseName")
    private String courseName;

}

例外

Caused by: java.sql.SQLException: Referencing column 'course_id' and referenced column 'id' in foreign key constraint 'FKdfypyqt0stgfc0aij9kcxm99s' are incompatible.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.28.jar:8.0.28]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar:8.0.28]
    at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-java-8.0.28.jar:8.0.28]
    at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.28.jar:8.0.28]
    at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na]
    at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na]
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
    ... 33 common frames omitted

Answer 1

请学习如何创建关联

@JoinColumn是什么，在Hibernate中是如何使用的

永远不要使用原始ID，比如courseId！你已经有了@manytone与@JoinColumn注释的关联。Hibernate足够聪明，能够理解课程id将被用作外键。

@Table(name="student",schema="mydb")
public class Student {
    
    @Id
    @Type(type="uuid-char")
    @Column(name="student_id")
    private UUID studentId;
    
    @Column(name="name")
    private String sudentName;
    
    @ManyToOne
    @JoinColumn(name="course_id")
    private Course course;

}