我有一个例外“org.hibernate.tool.schema.spi.CommandAcceptanceException:

Question

这是我的密码

package com.examplesector.choosesectors.models.Entity;

import lombok.*;

import javax.persistence.*;
import javax.validation.constraints.Size;
import java.util.List;
import java.util.Objects;

@Entity
@Data
@Table(name = "person")
public class Person {
   @Id
   @GeneratedValue(strategy = GenerationType.AUTO)
   private Long id;
   private String name;

   @JoinTable(name = "person_sector",
   joinColumns = {@JoinColumn(name = "PERSON_ID")},
   inverseJoinColumns = {@JoinColumn(name = "SECTOR_ID")})
   @ManyToMany(cascade = {CascadeType.ALL})
   private List<Sector> sectors;
   private Boolean checkedAgreeToTerms;


  }




  package com.examplesector.choosesectors.models.Entity;

  import lombok.*;

  import javax.persistence.*;
  import javax.validation.constraints.Size;
  import java.util.List;
  import java.util.Objects;

  @Entity
  @Data
  @Table(name = "sector")
  public class Sector {
     @Id
     @GeneratedValue(strategy = GenerationType.AUTO)
     private Long id;
     private String nameSector;
     private String group;

     @ManyToMany()
     @JoinColumn(name = "PERSON_ID")
     private List<Person> persons;


  }

enter code here

properties
server.port=8082
spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:3306/dbsector? 
useUnicode=true&serverTimezone=UTC&useSSL=true&verifyServerCertificate=false
spring.datasource.username=root
spring.datasource.password=root
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
#spring.jpa.properties.hibernate.id.new_generator_mappings=true
#spring.jpa.properties.hibernate.jdbc.lab.non_contextual_creation=true

此错误org.hibernate.tool.schema.spi.命令接受异常：通过JDBC语句执行DDL“创建表扇区（id bigint not null，group varchar（255），name_sectorvarchar（255），主键（id））引擎=InnoDB”的错误

org.hibernate.tool.schema.spi.命令验收异常：通过JDBC语句执行DDL“更改表person_sector添加约束FK7jwl41bm5xj1cyypbdl8vn2gp外键（sector_id）引用扇区（id）”时出错

原因：java。sql。SQLException:无法打开引用的表“扇区”

组织。冬眠工具模式。spi。CommandAcceptanceException:通过JDBC语句执行DDL“alter table sector_persons add constraint FKK28LNWTJXU7GXX4998V0EX1M外键（sector_id）引用sector（id）”时出错

在这里输入代码

Answer 1

由于您在人类中指定了joinCol列和inverseJoinCol列，请尝试删除扇区类中的@JoinCol列。