Hi everyBody !!!
well I want to know how can I do this query with ejb-ql:
SELECT * FROM documents WHERE docid =x ORDER BY docname ASC
I did try with this code but didn't running
query="SELECT OBJECT(d) FROM documents d where d.docid=?1 order by ?2 ?3"
Parameters are not supported in OrderBy clause. There should be numeric-, string- or datetime-valued path.