Query after JPA collective update not getting updates

[Oliver Chua]

Hi All,

I am using JPA on JSE.
I've added two records in the table, updated both records collectively,
and then retrieved both records to check they've been updated.

I've tried debugging, and the database is updated after the commit,
but the select doesn't return the newer versions.
If I get a new entity manager and use it to query, it passes.

Is there an explanation for this behavior
and is there a fix or a workaround without getting a new entity manager?

Thanks

    public void testCollectiveUpdate() {
	SimpleEntity e1 = new SimpleEntity();
	e1.setStringField("String");
	EntityManager em = JPAUtil.getEm();
	em.getTransaction().begin();
	em.persist(e1);
	e1 = new SimpleEntity();
	e1.setStringField("String");
	em.persist(e1);
	em.getTransaction().commit();

	em.getTransaction().begin();
	Query q = em
		.createQuery("UPDATE Individual_Simple_Entity1 SET stringField = ?");
	q.setParameter(1, "new String");
	q.executeUpdate();
	em.getTransaction().commit();

	//TODO Why cached result being returned? 
	//em = JPAUtil.getEm();
	q = em.createQuery("SELECT e FROM Individual_Simple_Entity1 e");
	List<SimpleEntity> list = JPAUtil.castList(SimpleEntity.class, q
		.getResultList());
	for (SimpleEntity simpleEntity : list) {
	    assertEquals("new String", simpleEntity.getStringField());
	}
    }

package util;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

import org.hibernate.HibernateException;

public class JPAUtil {
    private static final EntityManagerFactory emf;
    static {
	try {
	    emf = Persistence.createEntityManagerFactory("jpaSandbox");

	} catch (Throwable ex) {
	    // Log exception!
	    throw new ExceptionInInitializerError(ex);
	}
    }

    public static EntityManager getEm() throws HibernateException {
	return emf.createEntityManager();
    }
    
    /**
     * Taken from
     * http://stackoverflow.com/questions/367626/how-do-i-fix-the-expression
     * -of-type-list-needs-unchecked-conversion
     */
    public static <T> List<T> castList(Class<? extends T> clazz, Collection<?> c) {
	List<T> list = new ArrayList<T>(c.size());
	for (Object o : c)
	    list.add(clazz.cast(o));
	return list;
    }
}

package individual.simple;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity(name = "Individual_Simple_Entity1")
public class SimpleEntity {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    // Uses 255 as default length
    private String stringField;

    public Long getId() {
	return id;
    }

    public void setId(Long id) {
	this.id = id;
    }

    public String getStringField() {
	return stringField;
    }

    public void setStringField(String stringField) {
	this.stringField = stringField;
    }

}

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
	version="2.0">
	<persistence-unit name="jpaSandbox" transaction-type="RESOURCE_LOCAL">
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
			<property name="hibernate.hbm2ddl.auto" value="create-drop" />
			<property name="javax.persistence.jdbc.driver" value="oracle.jdbc.driver.OracleDriver" />
			<property name="javax.persistence.jdbc.url" value="jdbc:oracle:thin:@localhost:1521:XE" />
			<property name="javax.persistence.jdbc.user" value="jpasandbox" />
			<property name="javax.persistence.jdbc.password" value="jpasandbox" />
			<property name="hibernate.cache.use_second_level_cache"
				value="true" />
			<property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider" />
		</properties>
	</persistence-unit>
</persistence>