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

[fhh]

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/navId.3/navSetId._/vtTopicFile.htmlhelp_rwbuild_hs%7Crwwhthow%7Cwhatare%7Cdmobj%7Csq_a_bind_references~htm/)
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#4009579

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4009579