ejb2.x finder method not working

[Sushma Sharma]

Hi,

I have got a really weird problem. Finder methods for one of my CMP EJBs are not working. I am using Weblogic 8.1 sp6, jdk1.4.2_05 and database is oracle 9i. The finder methods for other beans are working fine and returning me results, but not this ones. The corresponding oracle table has records and if I use jdbc, I get the records. The only difference in this bean and other beans is that this bean has a composite key and others don't.
I have total of 3 finder methods defined for this bean and none of these return any results. here are my classes and DDs

  
=====LocalHome===============================================
 
public interface AppCatLocalHome
   extends EJBLocalHome
{
   public AppCatLocal create()
      throws CreateException;
 
   public AppCatLocal create(AppCatData p_data)
      throws CreateException;
 
   public Collection findAll()
      throws FinderException;
 
   public AppCatLocal findByPrimaryKey(
   AppCatKey pk)
      throws FinderException;
 
   public Collection findAllByAppId(
   String appId)
      throws FinderException;
 
}
 

 
==============ejb-jar.xml==========================
 
      <entity id="ContainerManagedEntity_AppCat">
         <description><![CDATA[<!-- begin-xdoclet-definition -->]]></description>
 
         <ejb-name>AppCat</ejb-name>
 
         <local-home>com.bms.esetup2.admin.entity.ejb.AppCatLocalHome</local-home>
         <local>com.bms.esetup2.admin.entity.ejb.AppCatLocal</local>
 
         <ejb-class>com.bms.esetup2.admin.entity.ejb.AppCatBean</ejb-class>
         <persistence-type>Container</persistence-type>
         <prim-key-class>com.bms.esetup2.admin.entity.ejb.AppCatKey</prim-key-class>
         <reentrant>False</reentrant>
         <cmp-version>2.x</cmp-version>
         <abstract-schema-name>AppCatSCHEMA</abstract-schema-name>
         <cmp-field id="CMPAttribute_20">
            <description><![CDATA[<!-- begin-user-doc --> CMP Field appcat_app_id Returns the appcat_app_id]]></description>
            <field-name>appcat_app_id</field-name>
         </cmp-field>
         <cmp-field id="CMPAttribute_21">
            <description><![CDATA[<!-- begin-user-doc --> CMP Field appcat_cat_id Returns the appcat_cat_id]]></description>
            <field-name>appcat_cat_id</field-name>
         </cmp-field>
         <cmp-field id="CMPAttribute_22">
            <description><![CDATA[<!-- begin-user-doc --> CMP Field appcat_site_code Returns the appcat_site_code]]></description>
            <field-name>appcat_site_code</field-name>
         </cmp-field>
 
         <query>
            <query-method>
               <method-name>findAll</method-name>
               <method-params>
               </method-params>
            </query-method>
            <ejb-ql><![CDATA[SELECT OBJECT(a) FROM AppCatSCHEMA as a]]></ejb-ql>
         </query>
 
  <query>
 <query-method>
<method-name>findAllByAppId</method-name>
<method-params>
<method-param>java.math.BigDecimal</method-param>
</method-params>
 </query-method>
 
 <ejb-ql>
<![CDATA[SELECT OBJECT(a) FROM AppCatSCHEMA as a
WHERE a.appcat_app_id like ?1]]>
 </ejb-ql>
  </query>
      </entity>
      
      
========================weblogic-cmp-rdbms-jar.xml==========================
 
   <weblogic-rdbms-bean>
      <ejb-name>AppCat</ejb-name>
      <data-source-name>jdbc/CatalogDB <!-- end-xdoclet-definition --></data-source-name>
      <table-map>
      <table-name>APPS_CATS</table-name>
         <field-map>
         <cmp-field>appcat_app_id</cmp-field>
         <dbms-column>appcat_app_id</dbms-column>
         </field-map>
         <field-map>
            <cmp-field>appcat_cat_id</cmp-field>
         <dbms-column>appcat_cat_id</dbms-column>
         </field-map>
         <field-map>
            <cmp-field>appcat_site_code</cmp-field>
         <dbms-column>appcat_site_code</dbms-column>
         </field-map>
 
      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
 
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AppCatSCHEMA as a]]></weblogic-ql>
      </weblogic-query>
 
      <weblogic-query>
         <query-method>
            <method-name>findAllByAppId</method-name>
            <method-params>
            <method-param>java.math.BigDecimal</method-param>
            </method-params>
         </query-method>
 
         <weblogic-ql>
         <![CDATA[SELECT OBJECT(a) FROM AppCatSCHEMA as a
         WHERE a.appcat_app_id like ?1]]>
         </weblogic-ql>
      </weblogic-query>
 
   </weblogic-rdbms-bean>
   
   
====================== Key======================
 
public class AppCatKey implements Serializable {
 
static final long serialVersionUID = 878;
/**
 * @generated
 */
public BigDecimal appcat_app_id;
 
/**
 * @generated
 */
public BigDecimal appcat_cat_id;
 
/**
 * @generated
 */
public String appcat_site_code = "";
 
public AppCatKey() {
}
 
/**
 * Returns the hashCode.
 *@return int
 */
public int hashCode() {
int m_hashCode = 0;
if (0 == m_hashCode) {
int app_id_hash = (this.appcat_app_id != null) ? this.appcat_app_id.hashCode() : 0;
int cat_id_hash = (this.appcat_cat_id != null) ? this.appcat_cat_id.hashCode() : 0;
int site_hash = (this.appcat_site_code != null) ? this.appcat_site_code.hashCode() : 0;
 
m_hashCode = app_id_hash ^ cat_id_hash ^ site_hash ;
}
//System.out.println("AppCatKey:"+ toString() +" HashCode: " + m_hashCode);
return m_hashCode;
}
 
/**
 * Returns a boolean telling if the two objects are equals or not.
 *@return boolean
 */
    public boolean equals(Object other) {
    if (other == this) return true;
    if (null == other) return false;
    if (other.hashCode() != hashCode()) {
    return false;
    }
    if (! (other instanceof AppCatKey)) {
    return false;
    }
    AppCatKey other2 = (AppCatKey) other;
    boolean app_id_equal = false;
    if ((this.appcat_app_id == null) && other2.getAppcat_app_id() == null) {
    app_id_equal = true;
    } else if (this.appcat_app_id.compareTo(other2.getAppcat_app_id()) == 0) {
    app_id_equal = true;
    }
    boolean cat_id_equal = false;
    if ((this.appcat_cat_id == null) && other2.getAppcat_cat_id() == null) {
    cat_id_equal = true;
    } else if (this.appcat_cat_id.compareTo(other2.getAppcat_cat_id()) == 0) {
    cat_id_equal = true;
    }
    boolean site_code_equal = false;
    if ((this.appcat_site_code == null) && other2.getAppcat_site_code() == null) {
    site_code_equal = true;
    } else if (this.appcat_site_code.compareTo(other2.getAppcat_site_code()) == 0) {
    site_code_equal = true;
    }
if (app_id_equal && cat_id_equal
&& site_code_equal
) {
return true;
}
return false;
    }
    /**
     * Returns String representation of the class instance.
     *@return String
     */
public String toString() {
StringBuffer result = new StringBuffer("[AppCatKey ");
result.append("appcat_app_id:").append((null == appcat_app_id ? "null" : appcat_app_id.toString())).append(" ");
result.append("appcat_cat_id:").append((null == appcat_cat_id ? "null" : appcat_cat_id.toString())).append(" ");
result.append("appcat_site_code:").append((null == appcat_site_code ? "null" : appcat_site_code.toString())).append(" ");
result.append("]");
return result.toString();
}
 
/**
 * GETTERS AND SETTERS OF THE FIELDS
 */
 
}
 

=================================================================================================
  

I have no idea what I am doing wrong. create methods are working fine, I am able to insert new records. If anyone has any clue why it is behaving this way, please help.

Sushma