hibernate - how to do a conditional delete without loading to memory

Question

I have an object -

 @Entity
 public class myObject{
      public MySecondObject objA;
      public MySecondObject objB;
      ...
 }

I dont have any instance of it but I want to delete all the rows in db that have fieldA == thirdObj I have an instance of thirdOBJ but no instance of myobjects. it is possible to do it with native sql. but than I will need to use the auto assigned id of thirdobj - to compare in the db.
Is there a more elegant way than this?

    try {
        session.beginTransaction();
        session.createQuery("delete from MyObject where fieldA = " +        
                             thirdObject.getID()).executeUpdate();

        session.getTransaction().commit();
        savedSuccessfully = true;
    } catch (HibernateException e) {
        session.getTransaction().rollback();
        savedSuccessfully = false;

    } finally {
        session.close();
    }
    return savedSuccessfully;

Stefan Steinegger · Accepted Answer · 2011-07-07 07:57:13Z

3

It should work with HQL

session
  .createQuery("delete from MyObject where objA = :third")
  .setEntity("third", thirdObject)
  .executeUpdate();

But there are some limits: HQL deletes do not cascade (most) references and do not recognize the real type if there are subclasses. If your class is a simply class, it will work fine.

edited Jul 7, 2011 at 7:57

answered Jul 7, 2011 at 7:39

Stefan Steinegger

64.8k17 gold badges132 silver badges193 bronze badges

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

Comments

Sean Patrick Floyd · Accepted Answer · 2011-07-07 07:15:49Z

1

a) In your example, you are using HQL, not native SQL. Big difference.
b) No, those are the two possibilities. Delete an Object (but you have to load it first) or delete by id (but that's only possible through HQL or native SQL).

answered Jul 7, 2011 at 7:15

Sean Patrick Floyd

301k72 gold badges481 silver badges598 bronze badges

Collectives™ on Stack Overflow

hibernate - how to do a conditional delete without loading to memory

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