Question Protected by cassiomolin

occurred Feb 22, 2019 at 13:45

Replaced `order` tag with `sql-order-by`.

edited Jun 5, 2016 at 20:56

Grammar; noise reduction.

edited Apr 14, 2016 at 15:54

When I write a HQL query

Query q = session.createQuery("SELECT cat from Cat as cat ORDER BY cat.mother.kind.value"); return q.list();

Everything is fine. However, when I write a Criteria

Criteria c = session.createCriteria(Cat.class); c.addOrder(Order.asc("mother.kind.value")); return c.list();

I get an exception org.hibernate.QueryException: could not resolve property: kind.value of: my.sample.data.entities.Cat

If I want to use Criteria and Order, how should I express my "order by"?

Cheers

Nik

When I write a HQL query

Query q = session.createQuery("SELECT cat from Cat as cat ORDER BY cat.mother.kind.value"); return q.list();

Everything is fine. However, when I write a Criteria

Criteria c = session.createCriteria(Cat.class); c.addOrder(Order.asc("mother.kind.value")); return c.list();

I get an exception org.hibernate.QueryException: could not resolve property: kind.value of: my.sample.data.entities.Cat

If I want to use Criteria and Order, how should I express my "order by"?

Cheers

Nik

When I write a HQL query

Query q = session.createQuery("SELECT cat from Cat as cat ORDER BY cat.mother.kind.value"); return q.list();

Everything is fine. However, when I write a Criteria

Criteria c = session.createCriteria(Cat.class); c.addOrder(Order.asc("mother.kind.value")); return c.list();

I get an exception org.hibernate.QueryException: could not resolve property: kind.value of: my.sample.data.entities.Cat

If I want to use Criteria and Order, how should I express my "order by"?

Tags do not belong in titles

edited Jul 16, 2014 at 18:39

Hibernate: ORDER BY using Criteria API

asked Nov 22, 2009 at 21:55

Loading

Return to Question