SpringDataJPA中不兼容的型別參考和參考列

我希望我的 ID 是 uuid，并且學生和課程之間應該存在多對一的關系。我得到了參考列和參考列的不兼容型別。

學生.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

uj5u.com熱心網友回復：

請學習如何創建關聯

什么是 @JoinColumn 以及它在 Hibernate 中的使用方式

永遠不要使用像courseId! 您已經@ManyToOne與@JoinColumn注釋關聯。Hibernate 足夠聰明，可以理解course_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;

}

標籤：爪哇 弹簧靴 jpa

上一篇：@Transactional不會通過呼叫引發RuntimeException的External方法來回滾

下一篇：如何按fk_name過濾搜索？