[jboss-user] [EJB 3.0] - Re: @NamedQuery and setting orderBy as a parameter?

anonymous wrote : | that doesn't work!! That's not a named query. | It is not a named query but it does work. Why are you so keen on using a named query of you are not going to profit from it. The restriction of not using a bind variable is - as far as I know - a restriction of databases not of the JPA provider. There is a work around for that if you are using Oracle (http://www.oracle.com/webapps/online-help/reports/10.1.2/state/content/na...) but to use it you will have to use a native query. Regards Felix View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4009579#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...