Examples of org.odmg.OQLQuery.bind()

org.odmg.OQLQuery.bind()
Bind a parameter to the query. A parameter is denoted in the query string passed to create by $i, where i is the rank of the parameter, beginning with 1. The parameters are set consecutively by calling this method bind. The ith variable is set by the ith call to the bind method. If any of the $i are not set by a call to bind at the point execute is called, QueryParameterCountInvalidException is thrown. The parameters must be objects, and the result is an Object. Objects must be used instead of primitive types (Integer instead of int) for passing the parameters.
If the parameter is of the wrong type, QueryParameterTypeInvalidException is thrown. After executing a query, the parameter list is reset. @parameter A value to be substituted for a query parameter. @exception QueryParameterCountInvalidException The number of calls tobind has exceeded the number of parameters in the query. @exception QueryParameterTypeInvalidException The type of the parameter doesnot correspond with the type of the parameter in the query.

            tx.commit();


            tx.begin();
            OQLQuery query = odmg.newOQLQuery();
            query.create("select masters from " + Master.class.getName() + " where masterText like $1");
            query.bind("%" + timestamp);
            DList allMasters = (DList) query.execute();


            // Iterator over all Master objects
            Iterator it = allMasters.iterator();
            int counter = 0;

View Full Code Here

            tx.commit();
            assertEquals("Wrong count of Master objects found", 4, counter);


            query = odmg.newOQLQuery();
            query.create("select masters from " + Master.class.getName() + " where masterText like $1");
            query.bind("%" + timestamp);
            allMasters = (DList) query.execute();
            assertEquals("Delete of Master objects failed", 0, allMasters.size());


            database.close();
        }

View Full Code Here

    private Collection getContract(String pk, Implementation odmg)
            throws Exception
    {
        OQLQuery query = odmg.newOQLQuery();
        query.create("select c from " + Contract.class.getName() + " where pk like $1");
        query.bind(pk);
        return (Collection) query.execute();
    }
}

View Full Code Here

        if(log.isDebugEnabled()) log.debug("getArticlesByName was called");
        try
        {
            OQLQuery query = odmg.newOQLQuery();
            query.create("select allArticles from " + ArticleVO.class.getName() + " where name like $1");
            query.bind(articleName);
            return (Collection) query.execute();
        }
        catch (QueryException e)
        {
            throw new EJBException("Query objects failed", e);

View Full Code Here

        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();
        query.create("select objects from " + Manager.class.getName()+" where name like $1");

View Full Code Here

        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());
    }


    private void prepareForQueryTests(String name)

View Full Code Here

        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();)
        {
            Employee obj = (Employee) iterator.next();

View Full Code Here

        }


        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();)
        {
            Executive obj = (Executive) iterator.next();

View Full Code Here

        }


        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();)
        {
            Manager obj = (Manager) iterator.next();

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 department like $2");
        query.bind(name + "%");
        query.bind("none");
        Collection result = (Collection) query.execute();
        tx.commit();
        assertEquals(1, result.size());
    }

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.