0 Replies Latest reply on Nov 28, 2002 6:48 AM by Konstantin

    hiypersonic sorting problem.

    Konstantin Newbie

      Hi all,

      I'm experiencing problems with sorting
      my finder results when I use DefaultDS.
      Well, it does not sort at all.

      While using postgres, everything works as
      it should.

      ejb-ql:

      <![CDATA[find all customers sorted alphabetically]]>
      <query-method>
      <method-name>findAll</method-name>
      <method-params>
      </method-params>
      </query-method>
      <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(cu) FROM Customer AS cu WHERE cu.id > 0]]></ejb-ql>


      jboss-ql:


      <query-method>
      <method-name>findAll</method-name>
      <method-params>
      </method-params>
      </query-method>
      <jboss-ql><![CDATA[SELECT OBJECT(cu) FROM Customer AS cu ORDER BY cu.customerName]]></jboss-ql>



      Do I miss something important?