HQL functions: index, maxindex, minindex

damianharvey · **Posted:** Tue Jun 10, 2008 6:38 am

Hello,

I am trying to use the HQL functions like index, maxindex and minindex however Hibernate (or the IDE) is not recognising them.

For example from the documentation:

Code:

select item, index(item) from Order order 
    join order.items item
where index(item) < 5

However I get an org.hibernate.MappingException stating that the Property index does not exist in the collection Order.items.

I am using Hibernate 3.2.4.sp1. Elcipse 3.3.2 running JBoss Tools 2.1.0.GA.

Is anyone using these functions? Does this sound more like an IDE / Jboss Tools problem?

Thanks,

Damian.

damianharvey · **Posted:** Tue Jun 10, 2008 6:49 am

Same result on the server so it's not the IDE.

Cheers,

Damian.

damianharvey · **Posted:** Tue Jun 10, 2008 7:05 am

Found the problem / solution.

I had my collection defined as a List on the parent entity, but I had no @IndexColumn specified. As soon as I add this then all of these functions work.

Maybe it's a tip that could be added to the Hibernate EntityManager documentation in chapter 7.8?

Cheers,

Damian.

Cameron McKenzie · **Posted:** Tue Jun 10, 2008 9:18 am

Thanks for posting the solution!