Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Casting to String no longer works in JPA criteria query since 6.6. Global search not working with non-string column. #166

Closed
azhao-mv opened this issue Dec 17, 2024 · 2 comments
Closed

Casting to String no longer works in JPA criteria query since 6.6. Global search not working with non-string column. #166

azhao-mv opened this issue Dec 17, 2024 · 2 comments
Labels
bug

Comments

@azhao-mv
Copy link

Hey Damien,

Thanks for your great work.

Run into an issue with latest hibernate. And I found this: Casting to String no longer works in JPA criteria query since hibernate 6.6

See also:
https://hibernate.atlassian.net/browse/HHH-18710
https://docs.jboss.org/hibernate/orm/6.6/migration-guide/migration-guide.html#criteria-query

Thanks,

Allen
@darrachequesne
Copy link
Owner

Hi! Thanks for the heads-up, I could indeed reproduce the issue: https://github.com/darrachequesne/spring-data-jpa-datatables/actions/runs/12390393198/job/34585315142

According to the ticket, we will be able to call express.cast() in JPA 3.2/Hibernate 7 (currently in beta: https://github.com/hibernate/hibernate-orm/releases/tag/7.0.0.Beta3).

Not sure how we could work around this with Hibernate 6.6.x though. Any ideas?

@darrachequesne darrachequesne pinned this issue Jan 27, 2025
gianluca1606 added a commit to gianluca1606/spring-data-jpa-datatables that referenced this issue Feb 11, 2025
@gianluca1606
dep: Update Spring Boot to 3.4.0
6e6ed13 
Related to darrachequesne#166
Expression.as() doesn’t do anymore a real type conversions. Workaround with JpaExpression and cast.
@gianluca1606 gianluca1606 mentioned this issue Feb 11, 2025
Merged
darrachequesne pushed a commit that referenced this issue Feb 12, 2025
@gianluca1606
feat: upgrade to Spring Boot 3.4.0 (#168)
fd5c9f7 
`hibernate-core` is upgraded from `6.4.x` to `6.6.x`, which contains an important breaking change regarding type casts: 

> `Expression.as()` doesn’t do anymore a real type conversions, it’s just an unsafe typecast on the Expression object itself.

Reference: https://docs.jboss.org/hibernate/orm/6.6/migration-guide/migration-guide.html#criteria-query

Note: this change is not compatible with older versions of Spring Boot, as `JpaExpression.cast()` was added in `[email protected]`.

Related: #166
@darrachequesne
Copy link
Owner

This should be fixed by fd5c9f7, included in version 7.0.0.

Thanks for the heads-up 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@darrachequesne @azhao-mv