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

[azhao-mv]

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]

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?