Eclipse Community Forums: EclipseLink » Not able to build a criteria with "like expression"

Home » Eclipse Projects » EclipseLink » Not able to build a criteria with "like expression"

Not able to build a criteria with "like expression" [message #1008463]

Tue, 12 February 2013 10:29

Eclipse User

Hi,

I am trying to build a criteria query with a like expression, but I am not able to find a way, it compiles. I tried the following and some hints from the wiki, but no success so far.

CriteriaBuilder cb = getEntityManger().getCriteriaBuilder();
CriteriaQuery<ST> cr = cb.createQuery(searchType);

Root<ST> root = (Root<ST>) cr.from(searchType);
EntityType<ST> type = getEntityManger().getMetamodel().entity(searchType);

String field = "name";

if (StringUtils.isNotEmpty(enteredValue)){
Predicate and = cb.Like(root.get(field), "Jeff");
cr.where(and);
}
I am using latest eclipselink stable version I think.

Here is a list of jars:

javax.persistence_2.0.4.v201112161009.jar
eclipselink-jpa-modelgen_2.4.1.v20121003-ad44345.jar
eclipselink.jar

Any help would be great, spent hours Sad

Thank you

Marcus

Re: Not able to build a criteria with "like expression" [message #1008664 is a reply to message #1008463]

Wed, 13 February 2013 09:08

Eclipse User

One day later I found the solution by myself.
Just, if someone also needs it:

Write
if (StringUtils.isNotEmpty(enteredValue)){
Predicate and = cb.Like(root.<String>get(field), "Jeff");
cr.where(and);
}

and everything works fine.

Previous Topic:	EclipseLink merge fails to insert
Next Topic:	Multitenancy and @EmbeddedId

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 07:22:48 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter