Hi,

Using Criteria query api, how do I write a where condition, which will give me list of equipments for case-insensitive equipment names, I have available in a Collection.

I understand that for case sensitive where clause, I can use the following ...

I already have a list of equipment names in namesCollection converted to upper case.

Criteria criteria = session.createCriteria(Equipment.class);
criteria.add(Expression.in("equipmentName", namesCollection));
List equipList = criteria.list();

To ignore case, I also want to add something like upper function to equipmentName. How do I do that, using Criteria query API.

Please advise.

Thanks

JP



Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: Hibernate 3

Mapping documents: None

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

Full stack trace of any exception that occurs: None

Name and version of the database you are using: Oracle 9i

The generated SQL (show_sql=true): None

Debug level Hibernate log excerpt:

Hi J_p,

I need to do something similar. Did you find out the answer?

FYI: You can do case insensitive LIKE criteria using Expression.ilike.

Hi
You can do like this

criteria.add(Expression.in("equipmentName", namesCollection).ignoreCase);

or u can use ilike

This Does not work

To apply ignorcase you can use this:

Criteria crit=session.createCriteria(Disc.class);
crit.add(Expression.ilike("title","%ill%")); // ilike means ignorecase
crit.add(Expression.eq("language","english").ignoreCase()); //trivial
crit.list();

or you can use this one:

Criteria crit=session.createCriteria(Disc.class);
crit.add(Expression.like("title","bill",MatchMode.ANYWHERE).ignoreCase());
crit.list();