Not supported for DML operations

JpaRepository에서 @Query 어노테이션을 이용해 DELETE문을 작성할 때 발생하는 에러

UPDATE, DELETE 쿼리에는 @Modifying, @Transactional 어노테이션을 모두 붙여야한다.

 

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

@Modifying
@Transactional
@Query("DELETE " +
       "  FROM Comment " +
       " WHERE commentId = :commentId " +
       "   AND boardId = :boardId")
void deleteByCommentIdAndBoardId(Long commentId, Long boardId);