question of the example in hibernate2.1.3

MarkDong · **Joined:** Tue Apr 27, 2004 2:36 am **Posts:** 12

I want get a list of users which be sorted by the size of user.bids

so I write a HQL like this

Code:

select user from User as user order by user.bids

it caught a exception

Code:

net.sf.hibernate.QueryException: unindexed collection before []: user0_.bids [select user from org.hibernate.auction.User as user order by user.bids]

how can I write this HQL??????

christian · **Posted:** Sat May 01, 2004 12:24 pm

select user from User as user join user.bids as bid order by bid.amount

MarkDong · **Joined:** Tue Apr 27, 2004 2:36 am **Posts:** 12

I change it to

Code:

select user from User as user join user.bids as bid group by user order by bid.amount

It works correctly

thank you!

christian · **Posted:** Sat May 01, 2004 12:52 pm

Oh, btw, don't use "user" as an alias (keyword in some dialects), use "as uzer" or something like that.

MarkDong · **Joined:** Tue Apr 27, 2004 2:36 am **Posts:** 12

I'm back, sorry, hehe

I don't understand why sorted by the bid.amount.

I want sorted by the size of user.bids..

I think the HQL is NOT CORRECT now.... :(