Case insensitive using Hibernate criteria

Question

I have a query created using Hibernate Criteria, for example:

Criteria criteria = db.getSession().createCriteria(Vendor.class); criteria.addOrder(Property.forName("shortName").asc()); List<Vendor> vendorList = criteria.list(); 

I would like ordering to be case insensitive equivalent to HQL query

 FROM Vendor ve ORDER BY lower(ve.shortName) 

How can I achieve this using Hibernate criteria?

Answer 1

 criteria.addOrder(Order.asc("shortName").ignoreCase());