Package org.apache.openjpa.kernel

Examples of org.apache.openjpa.kernel.Query


        }
    }

    private void loadQuery(Broker broker, QueryMetaData qmd) {
        try {
            Query q = broker.newQuery(qmd.getLanguage(), null);
            qmd.setInto(q);
            q.compile();
        } catch (Exception e) {
            if (log.isTraceEnabled()) {
                log.warn("Skipping named query " + qmd.getName() + ": "
                    + e.getMessage(), e);
            } else {
View Full Code Here


        super(name);
    }

    public void testSimpleSubqueryAccessPath() {
        Broker broker = getBrokerFactory().newBroker();
        Query q = broker.newQuery(JPQLParser.LANG_JPQL,
            "SELECT o FROM RuntimeTest1 o WHERE EXISTS ("
            + "SELECT rt5.name FROM RuntimeTest5 rt5 "
            + "WHERE rt5.name IS NOT NULL)");
        ClassMetaData[] metas = q.getAccessPathMetaDatas();
        Collection c = Arrays.asList(metas);
        ClassMetaData rt1 = broker.getConfiguration().
            getMetaDataRepositoryInstance().getMetaData(RuntimeTest1.class,
            broker.getClassLoader(), true);
        ClassMetaData rt5 = broker.getConfiguration().
View Full Code Here

        assertEquals(2, c.size());
    }

    public void testRelationTraversalSubqueryAccessPath() {
        Broker broker = getBrokerFactory().newBroker();
        Query q = broker.newQuery(JPQLParser.LANG_JPQL,
            "SELECT o FROM RuntimeTest1 o WHERE EXISTS ("
            + "SELECT rt5.runtimeTest4.name FROM RuntimeTest5 rt5 "
            + "WHERE rt5.name IS NOT NULL)");

        ClassMetaData[] metas = q.getAccessPathMetaDatas();
        Collection c = Arrays.asList(metas);
        ClassMetaData rt1 = broker.getConfiguration().
            getMetaDataRepositoryInstance().getMetaData(RuntimeTest1.class,
            broker.getClassLoader(), true);
        ClassMetaData rt4 = broker.getConfiguration().
View Full Code Here

        return em.createQuery(QueryLanguages.LANG_METHODQL, methodName);
    }
   
    public void testMethodQLWithParameters() {
        OpenJPAQuery q = createMethodQuery("echo");
        Query kernelQ = q.unwrap(Query.class);
        kernelQ.declareParameters("String firstName, String lastName");
        q.setParameter("firstName", "Fred").setParameter("lastName", "Lucas");
        Object result = q.getResultList().get(0);
        assertTrue(result instanceof Map);
        Map params = (Map)result;
        assertEquals("Fred", params.get("firstName"));
View Full Code Here

        rawHelper(false, Object[].class, "age, a.name", false);
    }

    private void arrayHelper(boolean unique, Collection recordClasses,
        Collection results, boolean inCache) {
        Query q = setUpQuery(unique, results);
        q.setResultType(Object[].class);
        if (unique) {
            arrayResultHelper(q.execute(), recordClasses, inCache);
        } else {
            for (Iterator iter = ((List) q.execute()).iterator(); iter
                .hasNext();)
                arrayResultHelper(iter.next(), recordClasses, inCache);
        }

        CacheTestHelper.assertInCache(this, q, new Boolean(inCache));

        if (unique) {
            arrayResultHelper(q.execute(), recordClasses, inCache);
        } else {
            for (Iterator iter = ((List) q.execute()).iterator(); iter
                .hasNext();)
                arrayResultHelper(iter.next(), recordClasses, inCache);
        }
    }
View Full Code Here

            assertEquals(((ArrayList) recordClasses).get(i), os[i].getClass());
    }

    private void mapHelper(boolean unique, Collection recordClasses,
        Collection results, boolean inCache) {
        Query q = setUpQuery(unique, results);
        System.out.println("Query String " + q.getQueryString());
        Collection coll = null;
        if (q.execute() != null && (q.execute() instanceof Collection)) {
            coll = (Collection) q.execute();
        }
        System.out.println("Type of q.execute is : " + q.execute().getClass());

        Iterator it = coll.iterator();
        while (it.hasNext())
            System.out.println("Query result is " + it.next().getClass());

        q.setResultType(HashMap.class);

        if (unique) {
            mapResultHelper(q.execute(), recordClasses, results, inCache);
        } else {
            for (Iterator iter = ((Collection) q.execute()).iterator();
                iter.hasNext();)
                mapResultHelper(iter.next(), recordClasses, results, inCache);
        }

        CacheTestHelper.assertInCache(this, q, new Boolean(inCache));

        if (unique) {
            mapResultHelper(q.execute(), recordClasses, results, inCache);
        } else {
            for (Iterator iter = ((List) q.execute()).iterator(); iter
                .hasNext();)
                mapResultHelper(iter.next(), recordClasses, results, inCache);
        }
    }
View Full Code Here

    private void rawHelper(boolean unique, Class recordClass, String result,
        boolean inCache) {
        ArrayList<String> l = new ArrayList<String>();
        l.add(result);
        Collection res = (result == null) ? null : l;
        Query q = setUpQuery(unique, res);
        if (unique)
            assertEquals(recordClass, q.execute().getClass());
        else {
            q.setUnique(unique);
            for (Iterator iter = ((List) q.execute()).iterator(); iter
                .hasNext();)
                assertEquals(recordClass, iter.next().getClass());
        }

        CacheTestHelper.assertInCache(this, q, new Boolean(inCache));

        if (unique) {
            assertEquals(recordClass, q.execute().getClass());
        } else {
            for (Iterator iter = ((List) q.execute()).iterator(); iter
                .hasNext();)
                assertEquals(recordClass, iter.next().getClass());
        }
    }
View Full Code Here

        }

        if (unique)
            filter += " where a.age = 0";
        System.out.println("****Query: " + filter);
        Query q = _broker.newQuery(JPQLParser.LANG_JPQL, filter);
        q.setUnique(unique);
        q.setCandidateType(CacheObjectAChild1.class, false);

        return q;
    }
View Full Code Here

        super(test, "datacachecactusapp");
    }

    public void testQueryResultTypesWithThis() {
        Broker broker = getBroker();
        Query q =
            broker.newQuery(JPQLParser.LANG_JPQL, "select a.name,a FROM " +
                CacheObjectA.class.getSimpleName() + " a");

        Class[] types = q.getProjectionTypes();
        assertEquals(2, types.length);
        assertEquals(String.class, types[0]);
        assertEquals(CacheObjectA.class, types[1]);
    }
View Full Code Here

        assertEquals(CacheObjectA.class, types[1]);
    }

    public void testQueryResultTypesWithRelated() {
        Broker broker = getBroker();
        Query q = broker
            .newQuery(JPQLParser.LANG_JPQL, "select a.name,a.relatedB FROM " +
                CacheObjectA.class.getSimpleName() + " a");

        //CacheObjectA.class,           "select name, relatedB");
        Class[] types = q.getProjectionTypes();
        assertEquals(2, types.length);
        assertEquals(String.class, types[0]);
        assertEquals(CacheObjectB.class, types[1]);
    }
View Full Code Here

TOP

Related Classes of org.apache.openjpa.kernel.Query

Copyright © 2018 www.massapicom. 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.