Hi guys,

I have a strange problem to delete entities in bulk mode from JSF managed CDI bean. If I trigger the delete method from an EJB than it's works as excpected.

This is my "Bulk" delete method.

 @Override
  public <T extends EditableIF> List<Long> makeTransient(List<T> editables){
    try {
      if (editables == null || editables.size() == 0) {
        log.error("Nothing to delete");
        return new ArrayList<>();
      }
      // Backup the current flushmode
      FlushModeType flushModeBefore = em.getFlushMode();
      em.setFlushMode(FlushModeType.COMMIT);
      int i = 0;
      // Save or update all editables and flush every 50 times
      ArrayList<Long> ids = new ArrayList<>();
      for (T eif : editables) {
        em.remove(mergeIfNeeded(eif));
        ids.add(eif.getId());
        i++;
        if (i % BULK_FLUSH_SIZE == 0) {
          em.flush();
        }
      }
      em.flush();
      em.setFlushMode(flushModeBefore);
      return ids;
    } catch (HibernateException ex) {
      throw new InfrastructureException(ex);
    }
  }

The intent of this mehtod is that I wan't improve performance for big deletions. As I said, if I trigger this method from  an EJB then it works fine. But if I trigger this from an SessionScoped CDI bean then the database entries are not deleted.

For tracking the behaviuour of hibernate I switch the loglevel of org.hibernate.event.internal.DefaultDeleteEventListener to TRACE and add a delete interceptor.

The related logentires are shown below:

13:36:58,120 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting a persistent instance
13:36:58,135 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting [com.siemag.components.model.message.MessagePrototype#281280]
13:36:58,135 INFO  [com.siemag.components.server.updating.DomainInterceptor] (http-localhost-127.0.0.1-8080-4) Delete ID 281280 entity com.siemag.components.model.message.MessagePrototype@917079[Id=281280,name=CC011/1444,creationTime=Sun Jan 13 15:09:44 CET 2013]
13:36:58,135 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting a persistent instance
13:36:58,151 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting [com.siemag.components.model.message.MessagePrototype#281281]
13:36:58,151 INFO  [com.siemag.components.server.updating.DomainInterceptor] (http-localhost-127.0.0.1-8080-4) Delete ID 281281 entity com.siemag.components.model.message.MessagePrototype@1914f6[Id=281281,name=HBS/145,creationTime=Sun Jan 13 15:09:44 CET 2013]
13:36:58,634 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting a persistent instance
13:36:58,634 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting [com.siemag.components.model.message.MessagePrototype#281280]
13:36:58,634 INFO  [com.siemag.components.server.updating.DomainInterceptor] (http-localhost-127.0.0.1-8080-4) Delete ID 281280 entity com.siemag.components.model.message.MessagePrototype@adfa17[Id=281280,name=CC011/1444,creationTime=Sun Jan 13 15:09:44 CET 2013]
13:36:58,650 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting a persistent instance
13:36:58,650 TRACE [org.hibernate.event.internal.DefaultDeleteEventListener] (http-localhost-127.0.0.1-8080-4) Deleting [com.siemag.components.model.message.MessagePrototype#281281]
13:36:58,650 INFO  [com.siemag.components.server.updating.DomainInterceptor] (http-localhost-127.0.0.1-8080-4) Delete ID 281281 entity com.siemag.components.model.message.MessagePrototype@1616c73[Id=281281,name=HBS/145,creationTime=Sun Jan 13 15:09:44 CET 2013]

The strange thing here is that hibernate recognize the delete action but it doesn't excecute a delete statement on the DB.

Thanks in advance.

My runtime:

Jboss 7.1.1.Final

Hibernate 4.1.4.Final

Primefaces 3.4.2