:(
I have tried so many times.
I created a HQL like this:
Code:
select auctionitem
from AuctionItem as auctionitem
left join auctionitem.bids as bid
group by auctionitem
order by count(bid)
the sql created by hibernate is
Code:
select auctionite0_.id as id, auctionite0_.description as descript2_, auctionite0_.ends as ends, auctionite0_.condition as condition, auctionite0_.seller as seller, auctionite0_.successfulBid as successf6_
from AuctionItem auctionite0_ left outer join Bid bids1_ on auctionite0_.id=bids1_.item
group by auctionite0_.id
order by count(bids1_.id)
but get a excetiop
Code:
Invalid use of group function
I use MySQL database.