[JBoss JIRA] (WFLY-11495) WildFly 14-15 Create Query
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2008 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2007 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2006 -----
- December
- November
- October
- September
- August
- July
[
https://issues.jboss.org/browse/WFLY-11495?page=com.atlassian.jira.plugin...
]
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)
2483
days inactive
2483
days old
0 comments
1 participants
tags (0)
participants (1)
-
Majid Mostafavi (Jira)