Examples of org.odmg.OQLQuery.execute()

org.odmg.OQLQuery.execute()
Execute the query. After executing a query, the parameter list is reset. Some implementations may throw additional exceptions that are also derived from ODMGException. @return The object that represents the result of the query.The returned data, whatever its OQL type, is encapsulated into an object. For instance, when OQL returns an integer, the result is put into an Integer object. When OQL returns a collection (literal or object), the result is always a Java collection object of the same kind (for instance, a DList). @exception QueryException An exception has occurred while executing the query.


        tx.begin();
        OQLQuery query = odmg.newOQLQuery();
        query.create("select shops from " + Shop.class.getName() + " where name like $1");
        query.bind(name + "%");
        Collection result = (Collection) query.execute();


        assertEquals(2, result.size());


        query = odmg.newOQLQuery();
        query.create("select shops from " + Distributor.class.getName() + " where name like $1");

View Full Code Here

        assertEquals(2, result.size());


        query = odmg.newOQLQuery();
        query.create("select shops from " + Distributor.class.getName() + " where name like $1");
        query.bind(name + "%");
        result = (Collection) query.execute();


        assertEquals(2, result.size());
        tx.commit();


        tx.begin();

View Full Code Here


        tx.begin();
        query = odmg.newOQLQuery();
        query.create("select shops from " + Distributor.class.getName() + " where name like $1");
        query.bind(name + "_3");
        result = (Collection) query.execute();
        tx.commit();


        assertEquals(1, result.size());
        Distributor d3New = (Distributor) result.iterator().next();

View Full Code Here


        tx.begin();
        OQLQuery query = odmg.newOQLQuery();
        query.create("select shops from " + Shop.class.getName() + " where name like $1");
        query.bind(name + "%");
        Collection result = (Collection) query.execute();


        assertEquals(0, result.size());


        query = odmg.newOQLQuery();
        query.create("select shops from " + Distributor.class.getName() + " where name like $1");

View Full Code Here

        assertEquals(0, result.size());


        query = odmg.newOQLQuery();
        query.create("select shops from " + Distributor.class.getName() + " where name like $1");
        query.bind(name + "%");
        result = (Collection) query.execute();


        assertEquals(2, result.size());
        tx.commit();


        tx.begin();

View Full Code Here


        tx.begin();
        query = odmg.newOQLQuery();
        query.create("select shops from " + Distributor.class.getName() + " where name like $1");
        query.bind(name + "_3");
        result = (Collection) query.execute();
        tx.commit();


        assertEquals(1, result.size());
        Distributor d3New = (Distributor) result.iterator().next();

View Full Code Here

        tx.getBroker().clearCache();


        OQLQuery query = odmg.newOQLQuery();
        query.create("select products from " + Shop.class.getName() + " where name like $1");
        query.bind(name + "%");
        Collection result = (Collection) query.execute();
        tx.commit();


        assertEquals(1, result.size());
        Shop newShop = (Shop) result.iterator().next();
        assertNotNull(newShop.getProducts());

View Full Code Here

        tx.begin();
        tx.getBroker().clearCache();
        query = odmg.newOQLQuery();
        query.create("select products from " + Product.class.getName() + " where name like $1");
        query.bind(name + "_subPro%");
        result = (Collection) query.execute();
        tx.commit();
        assertEquals(3, result.size());


        tx.begin();
        query = odmg.newOQLQuery();

View Full Code Here


        tx.begin();
        query = odmg.newOQLQuery();
        query.create("select products from " + Product.class.getName() + " where name like $1");
        query.bind(name + "_product_1");
        result = (Collection) query.execute();
        assertEquals(1, result.size());


        database.deletePersistent(result.iterator().next());
        tx.commit();

View Full Code Here

        tx.begin();
        tx.getBroker().clearCache();
        query = odmg.newOQLQuery();
        query.create("select products from " + Product.class.getName() + " where name like $1");
        query.bind(name + "_subPro%");
        result = (Collection) query.execute();
        tx.commit();
        assertEquals(3, result.size());
    }


    public void testOneToNWithBackReference_2() throws Exception

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.