Case-insensitive equals using Hibernate Criteria

Asked 2009-03-09T00:13:16.903

I've seen Restrictions.ilike('property', '%value%'), but would like to generate SQL like: lower(property) = 'value'. Any ideas?

I used:

Restrictions.eq("email", email).ignoreCase()

since Expression is deprecated. The SimpleExpression will call toLowerCase() on the value, so it is not necessary to do it beforehand.

See: SimpleExpression source

java hibernate

Edit Report

1 Answer

I'm not absolutely sure, but when you use Restriction.eq you obtain a SimpleExpression object, and that object suppports an ignoreCase() operation which I've never tried using but sounds like it could make a difference.

Kudos to Hibernate for not documenting what this method actually does.

answered 2009-03-09T00:32:16.920

Case-insensitive equals using Hibernate Criteria

1 Answer

Your Answer