I am using DetachedCriteria to build a query dynamically, and need to add a "order by" clause:
order by locate('keyword', name) desc

I tried
criteria.addOrder(Order.desc("locate('keyword', name)");

But I got error, complaining
locate('keyword', name) is not a valid property.

So Order.desc only accepts property, not expression.

Is there a workaround?

Thanks,
Dave

hi javatwo

You can use your custom locate method which map property by user given value. Why every thing you guys are expecting from Hibernate. Hibernate is not a magic.

locate('keyword', name)

Hi Dharmendra,

Thanks for your reply. But I do not understand the solution you suggested. It would be great if you can explain it to me in more detail. Thanks!
Dave