Spring Boot Hibernate (book, authors) duplicate foreign key
Пытаюсь смоделировать предметную область с книгами и авторами. У меня получились такие доменные объекты:
Книга:
package aoizora.domain.book;
import aoizora.domain.author.Author;
import jakarta.persistence.*;
import lombok.Data;
import java.util.Set;
@Data
@Entity
public class Book
{
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private long id;
@Column
private String title;
@Column
private String isbn;
@ManyToMany
@JoinTable(
name = "book_authors",
joinColumns = @JoinColumn(name = "book_id"),
inverseJoinColumns = @JoinColumn(name = "author_id")
)
private Set<Author> authors;
}
Автор:
package aoizora.domain.author;
import aoizora.domain.book.Book;
import jakarta.persistence.*;
import lombok.Data;
import java.util.Set;
@Data
@Entity
public class Author
{
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private long id;
@Column
private String firstName;
@Column
private String lastName;
@ManyToMany(mappedBy = "authors")
private Set<Book> books;
}
Конфиг приложения application.yml:
spring:
datasource:
url: jdbc:mysql://localhost:3306/mysql
username: root
password: 123
driver-class-name=com: com.mysql.jdbc.Driver
jpa:
hibernate:
ddl-auto: update
database-platform: org.hibernate.dialect.MySQL8Dialect
defer-datasource-initialization: true
sql:
init:
mode: always
Файл pom:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>book-catalogue</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>22</maven.compiler.source>
<maven.compiler.target>22</maven.compiler.target>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>3.2.5</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<version>3.2.5</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.32</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.33</version>
</dependency>
</dependencies>
</project>
При запуске всего этого возникает следующая ошибка:
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table book_authors add constraint FKs4xm7q8i3uxvaiswj1c35nnxw foreign key (book_id) references book (id)" via JDBC [Duplicate foreign key constraint name 'FKs4xm7q8i3uxvaiswj1c35nnxw']
Почему она возникла? Как ее исправить?