Using CriteriaDelete for delete operations

Asked Jul 04 '18 at 09:10

Active Jul 04 '18 at 09:20

Viewed 919 times

I'm using JPA Criteria API, and I want to remove "Actions" that have "Loop" is equal to the passed param, so I did as following:

public void removeByLoopId(final Long id) {
    CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
    CriteriaDelete<Action> delete = cb.createCriteriaDelete(Action.class);
    Root<Action> root = delete.from(Action.class);
    delete.where(cb.equal(root.get(Action.actor).get(Actor_.step).get(Step_.loop).get(Loop_.id), id));
    getEntityManager().createQuery(delete).executeUpdate();
}

But I'm getting this exception :

ERROR o.h.e.j.s.SqlExceptionHelper - ORA-00933: SQL command not properly ended

How can I solve this ?

Edit:

This is the generated SQL query:

delete
    from
        IKURUSAKI.Action cross
    join
        IKURUSAKI.Actor cross
    join
        IKURUSAKI.Step cross
    join
        IKURUSAKI.Loop 
    where
        id=10738;

edited Jun 20 '20 at 09:12

Community

asked Jul 04 '18 at 09:10

Renaud is Not Bill Gates

1,684
34
105
191

Have you tried to create your own Joins from Action to Loop? And then use the equals on the join? – kaba713 Jul 04 '18 at 09:41
@kaba713 I don't think that's possible since UPDATE/DELETE criteria queries cannot define joins – Renaud is Not Bill Gates Jul 04 '18 at 09:42
Not directly but you could create a subquery that does just that for you. – kaba713 Jul 04 '18 at 09:51

Using CriteriaDelete for delete operations

Edit:

0 Answers0