Examples of com.mysema.query.jpa.JPQLQuery

    @Test
    public void One_To_One() {
        QEmployee employee = QEmployee.employee;
        QUser user = QUser.user;


        JPQLQuery query = query();
        query.from(employee);
        query.innerJoin(employee.user, user);
        query.list(employee);
    }

    @ExcludeIn(ORACLE)
    public void Substring2() {
        QCompany company = QCompany.company;
        StringExpression name = company.name;
        Integer companyId = query().from(company).singleResult(company.id);
        JPQLQuery query = query().from(company).where(company.id.eq(companyId));
        String str = query.singleResult(company.name);


        assertEquals(Integer.valueOf(29),
                query.singleResult(name.length().subtract(11)));


        assertEquals(str.substring(0, 7),
                query.singleResult(name.substring(0, 7)));


        assertEquals(str.substring(15),
                query.singleResult(name.substring(15)));


        assertEquals(str.substring(str.length()),
                query.singleResult(name.substring(name.length())));


        assertEquals(str.substring(str.length() - 11),
                query.singleResult(name.substring(name.length().subtract(11))));
    }

Examples of com.mysema.query.jpa.JPQLQuery

Related Classes of com.mysema.query.jpa.JPQLQuery