October 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-15599) Support conditional order-by clauses in QueryBuilder

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15599 ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiMmY0Nj... ) Re: Support conditional order-by clauses in QueryBuilder ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiMmY0Nj... ) Did you try Hibernate 6 yet? Pretty sure this is fixed already. ( https://hibernate.atlassian.net/browse/HHH-15599#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15599#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15599) Support conditional order-by clauses in QueryBuilder

by Patrick Lübbecke (JIRA)

Patrick Lübbecke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61a7428... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmY0YTgxN2E3... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiYmY0YT... ) HHH-15599 ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiYmY0YT... ) Support conditional order-by clauses in QueryBuilder ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiYmY0YT... ) Change By: Patrick Lübbecke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61a7428... ) I would like to add conditional order by operators to CriteriaBuilder like that: {{order by rmgtnav_path, rmgtnav_collection_type<>'PROFILE', rmgtnav_denotation asc}} Or as {{Order}} objects: {noformat}List<Order> orderStatements = new ArrayList(); orderStatements.add(cb.asc(root.get("rmgtnav_path"))); orderStatements.add(cb.asc(cb.notEqual(root.get("rmgtnav_collection_type"), "PROFILE"))); orderStatements.add(cb.asc(root.get("rmgtnav_denotation"))); criteriQuery criteriaQuery.orderBy(orderStatements); Query query = session.createQuery(cq);{noformat} What the {{rmgtnav_collection_type<> 'Profile'}} part does is to resolve the statement as a boolean which is true (1) or false (0) and start sorting with collection_type = Profile on top in my case. Unfortunately, I get an error when calling {{session.createQuery(cq)}} method: {{org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: <> near line 1, column 596 [select generatedAlias0 from com.myapp.core.rmgt.rate.business.object.RmgtBVOImpl as generatedAlias0 where ( generatedAlias0.collectionType<>:param0 ) and ( ( generatedAlias0.collectionSubType<>:param1 ) or ( generatedAlias0.collectionSubType is null ) ) and ( ( lower(generatedAlias0.profileStatus) like :param2 ) and ( ( generatedAlias0.type=:param3 ) or ( generatedAlias0.type=:param4 ) ) ) and ( generatedAlias0.enabled=:param5 ) and ( ( generatedAlias0.owner=:param6 ) or ( generatedAlias0.owner=:param7 ) ) order by generatedAlias0.path asc, generatedAlias0.collectionType<>:param8 asc, generatedAlias0.denotation asc]}} I think it would be beneficial, If criteriaBuilder would also allow to add these kind of statements. ( https://hibernate.atlassian.net/browse/HHH-15599#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15599#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15599) Support conditional order-by clauses in QueryBuilder

by Patrick Lübbecke (JIRA)

Patrick Lübbecke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61a7428... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGIyNGRkN2Yx... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiZGIyNG... ) HHH-15599 ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiZGIyNG... ) Support conditional order-by clauses in QueryBuilder ( https://hibernate.atlassian.net/browse/HHH-15599?atlOrigin=eyJpIjoiZGIyNG... ) Issue Type: Improvement Affects Versions: 5.6.12 Assignee: Unassigned Created: 12/Oct/2022 03:53 AM Priority: Minor Reporter: Patrick Lübbecke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61a7428... ) I would like to add conditional order by operators to CriteriaBuilder like that: order by rmgtnav_path, rmgtnav_collection_type<>'PROFILE', rmgtnav_denotation asc Or as Order objects: List<Order> orderStatements = new ArrayList(); orderStatements.add(cb.asc(root.get("rmgtnav_path"))); orderStatements.add(cb.asc(cb.notEqual(root.get("rmgtnav_collection_type"), "PROFILE"))); orderStatements.add(cb.asc(root.get("rmgtnav_denotation"))); criteriQuery.orderBy(orderStatements); Query query = session.createQuery(cq); What the rmgtnav_collection_type<> 'Profile' part does is to resolve the statement as a boolean which is true (1) or false (0) and start sorting with collection_type = Profile on top in my case. Unfortunately, I get an error when calling session.createQuery(cq) method: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: <> near line 1, column 596 [select generatedAlias0 from com.myapp.core.rmgt.rate.business.object.RmgtBVOImpl as generatedAlias0 where ( generatedAlias0.collectionType<>:param0 ) and ( ( generatedAlias0.collectionSubType<>:param1 ) or ( generatedAlias0.collectionSubType is null ) ) and ( ( lower(generatedAlias0.profileStatus) like :param2 ) and ( ( generatedAlias0.type=:param3 ) or ( generatedAlias0.type=:param4 ) ) ) and ( generatedAlias0.enabled=:param5 ) and ( ( generatedAlias0.owner=:param6 ) or ( generatedAlias0.owner=:param7 ) ) order by generatedAlias0.path asc, generatedAlias0.collectionType<>:param8 asc, generatedAlias0.denotation asc] I think it would be beneficial, If criteriaBuilder would also allow to add these kind of statements. ( https://hibernate.atlassian.net/browse/HHH-15599#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15599#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4717) Upgrade to Byteman 4.0.20

by Yoann Rodière (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4717) Upgrade to Byteman 4.0.20

by Yoann Rodière (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4717) Upgrade to Byteman 4.0.20

by Yoann Rodière (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15575) Make getter org.hibernate.criterion.SimpleExpression#getOp() public

by Andrea Boriero (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15574) jpamodelgen doesn't generate meta model

by Andrea Boriero (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15590) UUIDJdbcType and VarcharUUIDJdbcType lack getJdbcLiteralFormatter implementation

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4678) select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiY2I... ) Re: select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiY2I... ) > > > > Yes, I already saw those configurations, however it is limited and does > not allow me to change this sequence configuration. > > How so? You can pass the whole XML mapping! I’m not talking about the properties that allow customizing table and sequence names. That’s a completely different one. > > > > But maybe this solution using UUID s could be the solution without > polluting configuration options. > > Glad you feel that way; I’d rather use one solution for everyone, if it works. ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

1 year, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2022