Spring Data JPA: Specification with "like" and Long

Question

I have the following problem. I used spring-data and i want to create a "like" statement for a Long Property. I have tried the following, but without success. ``` private Specification createSpecification() { return new Specification() { @Override public Predicate toPredicate(final Root root, final CriteriaQuery query, final CriteriaBuilder cb) { final Predicate like = query.where(cb.like(root. get("kundenNr"), "%4%")).getRestriction(); return like; } }; } ``` and domain class ``` public class Kunde implements Serializable { @ColumnYB(lable = "KundenNr.", order = 1) @Id @javax.persistence.Column(nullable = false, name = "kundennr") protected Long kundenNr; @ColumnYB(lable = "Deaktiviert") @Column(nullable = false) private boolean deaktiviert = false; @Column(name = "kundenart") private String kundenart; ... ``` I get the following error. ``` org.springframework.dao.InvalidDataAccessApiUsageException: Parameter value [%4%] did not match expected type [java.lang.Long…

Accepted Answer

That's because `kundenNr`in your entity class is a `Long`, and `%4%` doesn't parse as long.

In SQL, the % sign in the query is only appliable to varchar (and some variants), so it's not possible to use it on a long field, which probably is translated to a numeric field in the database.

Spring Data JPA: Specification with "like" and Long

Solution

Problem

Related problems