0 Replies Latest reply on Apr 17, 2007 4:27 AM by Zalder R

    ejq-ql subquery in seam

    Zalder R Newbie

      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 )


      but I get the error :

      Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: query [select t from com.[...].MyObject t order by ( select 1 ) ]


      any hint ? (I guess I'm doing some stupid mistake somewhere ...)