Hibernate delete using criteria

Question

Can I use Criteria to delete records from my tables?

For example,

Criteria toDelete = session.createCriteria(Car.class, "car").createAlias("car.wheel", "wheel");
toDelete.add(Restrictions.eq("brand", "Toyota"));
toDelete.add(Restrictions.eq("wheel.brand", "BBS");
toDelete.add(Restrictions.gt("date_of_purchase", someDay);
toDelete.add(Restrictions.between("cost", 3000, 5000);

How can I use toDelete criteria to delete the records that I am interested in? An inefficient way would be to query for the ids using the toDelete criteria, then delete Car objects from there. Also, can I know how many objects have I deleted?

Rodrigo R. Coelho · Accepted Answer · 2016-09-28 20:50:53Z

2

You should upgrade your hibernate version to a version that implements JPA 2.1 (Hibernate starts JPA 2.1 on version 4.3.11.Final - Hibernate Downloads)

Once you have upgraded, you can use CriteriaDelete to do what you want. here is a small example: Example

answered Sep 28, 2016 at 20:50

Rodrigo R. Coelho

1683 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hung NGUYEN · Accepted Answer · 2014-06-08 04:13:35Z

1

In my opinion, you cannot do that because Hibernate does not support. As a replacement, you can use something like:

String hql = "delete from User where UserName = :name";
Query query = session.createQuery(hql);
query.setString("name", "User 9");
int rowCount = query.executeUpdate();
System.out.println("Rows affected: " + rowCount);

Best regards, Hung NGUYEN

answered Jun 8, 2014 at 4:13

Hung NGUYEN

111 bronze badge

Collectives™ on Stack Overflow

Hibernate delete using criteria

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related