Examples of org.odmg.OQLQuery.create()

org.odmg.OQLQuery.create()
Create an OQL query from the string parameter. In order to execute a query, an OQLQuery object must be created by calling Implementation.newOQLQuery, then calling the create method with the query string. The create method might throw QueryInvalidException if the query could not be compiled properly. Some implementations may not want to compile the query before execute is called. In this case QueryInvalidException is thrown when execute is called. @param query An OQL query. @exception QueryInvalidException The query syntax is invalid.

                "select anArticle from " + Article.class.getName() + " where productGroup.groupName like \"Fruit*\"");
        List results = (List) query.execute();


        // crosscheck
        query = odmg.newOQLQuery();
        query.create("select aPG from " + ProductGroup.class.getName() + " where groupName like \"Fruit*\"");
        List check = (List) query.execute();
        if (check.size() < 1)
            fail("Could not found ProductGroup's for: " +
                    "select aPG from " + ProductGroup.class.getName() + " where groupName like \"Fruit*\"");
        ProductGroup pg = (ProductGroup) check.get(0);

View Full Code Here

        query.bind(name + "%");
        result = (Collection) query.execute();
        assertEquals(6, result.size());


        query = odmg.newOQLQuery();
        query.create("select objects from " + Executive.class.getName()+" where name like $1");
        query.bind(name + "%");
        result = (Collection) query.execute();
        assertEquals(5, result.size());


        query = odmg.newOQLQuery();

View Full Code Here

        query.bind(name + "%");
        result = (Collection) query.execute();
        assertEquals(5, result.size());


        query = odmg.newOQLQuery();
        query.create("select objects from " + Manager.class.getName()+" where name like $1");
        query.bind(name + "%");
        result = (Collection) query.execute();
        assertEquals(3, result.size());
    }

View Full Code Here

        TransactionExt tx = (TransactionExt) odmg.newTransaction();
        tx.begin();
        tx.getBroker().clearCache();


        OQLQuery query = odmg.newOQLQuery();
        query.create("select objects from " + Employee.class.getName()+" where name like $1");
        query.bind(name + "%");
        Collection result = (Collection) query.execute();
        assertEquals(6, result.size());
        for(Iterator iterator = result.iterator(); iterator.hasNext();)
        {

View Full Code Here

            assertNotNull(obj.getName());
        }


        tx.getBroker().clearCache();
        query = odmg.newOQLQuery();
        query.create("select objects from " + Executive.class.getName()+" where name like $1");
        query.bind(name + "%");
        result = (Collection) query.execute();
        assertEquals(5, result.size());
        for(Iterator iterator = result.iterator(); iterator.hasNext();)
        {

View Full Code Here

            assertNotNull(obj.getName());
        }


        tx.getBroker().clearCache();
        query = odmg.newOQLQuery();
        query.create("select objects from " + Manager.class.getName()+" where name like $1");
        query.bind(name + "%");
        result = (Collection) query.execute();
        assertEquals(3, result.size());
        for(Iterator iterator = result.iterator(); iterator.hasNext();)
        {

View Full Code Here

        prepareForQueryTests(name);
        TransactionExt tx = (TransactionExt) odmg.newTransaction();
        tx.begin();
        tx.getBroker().clearCache();
        OQLQuery query = odmg.newOQLQuery();
        query.create("select objects from " + Manager.class.getName()+" where name like $1 and department like $2");
        query.bind(name + "%");
        query.bind("none");
        Collection result = (Collection) query.execute();
        tx.commit();
        assertEquals(1, result.size());

View Full Code Here


        TransactionExt tx = (TransactionExt) odmg.newTransaction();
        tx.begin();
        tx.getBroker().clearCache();
        OQLQuery query = odmg.newOQLQuery();
        query.create("select objects from " + Employee.class.getName()+" where name like $1 and address.street like $2");
        query.bind(name + "%");
        query.bind("%valley");
        Collection result = (Collection) query.execute();
        tx.commit();

View Full Code Here


        TransactionExt tx = (TransactionExt) odmg.newTransaction();
        tx.begin();
        tx.getBroker().clearCache();
        OQLQuery query = odmg.newOQLQuery();
        query.create("select objects from " + Manager.class.getName()+" where name like $1 and address.street like $2");
        query.bind(name + "%");
        query.bind("snob allee");
        Collection result = (Collection) query.execute();
        tx.commit();

View Full Code Here


        TransactionExt tx = (TransactionExt) odmg.newTransaction();
        tx.begin();
        tx.getBroker().clearCache();
        OQLQuery query = odmg.newOQLQuery();
        query.create("select objects from " + Executive.class.getName()+" where name like $1 and address.street like $2");
        query.bind(name + "%");
        query.bind("snob allee");
        Collection result = (Collection) query.execute();
        tx.commit();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.