Examples of org.apache.ojb.broker.query.Query

org.apache.ojb.broker.query.Query
represents Queries that can be used by the OJB PersistenceBroker to retrieve Objects from the underlying DB. Until now there are two implementations: 1. QueryByCriteria, represents SELECT * FROM ... WHERE ... queries 2. QueryByIdentity, uses Example objects or OIDs as templates for the db lookup there could additional implementations, e.g for user defined SQL For the Criteria API I reused code from the COBRA project, as you will see by their class comments. I removed all stuff that relies on knowlegde of the DataDictionary or MetaData layer. The Query and Criteria classes thus don't know how to build SQL statements, as in the COBRA original sources. I use the this classes as mere data-structures, that are processed by the OJB Accesslayer (SqlGenerator, JdbcAccess). This design will allow to reuse the org.apache.ojb.broker.query package in other projects without breaking any references. I hope this will be useful for someone. @author Thomas Mahler @version $Id: Query.java,v 1.17.2.3 2005/12/21 22:27:09 tomdz Exp $

        }
        broker.commitTransaction();


        Criteria crit = new Criteria();
        crit.addLike("lastname", name);
        Query q = QueryFactory.newQuery(Person.class, crit);
        Collection result = broker.getCollectionByQuery(q);
        assertEquals(200, result.size());


        broker.beginTransaction();
        for(Iterator iterator = result.iterator(); iterator.hasNext();)

View Full Code Here


    public void testOtmSession() throws Throwable
    {
        Transaction tx = null;
        Criteria crit;
        Query q;
        EnhancedOQLQuery oql;
        Iterator it;
        Article example;


        //perform transaction

View Full Code Here

    public void testUpdateContractVersionEffectiveness()
    {
        createTestData();


        Criteria crit = new Criteria();
        Query q;
        Iterator iter;
        /**
         * update effectiveness first
         */
        q = QueryFactory.newQuery(Effectiveness.class, crit);

View Full Code Here

    public void testDeleteContractVersionEffectiveness()
    {
        createTestData();


        Criteria crit = new Criteria();
        Query q;
        Iterator iter;
        /**
         * delete effectiveness first
         */
        q = QueryFactory.newQuery(Effectiveness.class, crit);

View Full Code Here

        TransactionExt tx = ((TransactionExt) odmg.currentTransaction());
        // force writing to DB
        tx.flush();
        Class searchClass = objects.get(0).getClass();
        PersistenceBroker broker = tx.getBroker();
        Query q = new QueryByCriteria(searchClass, new Criteria());
        // we get the iterator and step into the first found object
        Iterator it = broker.getIteratorByQuery(q);
        it.next();
        // now the iterator resources may not release, see what's going on
        ctx.setRollbackOnly();

View Full Code Here

    public void testPathExpressionsMtoN2()
    {
        Criteria crit = new Criteria();
        crit.addEqualTo("projects.roles.roleName", "developer");
        crit.addLike("projects.persons.lastname", "%b%");
        Query q = QueryFactory.newQuery(Person.class, crit);


        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() > 0);
    }

View Full Code Here

        ArrayList list = new java.util.ArrayList();


        Criteria crit = new Criteria();
        crit.addEqualTo("allArticlesInGroup.productGroupId", new Integer(5));


        Query q = QueryFactory.newQuery(ProductGroup.class, crit, true);


        Iterator iter = broker.getIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here

        ArrayList list = new java.util.ArrayList();


        Criteria crit = new Criteria();
        crit.addLike("upper(allArticlesInGroup.articleName)", "F%");


        Query q = QueryFactory.newQuery(ProductGroup.class, crit, true);


        Iterator iter = broker.getIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here

        ArrayList list = new java.util.ArrayList();


        Criteria crit = new Criteria();
        crit.addEqualTo("allArticlesInGroup.productGroupId", new Integer(5));


        Query q = QueryFactory.newQuery(AbstractProductGroup.class, crit, true);


        Iterator iter = broker.getIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here


        Criteria crit2 = new Criteria();
        crit2.addGreaterOrEqualThan("allArticlesInGroup.stock", new Integer(110));


        crit1.addAndCriteria(crit2);
        Query q = QueryFactory.newQuery(ProductGroup.class, crit1, true);


        Iterator iter = broker.getIteratorByQuery(q);
        while (iter.hasNext())
        {
            list.add(iter.next());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.ojb.broker.query.Query

org.apache.cocoon.portal.security.DBSecurityHandler

org.apache.jetspeed.components.persistence.store.ojb.otm.OTMStoreImpl

org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEntityAccess

org.apache.jetspeed.prefs.impl.PersistenceBrokerPreferencesProvider

org.apache.jetspeed.security.impl.PermissionManagerImpl

org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager

org.apache.jetspeed.security.spi.impl.SecurityAccessImpl

org.apache.jetspeed.sso.impl.PersistenceBrokerSSOProvider

org.apache.jetspeed.sso.spi.impl.JetspeedPersistentSSOSiteManager

org.apache.ojb.broker.AbstractExtentClassTest

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.