this might be a little off topic since it's an ejb-ql question but I'm using it inside seam and I think maybe my error will be obvious to some of you.
I'm simply trying to execute a simple (test) subquery like this :
select t from MyObject t order by ( select 1 )
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: query [select t from com.[...].MyObject t order by ( select 1 ) ]