How to execute this sql query using criteria in hibernate?

Question

I have a sql query

delete from response where r_id in (1,2,3,4) and u_id='10';

Now I want to execute this queru using hibernate.

I know i can do this through createSQLQuery but I have to use criteria.

How i can do this?

Thanks.

WeMakeSoftware · Accepted Answer · 2013-05-29 08:30:06Z

1

If you have to use criteria here, you will have to fetch all the objects to Java and delete them using Java mechanisms.

This approach is very slow in terms of performance, but IFF you really must use it:

List<Response> doomedResponses =  createCriteria(Response.class).addRestriction(/* restrictions here*/).list();
for(Response doomed : doomedResponses) {

     entityManager.remove(doomed);
 }

answered May 29, 2013 at 8:30

WeMakeSoftware

9,1825 gold badges37 silver badges52 bronze badges

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

Comments

Juned Ahsan · Accepted Answer · 2013-05-29 08:36:46Z

1

You need to add two restrictions, one for IN, here is the java api for Restriction.in

static Criterion in(String propertyName, Object[] values) Apply an "in" constraint to the named property

So your code should look like this

  Criteria criteria = session.createCriteria(Yourclass.class);
// create a collection for IN values comparision and lets assume it is called CollectionofValues
       criteria.add(Restrictions.in(r_id, collectionofValues);
      criteria.add(Restriction.eq(u_id,'10'));

answered May 29, 2013 at 8:36

Juned Ahsan

68.9k12 gold badges101 silver badges138 bronze badges

Collectives™ on Stack Overflow

How to execute this sql query using criteria in hibernate?

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