revseev · April 5, 2020 16:41
diff --git a/JPQL delete with JOIN query b/JPQL delete with JOIN query
    @Override
    @Transactional(propagation= Propagation.MANDATORY)
    public void bulkDeleteByUserId(Long id) {
        // Write all pending changes to the DB
        entityManager.flush();
        // Remove all entities from the persistence context
        entityManager.clear();
        entityManager.createQuery("DELETE FROM StudentReviewAnswer x " +
                        "WHERE x IN (SELECT sra FROM StudentReviewAnswer sra " +
                                            "JOIN StudentReview sr ON sra.studentReview.id = sr.id " +
                                             "WHERE sr.user.id =:id)")
                .setParameter("id", id)
                .executeUpdate();
    }
 }
No results found