Hibernate version:2.1.7

Hi I am trying to convert a JDBC query:

"and lower(concatenate(e.first_name,' ',e.last_name'))
like lower('%"+off.getDriverName()+"%')");

Into a QBE query..

criteria.add(Expression.ilike("firstName surName", offence.getDriverName(), MatchMode.ANYWHERE));

Is there any elegant way of doing this?

I could split the getDriverName() based on spaces and break the query into a like (first_name) OR like (surname) or something...

but a cleaner solution would be nicer :)

Any ideas?



Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I am trying to replace:

and concatenate(e.first_name,' ',e.last_name')) like '%aperson%')

in QBE?

Is there anyway of setting up some sort of Hibernate field fullName view? that consists of the firstName and lastName fields? and then reference that field in the QBE query?

Did you resolve this? I'm having 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: