================================== Trace output of testDeleteViaQueryRemovesDataCacheImage()  ===================================


	public void testDeleteViaQueryRemovesDataCacheImage() {
		assertEquals("true", getProprtyValue("openjpa.DataCache"));
		boolean useQuery = true;
		createDeleteFind(useQuery);
	}

	/**
	 * Ensure that the object will be in L2 cache, if one is available.
	 * Delete the object and expect em.find() not to find the object. 
	 *
	 */
	void createDeleteFind(boolean useQuery) {
		OpenJPAEntityManager em = getEM();
		em.begin();
		PObject pc = new PObject("DeleteMe");
		em.persist(pc);
		Object oid = em.getObjectId(pc);
		em.commit();
		
		em.begin();
		List result = em.createQuery("SELECT o FROM PObject o").getResultList();
		assertFalse(result.isEmpty());
		assertTrue(result.contains(pc));
		for (Object x:result) ((PObject)x).setName("DeleteMe");
		if (useQuery) {
			em.createQuery("DELETE FROM PObject o").executeUpdate();
		} else {
			em.remove(pc);
		}
		em.commit();

		em.begin();
		result = em.createQuery("SELECT o FROM PObject o").getResultList();
		assertTrue(result.isEmpty());
		em.commit();
		em.clear();
		
		em.begin();
		em.lock(pc);
		pc.setName("I am a ghost");
		assertTrue(em.getManagedObjects().isEmpty());
		assertFalse(em.getManagedObjects().contains(pc));
		Object ghost = em.find(PObject.class, oid);
		assertNull(ghost);
		em.rollback();
	}

=========================================================================================

1682  test  TRACE  [main] openjpa.jdbc.SQL - <t 6597453, conn 33385450> executing prepstmnt 17652030 SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [params=(int) 0]
1692  test  TRACE  [main] openjpa.jdbc.SQL - <t 6597453, conn 33385450> executing prepstmnt 16711231 UPDATE OPENJPA_SEQUENCE_TABLE SET SEQUENCE_VALUE = ? WHERE ID = ? AND SEQUENCE_VALUE = ? [params=(long) 4551, (int) 0, (long) 4501]
1802  test  TRACE  [main] openjpa.jdbc.JDBC - <t 6597453, conn 33385450> [100 ms] commit

1842  test  TRACE  [main] openjpa.jdbc.SQL - <t 6597453, conn 7812797> executing prepstmnt 25229676 INSERT INTO PObject (id, name) VALUES (?, ?) [params=(long) 4501, (String) DeleteMe]
1912  test  TRACE  [main] openjpa.jdbc.JDBC - <t 6597453, conn 7812797> [70 ms] commit

1912  test  TRACE  [main] openjpa.DataCache - Cache miss while looking up key "test.PObject-4501".
1912  test  TRACE  [main] openjpa.DataCache - Performing a commit on the cache. Adding [test.PObject-4501], updating [] and [], and removing [].

2103  test  TRACE  [main] openjpa.Query - Executing query: SELECT o FROM PObject o
2103  test  TRACE  [main] openjpa.DataCache - Cache miss while looking up key "org.apache.openjpa.datacache.QueryKey@542c6ea5[query:[SELECT o FROM PObject o],access path:[test.PObject],subs:true,ignoreChanges:false,startRange:0,endRange:9223372036854775807,timeout:-1]".
2183  test  TRACE  [main] openjpa.jdbc.SQL - <t 6597453, conn 12644844> executing prepstmnt 701508 SELECT t0.id, t0.name FROM PObject t0
2193  test  TRACE  [main] openjpa.DataCache - Cache hit while looking up key "test.PObject-4501".
2193  test  TRACE  [main] openjpa.DataCache - Put key "org.apache.openjpa.datacache.QueryKey@542c6ea5[query:[SELECT o FROM PObject o],access path:[test.PObject],subs:true,ignoreChanges:false,startRange:0,endRange:9223372036854775807,timeout:-1]" into cache.
2203  test  TRACE  [main] openjpa.Query - Executing query: DELETE FROM PObject o
2233  test  TRACE  [main] openjpa.jdbc.SQL - <t 6597453, conn 15775736> executing prepstmnt 7052420 DELETE FROM PObject
2323  test  TRACE  [main] openjpa.jdbc.JDBC - <t 6597453, conn 15775736> [90 ms] commit

2323  test  TRACE  [main] openjpa.Query - Executing query: SELECT o FROM PObject o
2323  test  TRACE  [main] openjpa.DataCache - Cache miss while looking up key "org.apache.openjpa.datacache.QueryKey@542c6ea5[query:[SELECT o FROM PObject o],access path:[test.PObject],subs:true,ignoreChanges:false,startRange:0,endRange:9223372036854775807,timeout:-1]".
2353  test  TRACE  [main] openjpa.jdbc.SQL - <t 6597453, conn 24267421> executing prepstmnt 26506390 SELECT t0.id, t0.name FROM PObject t0
2353  test  TRACE  [main] openjpa.DataCache - Put key "org.apache.openjpa.datacache.QueryKey@542c6ea5[query:[SELECT o FROM PObject o],access path:[test.PObject],subs:true,ignoreChanges:false,startRange:0,endRange:9223372036854775807,timeout:-1]" into cache.
2363  test  TRACE  [main] openjpa.DataCache - Cache hit while looking up key "test.PObject-4501".
2373  test  TRACE  [main] openjpa.DataCache - Cache hit while looking up key "test.PObject-4501".
2373  test  TRACE  [main] openjpa.DataCache - Cache hit while looking up key "test.PObject-4501".