Hibernate version:
2.1

In the WHERE clause you can specify the key with props.['key'] which is incredibly convenient. How do I order by the same value though? In the ORDER BY clause, the same syntax gives me a " net.sf.hibernate.QueryException: Incorrect query syntax "

Here's the query: select distinct ga from GroupAsset ga where ga.metadata.properties['Version'] between :verStart and :verEnd order by ga.metadata.properties['Version'] asc

If I replace ga.metadata.properties['Version'] with ga.status, the query works, so the problem is the indexed collection syntax in the ORDER BY clause. Presumably it's simply not allowed in the order by clause, but what's the alternative to get the equivalent ordering?

Thanks,
Chris

For indexed collection order is fixed: index defines the collection order.

If you want to reorder the collection then you can do it programmatically /Collections.sort() /, but make sure that you do it outside of transaction otherwise H will try to prsist the collection with using new indexes.

Hi,

I have the same problem/wich...

Is it still not possible to do something like that :



Thanks for your response.

See section 6.3 in reference documentation. You could use createFilter to order collection.

sortedUsers = s.createFilter( group.getUsers(), "order by this.name" ).list();