Hi,

I'm trying to do the following with HQL:

<query name="findCurrentCompanies">
<![CDATA[
select distinct(company) from Company company
order by company.longName :arg_0
]]>
</query>

Where :arg_0 is a parameter representing sort direction e.g. asc or desc.

Running this gives:

org.hibernate.hql.ast.QuerySyntaxException: unexpected token

I believe parameters can be used in the order by clause; am I to assume that they cannot be used for the sort direction.

Thanks in advance,

Martin.

Yes, they can't be used that way, because named parameters are converted to SQL positional parameters, and they can't be used for order direction. You'll have to have multiple named queries (one for each order combination you need), or switch to Criteria.