From 31242b486869b6580b435fb2e1c1bb186be7ebee Mon Sep 17 00:00:00 2001
From: gpelletie <guy.pelletier@oracle.com>
Date: Fri, 24 May 2013 11:17:55 -0400
Subject: [PATCH] Bug 391932 - testValidateMafiaFamily123() failed in project
 cache testing

Reviewed: Yiping Zhao
---
 .../AdvancedMultiTenant123JunitTest.java           | 54 ++++++++++++++++++++++
 1 file changed, 54 insertions(+)

diff --git a/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/multitenant/AdvancedMultiTenant123JunitTest.java b/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/multitenant/AdvancedMultiTenant123JunitTest.java
index cddb4de..0ec5aa3 100644
--- a/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/multitenant/AdvancedMultiTenant123JunitTest.java
+++ b/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/multitenant/AdvancedMultiTenant123JunitTest.java
@@ -81,6 +81,60 @@ public class AdvancedMultiTenant123JunitTest extends AdvancedMultiTenantJunitTes
     public void testWriteProjectCache(){
         new org.eclipse.persistence.testing.tests.jpa.advanced.MetadataCachingTestSuite().testFileBasedProjectCacheLoading(getMULTI_TENANT_PU_123());
     }
+    
+    /**
+     * Because single PU units are tested at one time on the server, the
+     * SE testcase cannot not be used as is since static variables (of other
+     * families) will not have been populated. This validation test must be
+     * paired down.
+     */
+    @Override
+    public void testValidateMafiaFamily123() {
+        EntityManager em = create123EntityManager();
+
+        try {
+            clearCache(getMULTI_TENANT_PU_123());
+            em.clear();
+            
+            MafiaFamily family =  em.find(MafiaFamily.class, family123);
+            assertNotNull("The Mafia Family with id: " + family123 + ", was not found", family);
+            assertTrue("The Mafia Family had an incorrect number of tags [" + family.getTags().size() + "], expected [1]", family.getTags().size() == 1);
+            assertFalse("No mafiosos part of 123 family", family.getMafiosos().isEmpty());
+            
+            // Try a native sql query. Should get an exception since the
+            // eclipselink.jdbc.allow-native-sql-queries property is set to 
+            // false for this PU.
+            boolean exceptionCaught = false;
+            List mafiaFamilies = null;
+            try {
+                mafiaFamilies = em.createNativeQuery("select * from JPA_MAFIA_FAMILY").getResultList();
+            } catch (Exception e) {
+                exceptionCaught = true;
+            }
+            
+            assertTrue("No exception was caught from issuing a native query.", exceptionCaught);
+            
+            exceptionCaught = false;
+            try {
+                mafiaFamilies = em.createNamedQuery("findSQLMafiaFamilies").getResultList();
+            } catch (Exception e) {
+                exceptionCaught = true;
+            }
+            
+            assertTrue("No exception was caught from issuing a named native query.", exceptionCaught);
+            
+            // Try a select named query
+            List families = em.createNamedQuery("findAllMafiaFamilies").getResultList();
+            assertTrue("Incorrect number of families were returned [" + families.size() + "], expected [1]",  families.size() == 1);
+        } catch (RuntimeException e) {
+            if (isTransactionActive(em)){
+                rollbackTransaction(em);
+            }
+            throw e;
+        } finally {
+            closeEntityManager(em);
+        }
+    }
 
     public void testComplexMultitenantQueries() {
         EntityManager em = createEntityManager(getMULTI_TENANT_PU_123());
-- 
1.7.11.msysgit.1