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

[Majid Mostafavi (Jira)]

    [ https://issues.jboss.org/browse/WFLY-11495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13675055#comment-13675055 ] 

Majid Mostafavi commented on WFLY-11495:
----------------------------------------

{color:#00875A}13:14:29,440 INFO  [stdout] (default task-15)     select
13:14:29,440 INFO  [stdout] (default task-15)         * 
13:14:29,440 INFO  [stdout] (default task-15)     from{color}
13:14:29,440 INFO  [stdout] (default task-15)         ( select
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.ID as ID1_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.active as active2_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.created as created3_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.createdBy as createdBy4_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.updated as updated5_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.updatedBy as updatedBy6_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.CM_ORGANIZATION_ID as CM_ORGANIZATION_I14_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.BANK_ACCOUNT_KIND_ID as BANK_ACCOUNT_KIND15_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.BANK_ACCOUNT_TYPE_ID as BANK_ACCOUNT_TYPE16_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.BANK_ACCOUNT_TYPE_ENUM as BANK_ACCOUNT_TYPE_7_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.BANK_BRANCH_ID as BANK_BRANCH_ID17_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.ACCOUNT_NUMBER as ACCOUNT_NUMBER8_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.DESCRIPTION as DESCRIPTION9_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.END_DATE as END_DATE10_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.NAME as NAME11_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.SHEBA as SHEBA12_417_,
13:14:29,440 INFO  [stdout] (default task-15)             trbankacco0_.START_DATE as START_DATE13_417_ 
13:14:29,440 INFO  [stdout] (default task-15)         from
13:14:29,440 INFO  [stdout] (default task-15)             NEJAT.TR_BANK_ACCOUNTS trbankacco0_ 
13:14:29,440 INFO  [stdout] (default task-15)         inner join
13:14:29,440 INFO  [stdout] (default task-15)             NEJAT.CM_ORGANIZATION cmorganiza1_ 
13:14:29,440 INFO  [stdout] (default task-15)                 on trbankacco0_.CM_ORGANIZATION_ID=cmorganiza1_.ID 
13:14:29,440 INFO  [stdout] (default task-15)         where
13:14:29,440 INFO  [stdout] (default task-15)             1=1 
13:14:29,440 INFO  [stdout] (default task-15)             and trbankacco0_.active=? 
13:14:29,440 INFO  [stdout] (default task-15)             and trbankacco0_.BANK_ACCOUNT_TYPE_ENUM=? ) 
{color:#00875A}13:14:29,440 INFO  [stdout] (default task-15)     where
13:14:29,440 INFO  [stdout] (default task-15)         rownum <= ?{color}

> 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: 14.0.1.Final, 15.0.0.Final
>            Reporter: Majid Mostafavi
>            Assignee: Scott Marlow
>            Priority: Major
>
> 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)