[Mysql] Cannot delete or update a parent row

 

https://haenny.tistory.com/78

[Error] MySQL 에러 Cannot delete or update a parent row: a foreign key constraint fails

 

 

//게시물 삭제
    @DeleteMapping("/{boardId}")
    public ResponseEntity deleteBoard(@PathVariable Long boardId) {
        //board, home, homeImage 삭제
        Board board = boardService.findOne(boardId);
        Home home = homeService.findOne(board.getHome().getId());
        List<HomeImage> homeImages = home.getHomeImages();

        boardService.delete(board);
        homeService.delete(home);
        homeImages.forEach(homeImageService::delete); //여기서 문제 => 프록시 초기화 객체로 삭제 가능?
        //Cannot delete or update a parent row
        //Board => HomeImage => Home 순으로 삭제 => 티스토리 업로드

        return ResponseEntity.ok("");
    }

 

해결

//게시물 삭제
    @DeleteMapping("/{boardId}")
    public ResponseEntity deleteBoard(@PathVariable Long boardId) {
        //board, home, homeImage 삭제
        Board board = boardService.findOne(boardId);
        Home home = homeService.findOne(board.getHome().getId());
        List<HomeImage> homeImages = home.getHomeImages();

        boardService.delete(board);
        homeImages.forEach(homeImageService::delete); //여기서 문제 => 프록시 초기화 객체로 삭제 가능?
        homeService.delete(home);
        //Cannot delete or update a parent row
        //Board => HomeImage => Home 순으로 삭제 => 티스토리 업로드

        return ResponseEntity.ok("");
    }