Spring Boot 3.3.0 breaks generated SQL statements from a JPQL by putting inconsistent database column name in result set and order by clause leading to SQL Exception. about spring-boot

[scottfrederick]

Spring Boot itself it not involved in generating SQL queries - that is done by Hibernate or JPA. Spring Boot 3.2.6 uses Hibernate 6.4.8.Final and Spring Data BOM 2023.1.6, while Spring Boot 3.3.0 uses Hibernate 6.5.2.Final and Spring Data BOM 2024.0.0. It is likely that the changes you are seeing are the result of these library upgrades. You can narrow this down by keeping Spring Boot 3.3.0 and overriding the version of these dependencies with Maven or Gradle. If you can identify one of those library upgrades as the source of the problem, you can file an issue with the appropriate project.

If you can't narrow it down to a dependency version, and you would like us to take a closer look, then we will need a sample project that reproduces the problem and that we can run ourselves. You can share it with us by pushing it to a separate repository on GitHub or by zipping it and attaching it to this issue.

[dulshand]

@scottfrederick Thank you for the quick response. I will see if I can narrow the issue to Hibernate 6.5.2.Final. I will let you know my findings.

[dulshand]

@scottfrederick I can now confirm that the issue is in Hibernate 6.5.2.Final referenced by Spring Data BOM. I did the following in my pom.xml and the issue dissapeared.

org.springframework.boot spring-boot-starter-data-jpa org.hibernate.orm hibernate-core org.hibernate.orm hibernate-core 6.4.8.Final But there will be a time that we will eventually have to move beyond this version of Hibernate. As a result I will see how I can raise an issue with Hibernate project.

[scottfrederick]

Thanks for letting us know. I'll close this issue, feel free to add a comment with a link to a Hibernate issue if you create one.

[dulshand]

I have created an issue with Hibernate regarding this. https://hibernate.atlassian.net/browse/HHH-18253