[eclipselink-users] EntityManager.remove does not remove entity from cac

[Mike Traum <Mike.Traum@xxxxxxxx>]

I have the following enitiy map:
A->B->C (where -> represents a OneToMany relationship)

If I do a EntityManager.remove on a B, a following Query (select all) 
will still return that entity, even though it has been removed from the 
database.

Any ideas on the proper way to handle this?

Here's some code illustrating the issue:
   EntityManager em = emf.createEntityManager();
   Query q = em.createQuery("select a FROM A a");
   List<A> as = q.getResultList();
   em.clear();
   em.close();
   System.out.println(as.get(0).getChildren().size()); // output is 2
  
   B b = as.get(0).getChildren().get(0);
  
   em = emf.createEntityManager();
   em.getTransaction().begin();
   B bm = em.merge(b);
   em.remove(bm);
   em.getTransaction().commit(); // successfully removes B and children 
from database
   em.clear();
   em.close();

   em = emf.createEntityManager();
   q = em.createQuery("select a FROM A a");
   as = q.getResultList();
   em.clear();
   em.close();
   System.out.println(as.get(0).getChildren().size()); // output is 2
  
   em = emf.createEntityManager();
   q = em.createQuery("select a FROM A a");
   
((ReadAllQuery)((EJBQueryImpl)q).getDatabaseQuery()).refreshIdentityMapResult();
   as = q.getResultList();
   em.clear();
   em.close();
   System.out.println(as.get(0).getChildren().size()); // output is 1


Thanks,
Mike