JPA/Criteria API - Like & equal problem JPA/Criteria API - Like & equal problem java java

JPA/Criteria API - Like & equal problem


Perhaps you need

criteria.add(cb.like(emp.<String>get("name"), p));

because first argument of like() is Expression<String>, not Expression<?> as in equal().

Another approach is to enable generation of the static metamodel (see docs of your JPA implementation) and use typesafe Criteria API:

criteria.add(cb.like(emp.get(Employee_.name), p));

(Note that you can't get static metamodel from em.getMetamodel(), you need to generate it by external tools).


Better: predicate (not ParameterExpression), like this :

List<Predicate> predicates = new ArrayList<Predicate>();if(reference!=null){    Predicate condition = builder.like(root.<String>get("reference"),"%"+reference+"%");    predicates.add(condition);}


It will work with a small addition of .as(String.class):

criteria.add(cb.like(emp.get("name").as(String.class), p));