tricky hibernate criteria

Question

Hi,

I have a sql statement which I want to move it into hibernate criteria, but I am not clue how to do this.

The problem is one of the WHERE clause which looks like the following

...(skip other parts)... ? ILIKE strprefix||'%' ...(continue)

strprefix is the column name, the ? is the place i need to fill in the value.

With criteria, I can use

criteria.add(Expression.ilike(propertyName, value));

but in this case, how can i do this.

Thanks in advance!

Answer 1

You can't do this in Criteria, columns are set since they represent the properties in your domain object. You need to query against the property not the other way around.

Answer 2

but since sql statement can do that, i wonder if there is something equivalent in hibernate.

for example, I have a value 'abcde 126783', and in table, there store strprefix as abcde, so it will bring back that entry in database.

Answer 3

You can likely handle this with Restrictions.sqlRestriction(String sql).