I'm doing a search query (using criteria), using a search string like "Bruce Willis".



And in Java I WANT TO do this:

instead of


How do I define "fullName" when I have two columns of firstName and lastName?

it depends on your database SQL, by example in postgresql:

<property name="fullName" type="string"
formula="FIRSTNAME_ACTOR || ' ' || LASTNAME_ACTOR"/>

or in mysql:

<property name="fullName" type="string"
formula="CONCAT(FIRSTNAME_ACTOR , ' ' , LASTNAME_ACTOR)" />

Using Oracle.

I'll explain in depth:
You must use a formula inside a property, this formula must contain a database-dependent instruction to concatenate two strings.

So if you're using oracle you must try reading an oracle reference http://www.psoug.org/reference/string_func.html

This is (maybe) the whole enchilada:

Since Oracle Concat function can only have two parameters, you must try something like this:

<property name="fullName" type="string" formula="(CONCAT( CONCAT(FIRSTNAME_ACTOR , ' ') , LASTNAME_ACTOR))" />

Excellent. Thanks for your help, the problem has been solved!

I used the following:



This seems to work in Oracle.

It is possible to do this without formulas, by creating a new Criterion.

I posted an entry on my blog explaining:
http://whaticode.com/2013/02/01/hibernate-criteria-concatenate-fields-in-like-and-ilike-operators/

I hope it helps. The lack of such functionality is really a turn-off.