Examples of OpenJPAQuery

org.apache.openjpa.persistence.OpenJPAQuery
Interface implemented by OpenJPA queries. @since 0.4.0 @author Abe White @published

Examples of org.apache.openjpa.persistence.OpenJPAQuery

    public void setUp() {
        setUp(SimpleEntity.class);
    }


    public void testMethodQLWithoutParametersDeclared() {
        OpenJPAQuery q = em.createQuery(QueryLanguages.LANG_METHODQL,
            getClass().getName() + ".echo");
        ((QueryImpl) q).getDelegate().setCandidateType(
            SimpleEntity.class, true);
        q.setParameter("param", 5);
        ((QueryImpl) q).getDelegate().declareParameters("Integer param");
        assertEquals(5, q.getResultList().get(0));
    }

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery

        ((QueryImpl) q).getDelegate().declareParameters("Integer param");
        assertEquals(5, q.getResultList().get(0));
    }


    public void testInvalidMethodReturnType() {
        OpenJPAQuery q = em.createQuery(QueryLanguages.LANG_METHODQL,
            getClass().getName() + ".invalidReturnMeth");
        ((QueryImpl) q).getDelegate().setCandidateType(
            SimpleEntity.class, true);
        try {
            q.getResultList().get(0);
            fail("should have gotten an exception since method is invalid");
        } catch (ArgumentException ae) {
            // expected
        }
    }

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery

            // expected
        }
    }


    public void testVoidMethodReturnType() {
        OpenJPAQuery q = em.createQuery(QueryLanguages.LANG_METHODQL,
            getClass().getName() + ".voidMeth");
        ((QueryImpl) q).getDelegate().setCandidateType(
            SimpleEntity.class, true);
        try {
            q.getResultList().get(0);
            fail("should have gotten an exception since method is invalid");
        } catch (ArgumentException ae) {
            // expected
        }
    }

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery


    public void testEagerOwnerOneToManyQuery() {
        sql.clear();


        OpenJPAEntityManager em = emf.createEntityManager();
        OpenJPAQuery q = em.createQuery("SELECT o FROM BidiParent o "
            + "ORDER BY o.name ASC");
        q.getFetchPlan().addField(BidiParent.class, "oneToManyChildren");
        q.getFetchPlan().addField(BidiChild.class, "oneToManyParent");
        List<BidiParent> res = (List<BidiParent>) q.getResultList(); 


        assertEquals(2, res.size());
        assertEquals(sql.toString(), 2, sql.size());
        assertNotSQL(".* LEFT OUTER JOIN BidiParent .*");

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery


    public void testEagerOwnerOneToOneQuery() {
        sql.clear();


        OpenJPAEntityManager em = emf.createEntityManager();
        OpenJPAQuery q = em.createQuery("SELECT o FROM BidiParent o "
            + "ORDER BY o.name ASC");
        q.getFetchPlan().addField(BidiParent.class, "oneToOneChild");
        q.getFetchPlan().addField(BidiChild.class, "oneToOneParent");
        List<BidiParent> res = (List<BidiParent>) q.getResultList(); 


        assertEquals(2, res.size());
        assertEquals(1, sql.size());
        assertNotSQL(".* LEFT OUTER JOIN BidiParent .*");

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery


    public void testEagerNonOwnerOneToOneQuery() {
        sql.clear();


        OpenJPAEntityManager em = emf.createEntityManager();
        OpenJPAQuery q = em.createQuery("SELECT o FROM BidiParent o "
            + "ORDER BY o.name ASC");
        q.getFetchPlan().addField(BidiParent.class, "oneToOneChild");
        q.getFetchPlan().addField(BidiChild.class, "oneToManyParent");
        List<BidiParent> res = (List<BidiParent>) q.getResultList(); 


        assertEquals(2, res.size());
        assertEquals(1, sql.size());
        assertSQL(".* LEFT OUTER JOIN BidiParent .*");

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery

                    q.setHint("openjpa.hint.OptimizeResultCount"
                         ,new Integer(8));
                    q.getResultList();
                }    
                else {
                    OpenJPAQuery q =  OpenJPAPersistence.cast (em.createQuery 
                        ("select o from AllFieldTypes o where o.intField " +
                         "= :p"));
                    q.setParameter("p", 0);
                    q.setHint(q.HINT_RESULT_COUNT, new Integer(8)); 
                    q.getResultList();
               }     
               if (dict instanceof DB2Dictionary) {
                   assertEquals(1, sql.size());
                   assertSQL("SELECT t0.id, t0.booleanField, t0.byteField," +
                       " t0.charField, t0.dateField, t0.doubleField, " +

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery

     * @return the Query object
     */
    protected OpenJPAQuery query(Class c, String str, Object... params) {
        String query = "select x from " + entityName(emf, c) + " x "
            + (str == null ? "" : str);
        OpenJPAQuery q = em.createQuery(query);
        for (int i = 0; params != null && i < params.length; i++)
            q.setParameter(i + 1, params[i]);
        return q;
    }

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery

        OpenJPAEntityManager pm1 = getEm(true, true);
        OpenJPAEntityManager pm2 = getEm(true, true);
        
        // have to load via query or extent where we're selecting the vertical
        // field in the initial SELECT
        OpenJPAQuery q1 = pm1.createNativeQuery("",StateImagePC2.class);
        //FIXME  jthomas
        //q1.setOrdering("intField ascending");
        StateImagePC2 pc1 = (StateImagePC2) ((Collection) q1.getCandidateCollection()).
                iterator().next();
        q1.closeAll();
        
        OpenJPAQuery q2 = pm2.createNativeQuery("",StateImagePC2.class);
        //FIXME jthomas
        //q2.setOrdering("intField ascending");
        StateImagePC2 pc2 = (StateImagePC2) ((Collection) q2.getCandidateCollection()).
                iterator().next();
        q2.closeAll();
        
        pm1.getTransaction().begin();
        pc1.setStringField("changed1");
        pc1.setStateImage(null);

View Full Code Here

Examples of org.apache.openjpa.persistence.OpenJPAQuery

    }


    public void testProjections()
        throws Exception {
        OpenJPAEntityManager pm =(OpenJPAEntityManager)currentEntityManager();
        OpenJPAQuery q = pm.createNativeQuery("",Relations.class);
        //FIXME jthomas
        /*
        q.setResult("base, baseSub1, baseSub1Sub2");
        q.setUnique(true);
        Object[] res = (Object[]) q.execute();

View Full Code Here

0 1 2 3 4 5

TOP

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.