mysql order by field equivalent in hibernate

Question

How do I accomplish this custom sort by field feature available in MySQL in hibernate?

select * from pet order by field(species, 'cat', 'dog', 'bird');

For some business reason, I need to enforce a custom ordering.

PS -I am new to hibernate.

Not sure if we have something same in hibernate but below links describes all types of sort in hibernate http://www.baeldung.com/hibernate-sort — LearningPhase, Apr 07 '16 at 16:11
Possible duplicate of [SQL multiple column ordering](http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering) — docksteaderluke, Apr 07 '16 at 17:27

score 0 · Accepted Answer · answered Apr 08 '16 at 16:23

0

I ended up writing an HQL like this

commaDelimitedSpecies = "'cat', 'dog', 'bird'";
orderBySpecies = " ORDER BY FIELD(species, " + commaDelimitedSpecies + ")  DESC";
Query q = getSession().createQuery("FROM PetModel pet" + orderBySpecies);

answered Apr 08 '16 at 16:23

pranay

444
1
7
20

score 0 · Answer 2 · answered May 07 '19 at 16:54

With Spring HibernateDAO:

getHibernateTemplate().findByNamedParametersQuery(
"FROM MyEntity me WHERE me.id IN :ids ORDER BY FIELD(id, :ids)", new String[] {"ids"}, new Object[] {uuidList.toArray()},uuidList.size()
);

Note: getHibernateTemplate returns an instance of org.springframework.orm.hibernate3.HibernateTemplate

mysql order by field equivalent in hibernate

2 Answers2