I have a column called user id where names are stored as strings, i want to query them so that i get the list of records arranged alphabetically (i.e. the alphbatical order of user names,the primary key also happens to b the userid).I tried modifying the jaws.xml by giving in as follows ,but no change any ideas?
oraclepool
<type-mapping>Oracle8</type-mapping>
<enterprise-beans>
<ejb-name>IMFriendlistBean</ejb-name>
<table-name>TANGO_IM_FRIENDLIST</table-name>
<cmp-field>
<field-name>keyfield</field-name>
<column-name>KEYFIELD</column-name>
</cmp-field>
<cmp-field>
<field-name>Tango_Userid</field-name>
<column-name>TANGO_USERID</column-name>
</cmp-field>
<cmp-field>
<field-name>Groupid</field-name>
<column-name>TANGO_GROUPID</column-name>
</cmp-field>
<cmp-field>
<field-name>Friendid</field-name>
<column-name>TANGO_FRIENDID</column-name>
</cmp-field>
<!-- JBoss 2.4
-->
findByPrimaryKey
<![CDATA[(= 1 1)]]>
Tango_Userid
</enterprise-beans>
Tango_Userid is the column name, iwant to it to b retrieved fro m db in alphabetical order
I haven't used JAWS in over a year, but I remember the code in the 2.4 documentation does work.
http://www.jboss.org/online-manual/HTML/ch04s07.html