Spring Hibernate getCurrentSession() delete not working

Question

I am fully testing an entity on my unit test, and almost everything worked so far: create, update, list. However, when I try to delete a record, it is not getting deleted. Here is the code I am using:

  public void delete (Integer id) {
    // This doesnt work even though I know user is set and id is not null
    User user = find(id);
    getSession().delete(user);
    // This will work
    // Query query = getSession().createSQLQuery("DELETE FROM users WHERE id = " + id);
    // query.executeUpdate();
  }    

    private Session getSession() {
      if (session == null) {        
        try {
            session = SessionFactoryUtils.getSession(sessionFactory, Boolean.TRUE);
          TransactionSynchronizationManager.bindResource(session.getSessionFactory(), new SessionHolder(session));            
        } catch (Exception e) {
            session = SessionFactoryUtils.getSession(sessionFactory, Boolean.FALSE);          
        }
      }
      return session;
    }

If I execute the query directly it works but using the delete() method doesnt. I think it may be related to committing the transaction but I already tried something like that and no luck. Any ideas?

marcelorocks · Accepted Answer · 2014-03-14 21:22:59Z

1

I found the problem with this one.

First, find() method was evicting my user model, and probably taking it out of the session.

After delete(), I also needed to session.flush()

answered Mar 14, 2014 at 21:22

marcelorocks

2,0353 gold badges18 silver badges28 bronze badges

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

1 Comment

marcelorocks Over a year ago

Sorry, what do you mean?

Collectives™ on Stack Overflow

Spring Hibernate getCurrentSession() delete not working

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related