Examples of org.odmg.Implementation.newOQLQuery()

org.odmg.Implementation.newOQLQuery()
Create a new OQLQuery object. @return The new OQLQuery object. @see org.odmg.OQLQuery


        tx.begin();
        db.deletePersistent(site);
        tx.commit();


        query = odmg.newOQLQuery();
        query.create("select sites from " + Site.class.getName() + " where name=$1");
        query.bind(name);
        tx.begin();
        List result2 = (List) query.execute();
        if (result2.size() > 0)

View Full Code Here

            tx.begin();
            tx.lock(site, Transaction.WRITE);
            tx.commit();


            /* Retrieve from the object created, and set the year*/
            OQLQuery query = odmg.newOQLQuery();
            query.create(queryString);
            query.bind(name);


            tx.begin();
            List result = (List) query.execute();

View Full Code Here

            site.setYear(new Integer(2003));


            tx.commit();


            /* Flush the cache, and retrieve the object again */
            query = odmg.newOQLQuery();
            query.create(queryString);
            query.bind(name);
            tx.begin();
            ((HasBroker) tx).getBroker().clearCache();
            result = (List) query.execute();

View Full Code Here


        //perform transaction
        try
        {
            tx.begin();
            OQLQuery query = odmg.newOQLQuery();
            query.create("select aLotOfArticles from " + Article.class.getName() + " where productGroupId = 4");


            DCollection results = (DCollection) query.execute();
            results = results.query("price > 35");

View Full Code Here


            DCollection results = (DCollection) query.execute();
            results = results.query("price > 35");


            // now perform control query
            query = odmg.newOQLQuery();
            query.create(
                    "select aLotOfArticles from "
                    + Article.class.getName()
                    + " where productGroupId = 4 and price  > 35");

View Full Code Here

        {
            Transaction tx = odmg.newTransaction();
            tx.begin();


            // retrieve an Article
            OQLQuery query = odmg.newOQLQuery();
            query.create("select anArticle from " + Article.class.getName() + " where articleId = $678");
            query.bind(new Integer(30));
            List results = (List) query.execute();
            Article a = (Article) results.get(0);

View Full Code Here

        //perform transaction
        try
        {
            tx.begin();


            OQLQuery query = odmg.newOQLQuery();
            query.create("select anArticle from " + Article.class.getName() + " where articleId = 60");
            List results = (List) query.execute();


            Article a = (Article) results.get(0);

View Full Code Here

        Transaction tx = odmg.newTransaction();


        // perform transaction
        tx.begin();


        OQLQuery query = odmg.newOQLQuery();
        // use 'like' instead of '=' when perform query with wildcards
        query.create(
                "select anArticle from " + Article.class.getName() + " where productGroup.groupName like \"Fruit*\"");
        List results = (List) query.execute();

View Full Code Here

        query.create(
                "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*\"");

View Full Code Here

            ((ImplementationImpl) odmg).setOqlCollectionClass(DListImpl.class);
            //=============================


            tx.begin();


            OQLQuery query = odmg.newOQLQuery();
            query.create("select x from " + Article.class.getName() + " where productGroupId = 7");
            List results = (List) query.execute();


            int originalSize = results.size();
            assertTrue("result count have to be > 0", originalSize > 0);

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.