Hibernate version:
2.1.4


I'm looking for some help on the following issue.

SQLServer performs all string comparisons in a case insensitive fashion.
So, to preserve this behavior on oracle, we have to make our queries such that they all code in case insensitivity.

Using the hibernate API is to do this is not entirely possible from what i've seen.

It is very easy for the SimpleExpression operations (=,<,>,<=,>=) by using the "ignoreCase" method on SimpleExpression, and the like expression (using ilike).

However, we also need to make sure that between, in, and the property operators (propEq, etc...) can case insensitive. However, there is no convenient "ignoreCase" method on these API's.

I've tried using "upper(property)" as the property name, but that causes
an exception, since hibernate expects an exact property name.

I've also tried building the hql, and using Expression.sql, but that doesn't work since it expects column names in that case, and I get a column not found error.

Anyone have any ideas?