Convert string to int in Hibernate order criterion

Viewed 14195

Basically, my question is the same as this one, but for Java's (JBoss) Hibernate: How can we order a column as int using hibernate criteria API?

I want to create an order restriction with a cast to int from a string column. Something like

criteria.addOrder(Order.asc("cast(id as int)"));

The exception is "Could not resolve property: cast(id as int) of [Class]". I've tried both cast( as ) and convert(,) with int and integer.

2 Answers
Related