ORDER BY

jaime Sep 3, 2002 8:59 AM

Does JBoss support a query with ORDER BY clause????

Thanks

JaimeS

1. Re: ORDER BY

jcordes Sep 3, 2002 9:48 AM (in response to jaime)

Hi Jaime !

Yes. Just specify a jboss-ql element for your entity bean in jbosscmp-jdbc.xml (have a look at the dtd in the docs directory). In general the jboss-ql statement looks pretty much the same than the ejb-ql statement (just append your ORDER BY clause).

Hope it helps,

Jochen.

P.S.: The latest release also includes some nice extensions. Have a look sourceforge and the release-notes for JBoss-3.0.2.
Actions