I am trying to use the orderby function in weblogic and the method in 
which I have implemented I have shown in ejb-jar.xml and
weblogic-cmp-rdbms-jar.xml file shown below. Please do let me know if have
implemented it in the right way.

Thank you
Ronak Parekh

I am getthing the error:

Unable to deploy EJB: sempire_bc.jar from sempire_bc.jar:

        Error while reading 'META-INF/weblogic-cmp-rdbms-jar.xml'. The 
error
was:

        The finder method findAllOrderByRoleName of ejb RolesEJB cannot 
have
a null ejb ql value.
        The finder method findAllOrderByUserName of ejb UsersEJB cannot 
have
a null ejb ql value.

This is my weblogic-cmp-rdbms-jar.xml file:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE weblogic-rdbms-jar PUBLIC
 '-//BEA Systems, Inc.//DTD WebLogic 6.0.0 EJB RDBMS Persistence//EN'

'http://www.bea.com/servers/wls600/dtd/weblogic-rdbms20-persistence-
600.dtd'
>

<weblogic-rdbms-jar>
 <weblogic-rdbms-bean>
  <ejb-name>UsersEJB</ejb-name>
  <data-source-name>UsersDB</data-source-name>
  <table-name>USERS</table-name>
  <field-map>
          <cmp-field>iD</cmp-field>
          <dbms-column>ID</dbms-column>
        </field-map>
        <field-map>
          <cmp-field>userName</cmp-field>
   <dbms-column>USER_NAME</dbms-column>
        </field-map>
  <field-map>
   <cmp-field>userPass</cmp-field>
   <dbms-column>USER_PASS</dbms-column>
  </field-map>
  <weblogic-query>
         <query-method>
    <method-name>findAllOrderByUserName</method-name>
           <method-params>
              <method-param>double</method-param>
           </method-params>
         </query-method>
         <weblogic-ql>SELECT OBJECT(o) FROM o for UsersBean ORDERBY
o.userName</weblogic-ql>
  </weblogic-query>
  <weblogic-query>
         <query-method>
    <method-name>findAllOrderByUserPass</method-name>
           <method-params>
              <method-param>double</method-param>
           </method-params>
         </query-method>
   <weblogic-ql>SELECT OBJECT(o) FROM o for UsersBean ORDERBY
o.userPass</weblogic-ql>
      </weblogic-query>
 </weblogic-rdbms-bean>

 <weblogic-rdbms-bean>
  <ejb-name>RolesEJB</ejb-name>
  <data-source-name>RolesDB</data-source-name>
  <table-name>ROLES</table-name>
  <field-map>
          <cmp-field>iD</cmp-field>
          <dbms-column>ID</dbms-column>
        </field-map>
        <field-map>
          <cmp-field>roleName</cmp-field>
   <dbms-column>ROLE_NAME</dbms-column>
        </field-map>
  <field-map>
   <cmp-field>roleDesc</cmp-field>
   <dbms-column>ROLE_DESC</dbms-column>
  </field-map>
  <weblogic-query>
         <query-method>
    <method-name>findAllOrderByRoleName</method-name>
           <method-params>
              <method-param>double</method-param>
           </method-params>
         </query-method>
   <weblogic-ql>SELECT OBJECT(o) FROM o for RolesBean ORDERBY
o.roleName</weblogic-ql>
  </weblogic-query>
  <weblogic-query>
         <query-method>
    <method-name>findAllOrderByRoleDesc</method-name>
           <method-params>
              <method-param>double</method-param>
           </method-params>
         </query-method>
   <weblogic-ql>SELECT OBJECT(o) FROM o for RolesBean ORDERBY
o.roleDesc</weblogic-ql>
  </weblogic-query>
 </weblogic-rdbms-bean>

 <create-default-dbms-tables>True</create-default-dbms-tables>

</weblogic-rdbms-jar>

This is my ejb-jar.xml file:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE ejb-jar PUBLIC
 "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN"
   "http://java.sun.com/dtd/ejb-jar_2_0.dtd">

<ejb-jar>
 <display-name>Business Component CMP 2.0</display-name>

     <enterprise-beans>
        <entity>
  <display-name>Users Entity Bean</display-name>
         <ejb-name>UsersEJB</ejb-name>


<local-home>com.sempire.builder.business_component.UsersHome</local-home>
             <local>com.sempire.builder.business_component.Users</local>

<ejb-class>com.sempire.builder.business_component.UsersBean</ejb-class>

             <persistence-type>Container</persistence-type>
  <prim-key-class>java.lang.Integer</prim-key-class>
  <reentrant>False</reentrant>
             <cmp-version>2.x</cmp-version>

  <abstract-schema-name>users</abstract-schema-name>

  <cmp-field><field-name>iD</field-name></cmp-field>
  <cmp-field><field-name>userName</field-name></cmp-field>
  <cmp-field><field-name>userPass</field-name></cmp-field>
  <primkey-field>iD</primkey-field>

  <ejb-local-ref>
   <ejb-ref-name>UsersEJB</ejb-ref-name>
   <ejb-ref-type>Entity</ejb-ref-type>
   <local-home>com.sempire.builder.business_component.UsersHome</local-
home>
   <local>com.sempire.builder.business_component.Users</local>
  </ejb-local-ref>

  <resource-ref>
          <res-ref-name>jdbc/UsersDB</res-ref-name>
          <res-type>javax.sql.DataSource</res-type>
          <res-auth>Container</res-auth>
        </resource-ref>

  <query>
   <query-method>
    <method-name>findAllWithConstraint</method-name>
    <method-params />
   </query-method>
   <ejb-ql><![CDATA[SELECT OBJECT(o) FROM users AS o]]></ejb-ql>
  </query>
   <query>
                 <query-method>
                      <method-name>findAllOrderByUserName</method-name>
    <method-params />
                 </query-method>
   <ejb-ql></ejb-ql>
             </query>
             <query>
                 <query-method>
                      <method-name>findAllOrderByUserPass</method-name>
    <method-params />
                 </query-method>
                 <ejb-ql></ejb-ql>
             </query>
 </entity>

        <entity>
         <display-name>Roles Entity Bean</display-name>
             <ejb-name>RolesEJB</ejb-name>


<local-home>com.sempire.builder.business_component.RolesHome</local-home>
             <local>com.sempire.builder.business_component.Roles</local>

<ejb-class>com.sempire.builder.business_component.RolesBean</ejb-class>

  <persistence-type>Container</persistence-type>
  <prim-key-class>java.lang.Integer</prim-key-class>
             <reentrant>False</reentrant>
             <cmp-version>2.x</cmp-version>
  <abstract-schema-name>roles</abstract-schema-name>

  <cmp-field><field-name>iD</field-name></cmp-field>
  <cmp-field><field-name>roleName</field-name></cmp-field>
  <cmp-field><field-name>roleDesc</field-name></cmp-field>
  <primkey-field>iD</primkey-field>

  <ejb-local-ref>
   <ejb-ref-name>RolesEJB</ejb-ref-name>
   <ejb-ref-type>Entity</ejb-ref-type>
   <local-home>com.sempire.builder.business_component.RolesHome</local-
home>
   <local>com.sempire.builder.business_component.Roles</local>
  </ejb-local-ref>

  <resource-ref>
          <res-ref-name>jdbc/RolesDB</res-ref-name>
          <res-type>javax.sql.DataSource</res-type>
          <res-auth>Container</res-auth>
        </resource-ref>

  <query>
   <query-method>
    <method-name>findAllWithConstraint</method-name>
    <method-params />
   </query-method>
   <ejb-ql><![CDATA[SELECT OBJECT(o) FROM roles AS o]]></ejb-ql>
  </query>
  <query>
                 <query-method>
                      <method-name>findAllOrderByRoleName</method-name>
    <method-params />
   </query-method>
   <ejb-ql></ejb-ql>
             </query>
                <query>
                 <query-method>
                      <method-name>findAllOrderByRoleDesc</method-name>
                      <method-params />
                 </query-method>
                 <ejb-ql></ejb-ql>
             </query>
 </entity>

 </enterprise-beans>

 <assembly-descriptor>
     <container-transaction>
  <method>
             <ejb-name>UsersEJB</ejb-name>
             <method-name>*</method-name>
         </method>
         <method>
             <ejb-name>RolesEJB</ejb-name>
             <method-name>*</method-name>
         </method>
  <trans-attribute>Required</trans-attribute>
 </container-transaction>
 </assembly-descriptor>

</ejb-jar>