spring boot: Cannot delete or update a parent row: a foreign key constraint fails

Question

I have the following class:

@EmbeddedId
private BookAuthorId id;

@ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
@MapsId("bookIsbn")
private Book book;

@ManyToOne(fetch = FetchType.LAZY)
@MapsId("authorId")
private Author author;

@NotNull(message = "Author's index can not be null")
@Column(name = "author_index")
private Integer index;

}

So, basically, I try to delete a book without any author and it works, when I have some authors with a book I get: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (books.books_authors, CONSTRAINT FKg92282id84r9l5youm7y12vpg FOREIGN KEY (book_isbn) REFERENCES books (isbn))

Some ideas?

Ty

user_17590572 · Answer

You have to detach the entities first. You are deleting a book, but that same book is referenced in the author entity and that is why you are receiving this error.

You should write logic for removing the book from author and then to delete the book. You could check this blog post for more information https://thorben-janssen.com/hibernate-tips-the-best-way-to-remove-entities-from-a-many-to-many-association/

spring boot: Cannot delete or update a parent row: a foreign key constraint fails

1 Answers