Hibernate OnDelete Cascade不适用MySql，但适用于postgres和Ms-Sql

Question

@OnDelete(action = OnDeleteAction.CASCADE)

//Thread Entity
@Id
@GeneratedValue
@Column(name = "thread_id")
private int ThreadID;

//Post Entity
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "post_id")
private int PostID;

@OneToOne()
@OnDelete(action = OnDeleteAction.CASCADE)
private thread ThreadID;

session.delete(session.load(thread.class,1));

请帮我想办法摆脱这一切。

Answer 1

这就是我在Spring Boot的基础上解决这个问题的方法。

解决方案

从

// application.properties  
spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect

spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect

// MySQLDialect.java
@Override
    public boolean supportsCascadeDelete() {
        return false;
    }

// MySQL5InnoDBDialect.java
@Override
    public boolean supportsCascadeDelete() {
        return true;
    }