Delete multiple objects at once using CriteriaBuilder

java hibernate jpa criteria-api
Jorn picture Jorn · Aug 6, 2014 · Viewed 12.9k times · Source

I'm trying to delete a bunch of objects with one query using the CriteriaBuilder API. I'm looking for something like this select:

CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<T> query = criteriaBuilder.createQuery(entityClass);
Root<T> root = query.from(entityClass);
query.select(root).where(/*some condition*/);
return entityManager.createQuery(query).getResultList();

but then a delete instead of a select. As far as I can see, there's no remove or delete method on CriteriaQuery. Is it possible using this API?

I can of course execute the select, then call entityManager.remove(object) for each result, but that feels very inefficient.

Answer

guardian picture guardian · Aug 6, 2014

Try this:

CriteriaBuilder criteriaBuilder  = entityManager.getCriteriaBuilder();
CriteriaDelete<SomeClass> query = criteriaBuilder.createCriteriaDelete(SomeClass.class);
Root<SomeClass> root = query.from(SomeClass.class);
query.where(root.get("id").in(listWithIds));

int result = entityManager.createQuery(query).executeUpdate();

The where clause can laso look like this:

query.where(criteriaBuilder.lessThanOrEqualTo(root.get("id"), someId));

Related questions

JPA & Criteria API - Select only specific columns

I would like to select only specific columns (ex. SELECT a FROM b). I have a generic DAO and what I came up with is: public List<T> getAll(boolean idAndVersionOnly) { CriteriaBuilder builder = manager.getCriteriaBuilder(); CriteriaQuery<T&…

Read More
How to properly determine whether an "exists" JPA Criteria Query clause returned true or false?

I don't know how to perform a JPA criteria query that returns with a boolean output. The goal is to have a criteria query that looks like this when rendered on Oracle: select 1 from dual where exists ( ... ); The where exists (...) …

Read More
Distinct results from Spring Data JPA Specification that uses join

I have the following Specification that I use to query for any Contact entities that are tied to certain ManagedApplication entities. I pass in a Collection<Long> that contains the ids of the ManagedApplication entities that I am …

Read More