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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Tue, 12 February 2013 15:29

Marcus Schulz

Messages: 5
Registered: February 2013
Location: Germany

Junior Member

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

Report message to a moderator

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

Wed, 13 February 2013 14:08

Marcus Schulz

Messages: 5
Registered: February 2013
Location: Germany

Junior Member

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:37:52 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter