EJB-QL Order By Problem

[kryptontri]

Hi, I know there is an issue with the order by clause AFAIK with ekb2.0

Can somebody provide an example implementation for this ? I know that you have to define the signature in jboss.xml ? or jboss.XX cmp-jdbc.xml etc ?

Any Ideas people ? Or at least direct me to a relevant link, i can't seem to find much in the forums etc ?

TIA

K

[kryptontri]

come on people .... any ideas ? Adrian ? marcF ? send us a link or something, i'm just looking for a concrete example ... the web does not yield much results and i know i am not the only one :-(( arggg ...

[kryptontri]

bahhh i found the info elsewhere :-) so problem solved.

[kryptontri]

bahhh i found the info elsewhere :-) so problem solved.

[kryptontri]

bahh no its not. I'm using jboss3.05.rc1, deploy works fine, no complaints by jboss, but further inspection in debug mode shows that the order by clause is not being used in the sql statements :-(

[kryptontri]

dammit i am answering my own q's, anyway, got the docs, will solve the issue once i get read it ...

:-) dammit where is everybody .... :-)
heh heh

[kryptontri]

heh heh ... my own thread. ... hmmm Threads. .... hmm :-)

[kryptontri]

http://home.pacbell.net/toms/bungholio.htm

[juhalindfors]

leave the <ejb-ql> element empty in ejb-jar.xml and write a matching <jboss-ql> in the jbosscmp-jdbc.xml, with order by