svn commit: r741745 - /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/TestOptimizeForClause.java

[fancy]

Author: fancy
Date: Fri Feb  6 21:43:53 2009
New Revision: 741745

URL: http://svn.apache.org/viewvc?rev=741745&view=rev
Log:
OPENJPA-703 fix TestOptimizeForClause testcase

Modified:
    
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/TestOptimizeForClause.java

Modified: 
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/TestOptimizeForClause.java
URL: 
http://svn.apache.org/viewvc/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/TestOptimizeForClause.java?rev=741745&r1=741744&r2=741745&view=diff
==============================================================================
--- 
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/TestOptimizeForClause.java
 (original)
+++ 
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/TestOptimizeForClause.java
 Fri Feb  6 21:43:53 2009
@@ -43,20 +43,22 @@
         OpenJPAEntityManagerSPI em = emf.createEntityManager();
         DBDictionary dict = ((JDBCConfiguration) em.getConfiguration())
             .getDBDictionaryInstance();
+        
+        em.getTransaction().begin();
+        AllFieldTypes a = new AllFieldTypes();
+        a.setIntField(123);
+        em.persist(a);
+        em.getTransaction().commit();
+        em.clear();
 
         sql.clear();
-
-        try {
-            Object result = em.createQuery
-                ("select o from AllFieldTypes o where o.intField = 0").
-                getSingleResult();
-
-            assertNull(result);
-            if (dict instanceof DB2Dictionary ) {
-                assertContainsSQL(" optimize for 1 row");
-            }
-        } catch (NoResultException pe) {
-            ;
+        Object result = em.createQuery
+            ("select o from AllFieldTypes o where o.intField = 123").
+            getSingleResult();
+
+        assertNotNull(result);
+        if (dict instanceof DB2Dictionary ) {
+            assertContainsSQL(" optimize for 1 row");
         }
         em.close();
     }