CriteriaQuery with Like predicate fails when repeated with java.lang.IllegalArgumentException: Parameter value [] did not match expected type [java.lang.String (n/a)]
Description
The call to entityManager.createQuery(criteriaQuery) fails when executed more then once for a CriteriaQuery containing a Like-predicate with a pattern parameter and an escape character literal. With an escape character parameter the problem does not exist.
Stracktrace:
java.lang.IllegalArgumentException: Parameter value [] did not match expected type [java.lang.String (n/a)]
There is no need to push anything towards Spring Data. As soon as the fix is released you can upgrade your dependency in your app and the next release of Spring Data JPA will reference the then latest version. So it will include the fix if it is available.
Chen WeiApril 1, 2022 at 2:10 AM
If the fix is released later, do you push the fix to the Spring team? Or we need to create a issue in Spring-Data
xtermi2March 29, 2022 at 9:51 AM
We have the exact same issue. I have also created a demo project where I can confirm, that this issue was added with hibernate version 5.6.6.Final`
Ptits de BarbeMarch 28, 2022 at 2:52 PM
Edited
BTW, this breaks Spring Data JPA’s findByFieldLike repository methods.
@Andreo Boriero, you’ve observed the merge of the causing issue. Could you please see to this too?
The call to
entityManager.createQuery(criteriaQuery)fails when executed more then once for a CriteriaQuery containing a Like-predicate with a pattern parameter and an escape character literal. With an escape character parameter the problem does not exist.Stracktrace:
java.lang.IllegalArgumentException: Parameter value [] did not match expected type [java.lang.String (n/a)]
Reproducer: