July 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-14121) Params from main orderBy query are trying to be inserted to subselect query ->parameter index out of range

by Raman Kreidzich (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14121) Params from main orderBy query are trying to be inserted to subselect query ->parameter index out of range

by Raman Kreidzich (JIRA)

Raman Kreidzich ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cbe15f... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGJjYmI5ODM0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14121?atlOrigin=eyJpIjoiOGJjYm... ) HHH-14121 ( https://hibernate.atlassian.net/browse/HHH-14121?atlOrigin=eyJpIjoiOGJjYm... ) Params from main orderBy query are trying to be inserted to subselect query ->parameter index out of range ( https://hibernate.atlassian.net/browse/HHH-14121?atlOrigin=eyJpIjoiOGJjYm... ) Change By: Raman Kreidzich ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cbe15f... ) There are two entities: Post and Comment. Post has collection of comments that are selected in subselect query: {{ @OneToMany(mappedBy = "post", fetch = FetchType.EAGER, cascade = CascadeType.MERGE) }} {{ @Fetch(value = FetchMode.SUBSELECT) }} {{ private List<Comment> comments;}} When Post entities are selected by CriteriaQuery with specific 'orderBy' expression that contains params (see fragment below), exception ' SQLException _SQLException : Parameter index out of range (1 > number of parameters, which is 0). _ ' is thrown. {{Order order = builder.desc(builder.coalesce(root.get("name"), "default_name")); }} {{ query.orderBy(order);}} ORMUnitTestCase: [ https://github.com/hibernate/hibernate-test-case-templates/pull/35 |https://github.com/hibernate/hibernate-test-case-templates/pull/35] ( https://hibernate.atlassian.net/browse/HHH-14121#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14121#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#100140- sha1:fbb0377 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14121) Params from main orderBy query are trying to be inserted to subselect query ->parameter index out of range

by Raman Kreidzich (JIRA)

Raman Kreidzich ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cbe15f... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzAxODAwZDI4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14121?atlOrigin=eyJpIjoiNzAxOD... ) HHH-14121 ( https://hibernate.atlassian.net/browse/HHH-14121?atlOrigin=eyJpIjoiNzAxOD... ) Params from main orderBy query are trying to be inserted to subselect query ->parameter index out of range ( https://hibernate.atlassian.net/browse/HHH-14121?atlOrigin=eyJpIjoiNzAxOD... ) Issue Type: Bug Affects Versions: 5.4.18 Assignee: Unassigned Components: hibernate-core Created: 27/Jul/2020 12:45 PM Environment: java 1.8+, hibernate-core 5.4.18.Final, any DB Priority: Major Reporter: Raman Kreidzich ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cbe15f... ) There are two entities: Post and Comment. Post has collection of comments that are selected in subselect query: {{ @OneToMany(mappedBy = "post", fetch = FetchType.EAGER, cascade = CascadeType.MERGE) @Fetch(value = FetchMode.SUBSELECT) private List<Comment> comments;}} When Post entities are selected by CriteriaQuery with specific 'orderBy' expression that contains params (see fragment below), exception 'SQLException: Parameter index out of range (1 > number of parameters, which is 0).' is thrown. {{Order order = builder.desc(builder.coalesce(root.get("name"), "default_name")); query.orderBy(order);}} ORMUnitTestCase: https://github.com/hibernate/hibernate-test-case-templates/pull/35 ( https://hibernate.atlassian.net/browse/HHH-14121#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14121#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#100140- sha1:fbb0377 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HBX-2056) Update jboss-parent dependency to version 37

by Koen Aers (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3965) Upgrade to Lucene 8.6.0

by Yoann Rodière (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (WEBSITE-593) Broken link: https://hibernate.org/orm/release/5.4/

by Guillaume Smet (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (WEBSITE-593) Broken link: https://hibernate.org/orm/release/5.4/

by Guillaume Smet (JIRA)

Guillaume Smet ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on WEBSITE-593 ( https://hibernate.atlassian.net/browse/WEBSITE-593?atlOrigin=eyJpIjoiNjdh... ) Re: Broken link: https://hibernate.org/orm/release/5.4/ ( https://hibernate.atlassian.net/browse/WEBSITE-593?atlOrigin=eyJpIjoiNjdh... ) The correct page is https://hibernate.org/orm/releases/5.4/. And we have no idea from where the OP comes from so let's close. ( https://hibernate.atlassian.net/browse/WEBSITE-593#add-comment?atlOrigin=... ) Add Comment ( https://hibernate.atlassian.net/browse/WEBSITE-593#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#100140- sha1:fbb0377 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14103) Add test cases showing that an entity's transient attribute can be overridden to be persistent in entity subclasses

by Andrea Boriero (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14103) Add test cases showing that an entity's transient attribute can be overridden to be persistent in entity subclasses

by Andrea Boriero (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14103) Add test cases showing that an entity's transient attribute can be overridden to be persistent in entity subclasses

by Andrea Boriero (JIRA)

3 years, 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 July 2020