Examples of org.apache.openjpa.persistence.query.QueryDefinition.where()

Package org.apache.openjpa.persistence.query

Class org.apache.openjpa.persistence.query.QueryDefinition

Examples of org.apache.openjpa.persistence.query.QueryDefinition.where()

org.apache.openjpa.persistence.query.QueryDefinition.where()
Modifies the query definition to restrict the result of the query according to the specified predicate. Replaces the previously added restriction(s), if any. @param predicate -a simple or compound conditional predicate @return the modified QueryDefinition instance

    public void testOrderBy2() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject customer = q.addRoot(Customer.class);
        DomainObject order = customer.join("orders");
        DomainObject address = customer.join("address");
        q.where(address.get("state").equal("CA"))
        .select(order.get("quantity"), address.get("zipCode"))
        .orderBy(order.get("quantity").desc(), address.get("zipCode"));
        String jpql = "SELECT o.quantity, a.zipCode"
                    + " FROM Customer c JOIN c.orders o JOIN c.address a"
                    + " WHERE a.state = 'CA'"

View Full Code Here

        DomainObject emp = q1.addRoot(Employee.class);
        
        QueryDefinition q2 = qb.createQueryDefinition();
        DomainObject spouseEmp = q2.addRoot(Employee.class);
        
        q2.where(spouseEmp.equal(emp.get("spouse"))).select(spouseEmp);
        q1.selectDistinct(emp).where(q2.exists());
        
        String jpql = "SELECT DISTINCT e "
                    + " FROM Employee e"
                    + " WHERE EXISTS ("

View Full Code Here

0 1

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.