How i can concanete some fields with criteria API ?

sql example:
select * from person where concat(person.firstName,' ',person.middleName,' ',person.lastName) like '%aPerson%'


i try something like this... but doesn't work...

Criteria criteria = session.createCriteria(Person.class);
criteria.add(Expression.ilike("firstName middleName lastName ", keyWord));
criteria.list();

org.hibernate.QueryException: could not resolve property: firstName middleName lastName of: br.usp.lsi.contact.Person

tnx...

Markus Reichel

Is there any resolution on this? I've just hit the same problem.

I have found a workaround. I define a property formula in the mapping file which does the concatenation:



I can then refer to these properties in my search code:

I know this thread is old, but it is the one Google brought me to. Here is a solution using annotations. Note the formula is specific to Oracle (Using the double pipe "||" to concat).

From Person class:



From the query code:

It is possible to do this without formulas.

I posted an entry on my blog explaining how to do this:
http://whaticode.com/2013/02/01/hibernate-criteria-concatenate-fields-in-like-and-ilike-operators/
(too big to post here I believe).

It consists of creating a new Criterion for hibernate.
Appreciate any other ideas on the matter.