June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16790) Performance issue when retrieving a large bulk of entity in bidirectionnal association

by Thomas Herth (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16856) Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1

by Aleksandr B. (JIRA)

Aleksandr B. ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16856 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiNGIxZW... ) Re: Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiNGIxZW... ) This is absolutely not a hibernate relative bug. I’d say that this is not a bug at all. Spring Data (starting from 3.x) parses your @Query string and generates a new query. When you create PageRequest you should use aliases from the the query: r.name instead of role.name : Order order = new Order(ASC, "r.name"); In your case, spring data sees, that “left join” is absolutely useless and removes it from the query. Then spring data adds a new inner join with Role to satisfy your Sort request. ( https://hibernate.atlassian.net/browse/HHH-16856#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16856#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16660) Composite key + fetch join results with UnknownTableReferenceException

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16660 ( https://hibernate.atlassian.net/browse/HHH-16660?atlOrigin=eyJpIjoiOTQ3Ym... ) Re: Composite key + fetch join results with UnknownTableReferenceException ( https://hibernate.atlassian.net/browse/HHH-16660?atlOrigin=eyJpIjoiOTQ3Ym... ) Hi Christopher Holomek ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , can you please check if this issue has been fixed? Thanks ( https://hibernate.atlassian.net/browse/HHH-16660#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16660#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16857) JdbcLiteralFormatterCharacterData's lowercase 'n' causes invalid SQL syntax

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16857 ( https://hibernate.atlassian.net/browse/HHH-16857?atlOrigin=eyJpIjoiZTZiMD... ) Re: JdbcLiteralFormatterCharacterData's lowercase 'n' causes invalid SQL syntax ( https://hibernate.atlassian.net/browse/HHH-16857?atlOrigin=eyJpIjoiZTZiMD... ) Confirmed. SQL Server insists that the prefix by uppercase. https://learn.microsoft.com/en-us/sql/t-sql/data-types/constants-transact... The fix is completely trivial, just change {{JdbcLiteralFormatterCharacterData.NATIONALIZED_PREFIX}}but we also need to add a test. (It’s quite strange that our tests don’t pick this up already.) ( https://hibernate.atlassian.net/browse/HHH-16857#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16857#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16858) Can't compare test expression of type [BasicSqmPathSource(type : Enum)] with element of type [basicType@5(java.lang.Integer,4)]

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16858 ( https://hibernate.atlassian.net/browse/HHH-16858?atlOrigin=eyJpIjoiYzljMz... ) Re: Can't compare test expression of type [BasicSqmPathSource(type : Enum)] with element of type [basicType(a)5(java.lang.Integer,4)] ( https://hibernate.atlassian.net/browse/HHH-16858?atlOrigin=eyJpIjoiYzljMz... ) I’m not convinced it makes sense to compare enums using <. HQL is probably quite justified in rejecting this. ( https://hibernate.atlassian.net/browse/HHH-16858#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16858#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16811) Dirty property lost and not detected with Batch Fetch, Embedded and FetchMode SELECT

by Andrea Boriero (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16859) max() doesn't work with Enums

by Michał Maliszewski (JIRA)

Michał Maliszewski ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ad7619... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTRmMzIyYTBj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16859?atlOrigin=eyJpIjoiNTRmMz... ) HHH-16859 ( https://hibernate.atlassian.net/browse/HHH-16859?atlOrigin=eyJpIjoiNTRmMz... ) max() doesn't work with Enums ( https://hibernate.atlassian.net/browse/HHH-16859?atlOrigin=eyJpIjoiNTRmMz... ) Change By: Michał Maliszewski ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ad7619... ) Assuming we have the following entity: {code:java}@Entity @Table(name = "SOME_TABLE") public class SomeDbo { @Id @Column(name = "ID", nullable = false) private Long id; @Column(name = "SOME_ENUM") @Enumerated(EnumType.ORDINAL) private ESomeEnum type; // ... }{code} and the following Data Access Object with a Query: {code:java}@Repository @ApplicationScope public interface SomeDao { @Query("select distinct s.id, max(s.type) as mx from SomeDbo s group by s.id order by mx") List<Object[]> findSomeMax(); }{code} would provide to the following exception: {noformat}org.hibernate.QueryException: Parameter 1 of function max() has type COMPARABLE, but argument is of type com.some.enum.ESomeEnum{noformat} This is a bit unpleasant as it was working well with Hibernate 5.6.x and still usage of: {code:java} @Query("select s from SomeDbo s where s.type = 1") List<SomeDbo> findSomeOfTypeOne();{code} works fine in Hibernate 6.2.5. The possible workaround I see for now is by doing: { noformat code:java } @Query("select distinct s.id, max(cast(s.type as Integer) as mx from SomeDbo s group by s.id order by mx") List<Object[]> findSomeMax();{ noformat code } instead, which obviously changed the Object[1] type which needs to be converted in the code back to ESomeEnum type. It seems that Enum handling needs improvements, as I see several similar issues, e.g. [https://hibernate.atlassian.net/browse/HHH-16445|https://hibernate.atlass...]. ( https://hibernate.atlassian.net/browse/HHH-16859#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16859#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16859) max() doesn't work with Enums

by Michał Maliszewski (JIRA)

Michał Maliszewski ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ad7619... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGVmMjk5MWUx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16859?atlOrigin=eyJpIjoiOGVmMj... ) HHH-16859 ( https://hibernate.atlassian.net/browse/HHH-16859?atlOrigin=eyJpIjoiOGVmMj... ) max() doesn't work with Enums ( https://hibernate.atlassian.net/browse/HHH-16859?atlOrigin=eyJpIjoiOGVmMj... ) Issue Type: Bug Affects Versions: 6.2.5 Assignee: Unassigned Components: query-criteria Created: 27/Jun/2023 07:21 AM Environment: Spring Data JPA 3.1.1 Hibernate 6.2.5 Priority: Major Reporter: Michał Maliszewski ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ad7619... ) Assuming we have the following entity: @Entity @Table(name = "SOME_TABLE" ) public class SomeDbo { @Id @Column(name = "ID" , nullable = false ) private Long id; @Column(name = "SOME_ENUM" ) @Enumerated(EnumType.ORDINAL) private ESomeEnum type; // ... } and the following Data Access Object with a Query: @Repository @ApplicationScope public interface SomeDao { @Query( "select distinct s.id, max(s.type) as mx from SomeDbo s group by s.id order by mx" ) List< Object []> findSomeMax(); } would provide to the following exception: org.hibernate.QueryException: Parameter 1 of function max() has type COMPARABLE, but argument is of type com.some.enum.ESomeEnum This is a bit unpleasant as it was working well with Hibernate 5.6.x and still usage of: @Query( "select s from SomeDbo s where s.type = 1" ) List<SomeDbo> findSomeOfTypeOne(); works fine in Hibernate 6.2.5. The possible workaround I see for now is by doing: @Query("select distinct s.id, max(cast(s.type as Integer) as mx from SomeDbo s group by s.id order by mx") List<Object[]> findSomeMax(); instead, which obviously changed the Object [1] type which needs to be converted in the code back to ESomeEnum type. It seems that Enum handling needs improvements, as I see several similar issues, e.g. https://hibernate.atlassian.net/browse/HHH-16445. ( https://hibernate.atlassian.net/browse/HHH-16859#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16859#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

[JIRA] (HBX-2452) Implement and use the generic adapter for IQuery in the experimental Hibernate runtime

by Koen Aers (JIRA)

1 year, 8 months

1
0
0 / 0

[JIRA] (HHH-16858) Can't compare test expression of type [BasicSqmPathSource(type : Enum)] with element of type [basicType@5(java.lang.Integer,4)]

by Jonas Gernot Steinke (JIRA)

Jonas Gernot Steinke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2MxMzU0MjYy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16858?atlOrigin=eyJpIjoiN2MxMz... ) HHH-16858 ( https://hibernate.atlassian.net/browse/HHH-16858?atlOrigin=eyJpIjoiN2MxMz... ) Can't compare test expression of type [BasicSqmPathSource(type : Enum)] with element of type [basicType(a)5(java.lang.Integer,4)] ( https://hibernate.atlassian.net/browse/HHH-16858?atlOrigin=eyJpIjoiN2MxMz... ) Issue Type: Bug Affects Versions: 6.2.4, 6.2.5 Assignee: Unassigned Components: query-hql Created: 27/Jun/2023 07:07 AM Environment: Hibernate Version 6.2.5.Final JDK: azul-19.0.2 OS: Ubuntu 20.04.6 LTS MySQL 8.0.33-0ubuntu0.20.04.2 Priority: Major Reporter: Jonas Gernot Steinke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) With the update of Vaadin from version 14 to 24, Hibernate was also updated. In the process, I noticed a problem in the current Hibernate versions. Normally Vaadin 24 uses Hibernate 6.2.2.Final, but this version also has problems with generic types and I'm switching to 6.2.4.Final, that fixes it for another project. Now I found another issue in Hibernate also related to generic types. I have created a small Vaadin 24 project to illustrate the issue. This example can be found on GitHub: https://github.com/JGSteinke/hibernate-test I have created two classes ItemA and ItemB. ItemA uses an enum and ItemB extends AbstractItem. This uses a generic type which must be an enum. Now I want to use < with the enum field and a constant within an query. In the case of ItemA this is not a problem at all, but for ItemB I get the following exception: Can't compare test expression of type [BasicSqmPathSource(type : Enum)] with element of type [basicType(a)5(java.lang.Integer,4)] See following code snippets fore context. Actual sources are linked below. @MappedSuperclass public abstract class AbstractItem<T extends Enum<T>> extends AbstractEntity implements Item<T> { @Enumerated(EnumType.ORDINAL) @Column(name = "type" , nullable = false ) protected T type; @Override public T getType() { return type; } public void setType(T type) { this.type = type; } } https://github.com/JGSteinke/hibernate-test/blob/main/src/main/java/de/hi... @Entity @Table(name = "item_b" ) public class ItemB extends AbstractItem<ItemB.Type> { enum Type { B1, B2, B3; } } https://github.com/JGSteinke/hibernate-test/blob/main/src/main/java/de/hi... public interface ItemBRepository extends JpaRepository<ItemB, Long >, JpaSpecificationExecutor<ItemB> { @Query( "SELECT b FROM ItemB b WHERE b.type < 1" ) List<ItemB> findAllByTypeB2(); } https://github.com/JGSteinke/hibernate-test/blob/main/src/main/java/de/hi... I use types like ItemB in many cases on Hibernate 5.1.0 without problems. ( https://hibernate.atlassian.net/browse/HHH-16858#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16858#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#100227- sha1:3bc807d )

1 year, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues June 2023