[jboss-jira] [JBoss JIRA] (WFLY-11495) WildFly 14-15 Create Query

[Majid Mostafavi (Jira)]

Majid Mostafavi created WFLY-11495:
--------------------------------------

             Summary: WildFly 14-15 Create Query
                 Key: WFLY-11495
                 URL: https://issues.jboss.org/browse/WFLY-11495
             Project: WildFly
          Issue Type: Bug
          Components: JPA / Hibernate
    Affects Versions: 15.0.0.Final, 14.0.1.Final
            Reporter: Majid Mostafavi
            Assignee: Scott Marlow


Hi 
When I use this syntax for create lazy data  loader
 CriteriaBuilder builder = entityManager.getCriteriaBuilder();
        CriteriaQuery<{color:#DE350B}X{color}> criteria = builder.createQuery({color:#DE350B}X{color}.class);

        Root<{color:#DE350B}XDTO{color}> xRoot = criteria.from(XDTO.class);
.
.
.
.

  criteria.where(predicate);

        Query queryResult=entityManager.createQuery(criteria);
        queryResult.setFirstResult(first);
        if (pageSize > 0){
            queryResult.setMaxResults(pageSize);
        }


wildfly create query by this syntax
     select
        * 
     from ( {color:#14892c}select  dto item1, select dto item2 from Xroot {color} ) 
      where
        rownum <=  



--
This message was sent by Atlassian Jira
(v7.12.1#712002)