August 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-17004) Nullpointer wenn using setFirstResult and setMaxResults in diffrent combinations

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-17004 ( https://hibernate.atlassian.net/browse/HHH-17004?atlOrigin=eyJpIjoiNmE5Zm... ) Re: Nullpointer wenn using setFirstResult and setMaxResults in diffrent combinations ( https://hibernate.atlassian.net/browse/HHH-17004?atlOrigin=eyJpIjoiNmE5Zm... ) I’m scratching my head on this one; I’m still unable to reproduce the issue. That said, I must admit that I don’t have access to a Cache DB, so i tried first with the SybaseASEDialect (which also uses the TLH), and also tried to ‘fake’ it by configuring the TopLimitHandler to the H2Dialect, and tried it in 6.2.5, but still to no avail. So either the TopLimitHandler is not the culprit in this story, or there is something else that I’m missing in the picture. Also, during debugging I saw that it never goes into that if you mentioned, are you sure this is the snippet you wanted to refer to? if ( localCopy.jdbcSelect.dependsOnParameterBindings() ) { jdbcParameterBindings = createJdbcParameterBindings( localCopy, executionContext ); } ( https://hibernate.atlassian.net/browse/HHH-17004#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17004#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#100234- sha1:39b0f46 )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17009) Hibernate 6.2 migration guide does explain how to deal with removal of AbstractPostInsertGenerator (affects IdentityGenerator)

by Steve Ebersole (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17009) Hibernate 6.2 migration guide does explain how to deal with removal of AbstractPostInsertGenerator (affects IdentityGenerator)

by Steve Ebersole (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16973) optional 'from' clause when result type is an entity class

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16973 ( https://hibernate.atlassian.net/browse/HHH-16973?atlOrigin=eyJpIjoiOGRmM2... ) Re: optional 'from' clause when result type is an entity class ( https://hibernate.atlassian.net/browse/HHH-16973?atlOrigin=eyJpIjoiOGRmM2... ) This is done, and documented. The issue can be closed. ( https://hibernate.atlassian.net/browse/HHH-16973#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16973#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17069) Static metamodel field is not generated

by Valdas Žiemys (JIRA)

Valdas Žiemys ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-17069 ( https://hibernate.atlassian.net/browse/HHH-17069?atlOrigin=eyJpIjoiOTZmNG... ) Re: Static metamodel field is not generated ( https://hibernate.atlassian.net/browse/HHH-17069?atlOrigin=eyJpIjoiOTZmNG... ) very sorry, but how to edit and complete my issue? 😞 In same way I posted it accidentally because I didn’t work Atlassian before, sorry again. ( https://hibernate.atlassian.net/browse/HHH-17069#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17069#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17069) Static metamodel field is not generated

by Valdas Žiemys (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17068) enums in org.hibernate.query.sqm

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWExNTYwZDI0... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-17068?atlOrigin=eyJpIjoiOWExNT... ) HHH-17068 ( https://hibernate.atlassian.net/browse/HHH-17068?atlOrigin=eyJpIjoiOWExNT... ) enums in org.hibernate.query.sqm ( https://hibernate.atlassian.net/browse/HHH-17068?atlOrigin=eyJpIjoiOWExNT... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) [https://hibernate.atlassian.net/browse/HHH- 16973 16866 |https://hibernate.atlassian.net/browse/HHH- 16973 16866 |smart-link] is closed, since some related work was already merged, but the following enums still need a new home: {{FetchClauseType}}, {{SetOperator}}, {{FrameKind}}, {{FrameExclusion}}, {{FrameMode}}, {{SqmJoinType}}, {{TemporalUnit}}. The question is: where should they go? ( https://hibernate.atlassian.net/browse/HHH-17068#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17068#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17068) enums in org.hibernate.query.sqm

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTgyYTJmZDgx... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-17068?atlOrigin=eyJpIjoiOTgyYT... ) HHH-17068 ( https://hibernate.atlassian.net/browse/HHH-17068?atlOrigin=eyJpIjoiOTgyYT... ) enums in org.hibernate.query.sqm ( https://hibernate.atlassian.net/browse/HHH-17068?atlOrigin=eyJpIjoiOTgyYT... ) Issue Type: Improvement Assignee: Unassigned Components: query-criteria Created: 10/Aug/2023 10:12 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) https://hibernate.atlassian.net/browse/HHH-16973 is closed, since some related work was already merged, but the following enums still need a new home: FetchClauseType , SetOperator , FrameKind , FrameExclusion , FrameMode , SqmJoinType , TemporalUnit. The question is: where should they go? ( https://hibernate.atlassian.net/browse/HHH-17068#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17068#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16830) apply filters to 'find()' method

by Kinga N (JIRA)

Kinga N ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16830 ( https://hibernate.atlassian.net/browse/HHH-16830?atlOrigin=eyJpIjoiMjAxNj... ) Re: apply filters to 'find()' method ( https://hibernate.atlassian.net/browse/HHH-16830?atlOrigin=eyJpIjoiMjAxNj... ) Are there any updates on this issue? ( https://hibernate.atlassian.net/browse/HHH-16830#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16830#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#100234- sha1:6fcbbaf )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17067) Incorrect native SQL when joining entity with inheritance

by Ruslan Gryn (JIRA)

Ruslan Gryn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTk3NDk2OTJk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiMTk3ND... ) HHH-17067 ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiMTk3ND... ) Incorrect native SQL when joining entity with inheritance ( https://hibernate.atlassian.net/browse/HHH-17067?atlOrigin=eyJpIjoiMTk3ND... ) Change By: Ruslan Gryn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I discovered this issue during migration to Spring Boot 3 and Hibernate 6.2 The problem is that Hibernate 6 generates invalid native SQL and the SQL is correct when using Hibernate 5 We have the following entity which has a reference to the {{parent}} class(abstract class) {noformat} @Entity public class Main { @Id private Long id; @OneToMany(mappedBy = "main") private Collection<Parent> parents = new HashSet<>(); }{noformat} {{Parent}} class {noformat}@Entity @Inheritance(strategy = InheritanceType.JOINED) public abstract class Parent { @Id private Long id; @ManyToOne private Main main; }{noformat} and implementation of the {{parent}} class {noformat}@Entity public class Child extends Parent { @Column private String data; }{noformat} You will get incorrect native SQL when executing the following query {{select s from Main s left join s.parents as p left join Child c on c = p where c.data is not null}} The error {noformat}org.hibernate.exception.SQLGrammarException: could not prepare statement [Column "C1_1.ID" not found; SQL statement: select m1_0.id from Main m1_0 left join (Parent p1_0 left join Child p1_1 on p1_0.id=p1_1.id) on m1_0.id=p1_0.main_id left join Child c1_0 on c1_1.id=p1_1.id where c1_0.data is not null [42122-220]] [select m1_0.id from Main m1_0 left join (Parent p1_0 left join Child p1_1 on p1_0.id=p1_1.id) on m1_0.id=p1_0.main_id left join Child c1_0 on c1_1.id=p1_1.id where c1_0.data is not null] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:152){noformat} This query works fine on Hibernate 5 without issues The workaround to join entities using ids for example {{left join Child c on c.id = p.id}} I’ve attached a reproducer. The reproducer in {{ORMStandaloneTestCase}} class ( https://hibernate.atlassian.net/browse/HHH-17067#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17067#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#100234- sha1:6fcbbaf )

1 year, 1 month

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 August 2023