Hibernate Session.delete() an object if exists

Question

In JavaDoc of Session class the description of delete method is:

Remove a persistent instance from the datastore. The argument may be an instance associated with the receiving Session or a transient instance with an identifier associated with existing persistent state.

My questions are:

I want to delete a detach object, can I use this method, AFAIK session first makes an object persistent from detach and then perform its operation. Am I right?
If I am not sure about the existence of the object in database, should I use Session.get() to check the whether or not it is null and then perform delete operation or I can use directly delete operation?

Here is a code snippet:

public void removeUnallocatedUserIfExits(final long itemId) {
    getHibernateTemplate().execute(new HibernateCallback() {

        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            session.flush();
            session.setCacheMode(CacheMode.IGNORE);
            UnallocatedUser unallocatedUser;
            if ((unallocatedUser = (UnallocatedUser) session.get(UnallocatedUser.class, itemId)) != null) {
                session.delete(unallocatedUser);
            }
            session.flush();
            return null;
        }
    });
}

Is the okay?

Adeel Ansari · Accepted Answer · 2016-07-11 11:00:40Z

30

or a transient instance with an identifier associated with existing persistent state

This means you can directly pass your entity to session.delete(), in order to delete that object. Further, you need not check whether the entity exist or not. There should be an exception if no record found in the database. In fact, we usually don't really get this case. We always delete an existing entity, I mean usual logic is like that; so, no need to do that. You can simply do this,

SomeEntity ent = session.load(SomeEntity.class, '1234');
session.delete(ent);

or you can do this instead,

SomeEntity ent = new SomeEntity('1234'); // used constructor for brevity
session.delete(ent);

Btw, you can also use this version session.delete(String query),

sess.delete("from Employee e where e.id = '1234'"); // Just found it is deprecated

edited Jul 11, 2016 at 11:00

answered Apr 25, 2011 at 7:47

Adeel Ansari

39.9k12 gold badges97 silver badges135 bronze badges

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

2 Comments

Guillaume F. Over a year ago

You should use session.load() instead of .get() to avoid fetching the entity's data.

Adeel Ansari Over a year ago

@GuillaumeF., Yes, then you might get a proxied instance. Furthermore, the doc states, "You should not use load() to determine if an instance exists (use get() instead). Use load() only to retrieve an instance that you assume exists, where non-existence would be an actual error". Here we're assuming that the entity exists; so, yes, load() would be of choice.

Musaddique · Accepted Answer · 2015-04-02 07:17:02Z

6

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class DeletePersistentObjectWithHibernate {

public static void main(String[] args) {

        SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();

        Session session = sessionFactory.getCurrentSession();

        long id = 2;

        try {
            session.beginTransaction();

            Employee employee = (Employee) session.get(Employee.class, id);

            session.delete(employee);

            session.getTransaction().commit();
        }
        catch (HibernateException e) {
            e.printStackTrace();
            session.getTransaction().rollback();
        }

    }

}

answered Apr 2, 2015 at 7:17

Musaddique

4435 silver badges9 bronze badges

2 Comments

janisz Over a year ago

Please add some comment

Musaddique Over a year ago

session.get() will fetch Employee object from database. if Employee object contain another object then that object will also fetch at same time and then Employee will be deleted from the database by session.delete(obj)

jsina · Accepted Answer · 2013-02-25 18:46:39Z

4

Try this...

public <T> T delete(T t) throws Exception {
    try {
        t = load(t);
        session.delete(t);
        session.flush();
    } catch (Exception e) {
        throw e;
    } finally {
        session.clear();
    }

    return t;
}

public <T> T load(T t) {
    session.buildLockRequest(LockOptions.NONE).lock(t);
    return t;
}

edited Feb 25, 2013 at 18:46

answered Feb 25, 2013 at 18:40

jsina

4,8791 gold badge34 silver badges28 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:16:59Z

4

Just found one better solution:

Query q = session.createQuery("delete Entity where id = X");
q.executeUpdate();

Hibernate Delete query

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Dec 31, 2014 at 5:36

bluearrow

9042 gold badges12 silver badges29 bronze badges

Comments

Shailendra · Accepted Answer · 2012-09-10 10:44:40Z

I want to delete a detach object, can I use this method, AFAIK session first makes an object persistent from detach and then perform its operation. Am I right?

If you know the identifier of the object you want to delete, then you can create an instance with its identifier set and pass it to session delete method. This instance would be considered to be in detached state ( since there is an identifier associated), however it will be internally reattached to session by Hibernate and then deleted.

If I am not sure about the existence of the object in database, should I use Session.get() to check the whether or not it is null and then perform delete operation or I can use directly delete operation?

The delete method will throw StaleObjectException if it cannot find the object to be deleted. So you can use exception handling to decide what to do in that case.

Osama Abdulsattar · Accepted Answer · 2014-09-01 13:43:33Z

1

You can easily achieve by following simple hibernate as follows,

Session session=getSession();  
String hql = "delete from Student where classId= :id"; 
session.createQuery(hql).setString("id", new Integer(id)).executeUpdate();

answered Sep 1, 2014 at 13:43

Osama Abdulsattar

5761 gold badge4 silver badges11 bronze badges

Comments

Mahendra · Accepted Answer · 2020-03-30 13:18:28Z

0

Hibernate native query sample as follows.

import org.hibernate.query.nativeQuery;  

String sql = "Delete from Student where classId= :id"; 
NativeQuery query = session.createNativeQuery(sql.toString()); 
query.executeUpdate();

answered Mar 30, 2020 at 13:18

Mahendra

1771 silver badge6 bronze badges

Collectives™ on Stack Overflow

Hibernate Session.delete() an object if exists

7 Answers 7

2 Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related