I believe what I want to do is not possible, I just wanted to confirm...

I have a parent child relationship (Test/Question) using a List. As the user takes the test online I display each question on it's own screen. When a question is answered, I query for the Test and get the next Question using List.get(index).

I was trying to figure out if it is possible to load a question directly without having to load the Test and all Questions first. However, without using native SQL I can not see a way to include the list index field in an HQL query?

I'm a right or did I miss something.

Thanks in advance,
Chris....

HQL also provides the built-in index() function, for elements of a one-to-many association or collection of values.

Michael -

Thanks! That's exactly what I was looking for in Hibernate.

<feeling like an idiot>
I usually am able to find things like this when I read the documentation or forums....

Just overlooked it...
</>

Chris....