JPA/Hibernate typesafe DELETE queries

Question

The only CriteriaQuery examples I've seen are for SELECT queries. Is there a way to construct typesafe DELETE queries, either with JPA 2 or Hibernate APIs?

score 7 · Answer 1 · answered Oct 22 '12 at 01:24

7

It will be available in JPA 2.1 version.

answered Oct 22 '12 at 01:24

sinuhepop

20,010
17
72
107

3

And [here](http://en.wikibooks.org/wiki/Java_Persistence/Criteria#CriteriaDelete_.28JPA_2.1.29) is how you delete in 2.1 – TheConstructor Mar 17 '14 at 16:13

score 7 · Accepted Answer · answered May 22 '11 at 22:01

7

I don't think it's possible.

Quoted from http://blogs.oracle.com/ldemichiel/entry/java_persistence_2_0_public1 :

The Criteria API does not currently support update and delete operations

answered May 22 '11 at 22:01

Cojones

1,906
22
25

score 5 · Answer 3 · answered Jul 07 '11 at 06:59

It is not directly possible, but you can use typesafe DELETE and UPDATE queries via the Querydsl JPA extension. Querydsl uses JPQL internally, but provides a typesafe fluent interface for the query construction.

I am the maintainer of Querydsl, so this answer is biased.

score -6 · Answer 4 · answered Apr 06 '11 at 09:07

not sure if you can do it with Criteria but it is possible to create HQL with bulk operations such as delete or update. Check this example from "Persistence with Hibernate" book (page 535):

Query q = session.createQuery(
   "delete CreditCard c where c.stolenOn is not null"
);
int updatedCreditCards = q.executeUpdate();

Best regards!

JPA/Hibernate typesafe DELETE queries

4 Answers4