spring data jpa @Query注解中delete语句报错

刚开始是这样

    /**
     * 根据案件id删除案件信息
     * @param caseId
     * @return
     */
    @Query(value = "DELETE FROM case_trial_info t WHERE t.case_id = :caseId", nativeQuery = true)
    void deleteByCaseId(@Param("caseId") String caseId);

报错，后来查询需要添加@Modifying和@Transactional，我改成

    @Modifying
    @Transactional
    @Query(value = "DELETE FROM case_trial_info t WHERE t.case_id = :caseId", nativeQuery = true)
    void deleteByCaseId(@Param("caseId") String caseId);

还是报错

后来改成

    @Transactional
    void deleteByCaseId(@Param("caseId") String caseId);

放弃用@Query，只用@Transactional一个注解就成功了

jpa的deleteBy可以根据表字段实现删除功能