使用nativeJPQL删除查询时出现异常

Question

org.springframework.dao.InvalidDataAccessApiUsageException: Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:403)
    ...................
Caused by: javax.persistence.TransactionRequiredException: Executing an update/delete query
    at org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:413)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1668)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
...............

@Entity
public class Employe implements Serializable{

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    
    private String prenom;
    
    private String nom;
    
    private String email;
    
    private int isActif;
    
    @Enumerated(EnumType.STRING)
    private Role role;

    @OneToOne(mappedBy ="employe", cascade = CascadeType.REMOVE)
    Contrat contrat;
    
    @ManyToMany( mappedBy="employes", fetch= FetchType.EAGER , cascade = {CascadeType.PERSIST })
    private List<Departement> departements;
    
    @ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE ,CascadeType.REMOVE})
    List<Mission> missions;
.........

@Entity
public class Departement implements Serializable{

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    
    private String name;
    
    @ManyToOne( cascade = {CascadeType.PERSIST, CascadeType.MERGE} )
    private Entreprise entreprise;
    
    @OneToMany( mappedBy="departement", cascade = {CascadeType.PERSIST, CascadeType.MERGE})
    private List<Mission> missions;
    
    @ManyToMany(fetch = FetchType.EAGER, cascade = {CascadeType.PERSIST, CascadeType.MERGE})
    private List<Employe> employes;
    

 @Modifying
 @Query(value = "DELETE FROM departement_employes WHERE employes_id = :id ", nativeQuery = true)
 void deleteEmployerDepartementsAssociations(@Param("id") int id );
 

员工与部门之间的关联是多对多的双向关联。

我正在尝试在删除受雇者之前删除关联

Answer 1

尝试以以下方式更正您的查询：

@Modifying
@Query(value = "DELETE FROM departement_employes WHERE employes_id = :id ", nativeQuery = true)
void deleteEmployerDepartementsAssociations(@Param("id") int id );

您必须在事务中包装任何数据库修改操作。看看这篇文章的例子。

因此，作为一种可能的方法，您可以通过@transactional注释来注释您的服务方法：

@Override
@Transactional
public void deleteEmployerById(int id) {
   // ...
}