0 Replies Latest reply on Sep 19, 2002 2:52 PM by Konstantin

    Does JBoss really sort?

    Konstantin Newbie

      Hi guys, I try to get jboss to sort query results

      I put this in ejb-jar.xml:


      <query-method>
      <method-name>findByCustomerId</method-name>
      <method-params>
      <method-param>int</method-param>
      </method-params>
      </query-method>
      <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(ad) FROM Address AS ad WHERE ad.customerId = ?1]]></ejb-ql>


      and this into jbosscmp-jdbc.xml:

      <query-method>
      <method-name>findByCustomerId</method-name>
      <method-params>
      <method-param>int</method-param>
      </method-params>
      </query-method>
      <jboss-ql><![CDATA[SELECT DISTINCT OBJECT(ad) FROM Address AS ad WHERE ad.customerId = ?1 ORDER BY ad.description]]></jboss-ql>


      And it still does not sort. Could it be that hypersonic does not support sorting? Am I idiot?