Package org.apache.openjpa.persistence

Examples of org.apache.openjpa.persistence.OpenJPAEntityManagerSPI.createQuery()

62
63
64
65
66
67
68
69
70
71
72
        // Make sure that our sql listener is working
        assertTrue(_sql.size() > 0);
        _sql.clear();
       
        q = em.createQuery(query);
        q.setParameter(1, 100000);
        q.getResultList();
       
        // Make sure that we execute sql. This means that the query was properly kicked out of the cache.
        assertEquals(1, _sql.size());
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
              allFieldTypes.setStringField("testString");
              allFieldTypes.setIntField(2012);
             
              em.getTransaction().begin();
              em.persist(allFieldTypes);
              Query query = em.createQuery("select e from AllFieldTypes e where e.stringField = ?1");
              query.setParameter(1, "testString");
              query.setHint("openjpa.FetchPlan.Isolation", "READ_UNCOMMITTED");
              assertEquals(1, query.getResultList().size());
              assertContainsSQL("FOR READ ONLY WITH UR");
              em.getTransaction().rollback();
View Full Code Here
828
829
830
831
832
833
834
835
836
837
838
        OpenJPAEntityManagerSPI em = emf.createEntityManager();

        // Query and verify the result
        String queryString = "SELECT w FROM Course c JOIN c.waitList w " +
            "WHERE c.name = :cname AND INDEX(w) = :widx";
        Query qry = em.createQuery(queryString);
        qry.setParameter("widx", 0);
        qry.setParameter("cname", "Course B");
        Student idx0 = (Student)qry.getSingleResult();
        assertNotNull(idx0);
        assertEquals(idx0, students[10]);
View Full Code Here
865
866
867
868
869
870
871
872
873
874
875
        OpenJPAEntityManagerSPI em = emf.createEntityManager();

        // Query and verify the result
        String queryString = "SELECT INDEX(w) FROM Course c JOIN c.waitList w" +
            " WHERE c.name = :cname ORDER BY w";
        Query qry = em.createQuery(queryString);
        qry.setParameter("cname", "Course A");
        List rlist = qry.getResultList();      
        assertNotNull(rlist);
        assertEquals(2, rlist.size());
        assertEquals(0l, rlist.get(0));
View Full Code Here
875
876
877
878
879
880
881
882
883
884
885
        assertEquals(0l, rlist.get(0));
        assertEquals(1l, rlist.get(1));

        queryString = "SELECT INDEX(w) FROM Course c JOIN c.waitList w" +
            " WHERE c.name = :cname AND w.name = 'Student11'";
        qry = em.createQuery(queryString);
        qry.setParameter("cname", "Course B");
        Long idx = (Long)qry.getSingleResult();      
        assertNotNull(idx);
        assertEquals((Long)idx, (Long)1L);
       
View Full Code Here
240
241
242
243
244
245
246
247
248
249
250
        assertNotNull(user);
        assertEquals("Famzy", user.getName());

        String query = "UPDATE CompUser e SET e.name = LOWER(e.name) WHERE LOWER(e.nameAsLob)='famzy'";

        int result = em.createQuery(query).executeUpdate();

        user = em.find(CompUser.class, userid5);
        em.refresh(user);
        assertNotNull(user);
        assertEquals("famzy", user.getName());
View Full Code Here
289
290
291
292
293
294
295
296
297
298
299
        assertNotNull(user);
        assertEquals("Famzy", user.getName());

        String query = "UPDATE CompUser e SET e.name = UPPER(e.name) WHERE UPPER(e.nameAsLob)='FAMZY'";

        int result = em.createQuery(query).executeUpdate();

        user = em.find(CompUser.class, userid5);
        em.refresh(user);
        assertNotNull(user);
        assertEquals("FAMZY", user.getName());
View Full Code Here
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
            em.setQuerySQLCache(useCache);
            assertEquals(useCache, em.getQuerySQLCache());
           
            // measure time
            long start = System.nanoTime();
            OpenJPAQuery<?> q = isNamedQuery ? em.createNamedQuery(jpql) : em.createQuery(jpql);
            parameterize(q, params);
            List<?> list = q.getResultList();
            if (expectedCount >= 0)
                assertEquals(expectedCount, list.size());
            else
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        // Clean up persistence context.
        em.clear();

        // Populate query cache
        for (int i = 0; i < cacheSize + 1; i++) {
            em.createQuery(QUERY + i, CachedPerson.class).getSingleResult();
        }

        Set<?> keys = cache.getCacheMap().keySet();
        assertEquals(cacheSize, keys.size());
        List<String> strKeys = new ArrayList<String>();
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
        oem.getTransaction().begin();
        oem.persist(ce);
        oem.persist(ce2);
        oem.getTransaction().commit();
      
        Query q = oem.createQuery("SELECT ce FROM CachedEntity ce");
       
        List<?> result = q.getResultList();
        assertNotNull(result);
        assertTrue(result.size() > 1);
        oem.clear();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.