Package org.apache.openjpa.persistence

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

173
174
175
176
177
178
179
180
181
182
183
        em = (OpenJPAEntityManager) currentEntityManager();
        startTx(em);

        String query =
            "SELECT r FROM RuntimeTest2 r WHERE r.stringField = \'TestQueryResults1\'";
        List c = em.createQuery(query).getResultList();

        assertEquals(1, c.size());
        endTx(em);
        endEm(em);
    }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
            (OpenJPAEntityManager) currentEntityManager();
        startTx(em);

        String query =
            "SELECT DISTINCT r FROM RuntimeTest1 r WHERE r.stringField = \'TestQueryResults1\'";
        Object obj = em.createQuery(query).getSingleResult();

        assertTrue(obj instanceof RuntimeTest1);

        query =
            "SELECT DISTINCT r FROM RuntimeTest1 r WHERE r.stringField = \'xxxx\'";
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
        assertTrue(obj instanceof RuntimeTest1);

        query =
            "SELECT DISTINCT r FROM RuntimeTest1 r WHERE r.stringField = \'xxxx\'";
        OpenJPAQuery q = em.createQuery(query);
        List l = q.getResultList();
        assertNotNull(
            "expecting l to be null since there is no RuntimeTest1 instance with stringfield=xxxx",
            l);
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
    public void testUniqueThrowsExceptionIfMultipleResults() {
        OpenJPAEntityManager em =
            (OpenJPAEntityManager) currentEntityManager();
        startTx(em);
        String query = "SELECT DISTINCT r FROM RuntimeTest1 r";
        OpenJPAQuery q = em.createQuery(query);

        try {
            Object l = q.getSingleResult();
            fail("Unique query matched multiple results.");
        }
View Full Code Here
287
288
289
290
291
292
293
294
295
296
297
    public void testImpossibleRangeReturnsEmptyList() {
        OpenJPAEntityManager em =
            (OpenJPAEntityManager) currentEntityManager();
        startTx(em);
        String query = "SELECT r FROM RuntimeTest1 r";
        OpenJPAQuery q = em.createQuery(query);
        q.setFirstResult(2);
        q.setMaxResults(0);

        List results = q.getResultList();
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
    public void testImpossibleUniqueRangeReturnsNull() {
        OpenJPAEntityManager em =
            (OpenJPAEntityManager) currentEntityManager();
        startTx(em);

        OpenJPAQuery q = em.createQuery(
            "SELECT DISTINCT r FROM RuntimeTest1 r WHERE r.stringField = \'TestQueryResults1\'");
        q.setFirstResult(2);
        q.setMaxResults(0);
        assertTrue(
            "resultlist is not null its size is: " + q.getResultList().size(),
View Full Code Here
322
323
324
325
326
327
328
329
330
331
332
    public void testSingleResultUniqueRange() {
        OpenJPAEntityManager em =
            (OpenJPAEntityManager) currentEntityManager();
        startTx(em);

        OpenJPAQuery q = em.createQuery(
            "SELECT DISTINCT r FROM RuntimeTest1 r WHERE r.stringField = \'TestQueryResults1\'");
        q.setFirstResult(1);
        q.setMaxResults(1000000);

        assertTrue("resultlist is not empty", (q.getResultList()).isEmpty());
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
    public void testMultiResultUniqueRange() {
        OpenJPAEntityManager em =
            (OpenJPAEntityManager) currentEntityManager();
        startTx(em);

        OpenJPAQuery q = em.createQuery(
            "SELECT DISTINCT r FROM RuntimeTest1 r ORDER BY r.stringField ASC");
        q.setFirstResult(1);
        q.setMaxResults(2);

        assertEquals("TestQueryResults2",
View Full Code Here
381
382
383
384
385
386
387
388
389
390
391
        try {
            OpenJPAEntityManager em =
                (OpenJPAEntityManager) currentEntityManager();
            startTx(em);

            OpenJPAQuery q = em.createQuery(
                "SELECT r FROM RuntimeTest1 ORDER BY r.stringField ASC");
            q.setSubclasses(false);
            q.setFirstResult(0);
            Long l = new Long(Long.MAX_VALUE);
            q.setMaxResults(l.intValue());
View Full Code Here
409
410
411
412
413
414
415
416
417
418
419
        try {
            OpenJPAEntityManager em =
                (OpenJPAEntityManager) currentEntityManager();
            startTx(em);

            OpenJPAQuery q = em.createQuery(
                "SELECT r FROM RuntimeTest1 ORDER BY r.stringField ASC");
            q.setFirstResult(0);
            Long l = new Long(Long.MAX_VALUE);
            q.setMaxResults(l.intValue());
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.