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?