DML操作不支持JPAREPOSITORITION（DELETE）

发布于 2025-02-06 21:14:25 字数 734 浏览 3 评论 0原文

我一直在尝试创建用户并之后将其作为测试的一部分删除，但是我继续遇到相同的错误 org.hibernate.hql.internal.queryexecutionrequestExexception：即使在DML操作之后不支持在我的存储库和控制器中不断更改代码。

这是我的存储库中的代码：

@Transactional
    @Override
    public void deleteById(long id) {
        Query query = entityManager.createQuery(
                "delete from UserModel as u where u.id=:id"
        ).setParameter("id", id);
        query.getSingleResult();
        query.executeUpdate();
    }

这是我的控制器中的代码：

    @DeleteMapping("/deleteUser")
    public @ResponseBody
    void deleteUser(@RequestParam long id) {
        userRepository.deleteById(id);
        ResponseEntity.ok(null);
    }

原文

I keep trying to create a user and delete it afterwards as a part of my tests, but I keep getting the same error org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations even after continuously changing the code in both my Repository and Controller.

This is the code in my Repository:

@Transactional
    @Override
    public void deleteById(long id) {
        Query query = entityManager.createQuery(
                "delete from UserModel as u where u.id=:id"
        ).setParameter("id", id);
        query.getSingleResult();
        query.executeUpdate();
    }

This is the code in my Controller:

    @DeleteMapping("/deleteUser")
    public @ResponseBody
    void deleteUser(@RequestParam long id) {
        userRepository.deleteById(id);
        ResponseEntity.ok(null);
    }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

箹锭⒈辈孓 2025-02-13 21:14:27

我认为，由于query.getSingleresult（）;行，该例外是触发的，该行试图从删除查询中获取结果（这是查询的更新类型）。

尝试这样更改代码：

@Override
public void deleteById(long id) {
    Query query = entityManager.createQuery(
            "delete from UserModel as u where u.id=:id"
    ).setParameter("id", id);
    query.executeUpdate();
}

I think the exception is triggering due to the query.getSingleResult(); line which is trying to fetch a result from a DELETE query (which is an UPDATE type of query).

Try changing the code like this:

@Override
public void deleteById(long id) {
    Query query = entityManager.createQuery(
            "delete from UserModel as u where u.id=:id"
    ).setParameter("id", id);
    query.executeUpdate();
}

回复收藏 0 原文

~没有更多了~