try {        __WL_isMulti = __WL_rs.next();      } catch (Exception ignore) { }      
      
      if (__WL_pkMap.size() == 0) {
        if(__WL_verbose) {
          Debug.say("Throwing FinderException because bean wasn't found.");
        }
        throw new javax.ejb.ObjectNotFoundException("Bean with primary key '" + param0.toString() + "' was not found by 'findByPrimaryKey'.");
      }
      if (__WL_isMulti || __WL_pkMap.size() > 1) {
        throw new javax.ejb.FinderException("finder/ejbSelect 'findByPrimaryKey'" +
        "has returned more than one value.  We were expecting only ONE value. "+
        " See EJB Spec 10.5.6.1, 10.5.7.1");
      }
      return __WL_eo;
    } catch (javax.ejb.FinderException fe) {
      throw fe;
    } catch (java.sql.SQLException sqle) {
      throw new javax.ejb.FinderException(
      "Problem in findByPrimaryKey while preparing or executing " +
      "statement: '" +
      __WL_stmt + "': " + EOL +
      sqle.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(sqle));
    } catch (Exception e) {
      throw new javax.ejb.FinderException(
      "Exception raised in findByPrimaryKey " + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }
      }    
  
    // loadGroup method for the 'defaultGroup' group.  public void __WL_loadGroup0() throws Exception {    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;
    
    int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
    
    java.lang.String __WL_query;
    
    // http://bugs.beasys.com/CRView?CR=CR070260
    //
    //  optimization.
    
    switch(selectForUpdateVal) {
      case DDConstants.SELECT_FOR_UPDATE_DISABLED:
      __WL_query = "SELECT WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.supplierName, WL0.supplierZone, WL0.zipCode  FROM supplier WL0  WHERE WL0.supplierName = ? ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.supplierName, WL0.supplierZone, WL0.zipCode  FROM supplier WL0  WHERE WL0.supplierName = ?  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.supplierName, WL0.supplierZone, WL0.zipCode  FROM supplier WL0  WHERE WL0.supplierName = ?  FOR UPDATE NOWAIT ";
      break;
      
      default:
      throw new AssertionError(
      "Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
    }
    
    
    
    try {
      if (__WL_verbose) {
        Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey());
      }
      
      java.lang.String __WL_pk = (java.lang.String) __WL_ctx.getPrimaryKey();
      
      __WL_con = __WL_pm.getConnection();
      
      
      __WL_stmt = __WL_con.prepareStatement(__WL_query);
      
      // preparedStatementParamIndex reset.
            if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "supplierName")) {        __WL_stmt.setString(1, __WL_pk);        if (__WL_verbose) {          Debug.say("paramIdx :"+1+" binded with value :"+__WL_pk);        }      }      
      
      if (__WL_verbose) {
        Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey() + 
        ", executeQuery: "+__WL_query);
      }
      
      __WL_rs = __WL_stmt.executeQuery();
      if (__WL_rs.next()) {
        
        if (__WL_verbose) {
          Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey() + 
          " now read columns from Results.");
        }
        
        
        if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {          this.abbreviation = (java.lang.String)__WL_rs.getString(1+__WL_offset);          if (__WL_rs.wasNull()) {             this.abbreviation = null;          }        }        else {          __WL_rs.getString(1+__WL_offset);        }        if (!(this.__WL_isLoaded[9] || this.__WL_isModified[9])) {          this.address = (java.lang.String)__WL_rs.getString(2+__WL_offset);          if (__WL_rs.wasNull()) {             this.address = null;          }        }        else {          __WL_rs.getString(2+__WL_offset);        }        if (!(this.__WL_isLoaded[12] || this.__WL_isModified[12])) {          this.bankAccount = (java.lang.String)__WL_rs.getString(3+__WL_offset);          if (__WL_rs.wasNull()) {             this.bankAccount = null;          }        }        else {          __WL_rs.getString(3+__WL_offset);        }        if (!(this.__WL_isLoaded[11] || this.__WL_isModified[11])) {          this.bankName = (java.lang.String)__WL_rs.getString(4+__WL_offset);          if (__WL_rs.wasNull()) {             this.bankName = null;          }        }        else {          __WL_rs.getString(4+__WL_offset);        }        if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {          this.companyPhone = (java.lang.String)__WL_rs.getString(5+__WL_offset);          if (__WL_rs.wasNull()) {             this.companyPhone = null;          }        }        else {          __WL_rs.getString(5+__WL_offset);        }        if (!(this.__WL_isLoaded[13] || this.__WL_isModified[13])) {          this.email = (java.lang.String)__WL_rs.getString(6+__WL_offset);          if (__WL_rs.wasNull()) {             this.email = null;          }        }        else {          __WL_rs.getString(6+__WL_offset);        }        if (!(this.__WL_isLoaded[7] || this.__WL_isModified[7])) {          this.fax = (java.lang.String)__WL_rs.getString(7+__WL_offset);          if (__WL_rs.wasNull()) {             this.fax = null;          }        }        else {          __WL_rs.getString(7+__WL_offset);        }        if (!(this.__WL_isLoaded[8] || this.__WL_isModified[8])) {          this.fixedPhone = (java.lang.String)__WL_rs.getString(8+__WL_offset);          if (__WL_rs.wasNull()) {             this.fixedPhone = null;          }        }        else {          __WL_rs.getString(8+__WL_offset);        }        if (!(this.__WL_isLoaded[14] || this.__WL_isModified[14])) {          this.homesite = (java.lang.String)__WL_rs.getString(9+__WL_offset);          if (__WL_rs.wasNull()) {             this.homesite = null;          }        }        else {          __WL_rs.getString(9+__WL_offset);        }        if (!(this.__WL_isLoaded[5] || this.__WL_isModified[5])) {          this.linkman = (java.lang.String)__WL_rs.getString(10+__WL_offset);          if (__WL_rs.wasNull()) {             this.linkman = null;          }        }        else {          __WL_rs.getString(10+__WL_offset);        }        if (!(this.__WL_isLoaded[6] || this.__WL_isModified[6])) {          this.mobilePhone = (java.lang.String)__WL_rs.getString(11+__WL_offset);          if (__WL_rs.wasNull()) {             this.mobilePhone = null;          }        }        else {          __WL_rs.getString(11+__WL_offset);        }        if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {          this.pyCode = (java.lang.String)__WL_rs.getString(12+__WL_offset);          if (__WL_rs.wasNull()) {             this.pyCode = null;          }        }        else {          __WL_rs.getString(12+__WL_offset);        }        if (!(this.__WL_isLoaded[15] || this.__WL_isModified[15])) {          this.remark = (java.lang.String)__WL_rs.getString(13+__WL_offset);          if (__WL_rs.wasNull()) {             this.remark = null;          }        }        else {          __WL_rs.getString(13+__WL_offset);        }        if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {          this.supplierName = (java.lang.String)__WL_rs.getString(14+__WL_offset);          if (__WL_rs.wasNull()) {             this.supplierName = null;          }        }        else {          __WL_rs.getString(14+__WL_offset);        }        if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {          this.supplierZone = (java.lang.String)__WL_rs.getString(15+__WL_offset);          if (__WL_rs.wasNull()) {             this.supplierZone = null;          }        }        else {          __WL_rs.getString(15+__WL_offset);        }        if (!(this.__WL_isLoaded[10] || this.__WL_isModified[10])) {          this.zipCode = (java.lang.String)__WL_rs.getString(16+__WL_offset);          if (__WL_rs.wasNull()) {             this.zipCode = null;          }        }        else {          __WL_rs.getString(16+__WL_offset);        }        this.__WL_isLoaded[3] = true;        this.__WL_isLoaded[9] = true;        this.__WL_isLoaded[12] = true;        this.__WL_isLoaded[11] = true;        this.__WL_isLoaded[4] = true;        this.__WL_isLoaded[13] = true;        this.__WL_isLoaded[7] = true;        this.__WL_isLoaded[8] = true;        this.__WL_isLoaded[14] = true;        this.__WL_isLoaded[5] = true;        this.__WL_isLoaded[6] = true;        this.__WL_isLoaded[2] = true;        this.__WL_isLoaded[15] = true;        this.__WL_isLoaded[0] = true;        this.__WL_isLoaded[1] = true;        this.__WL_isLoaded[10] = true;        this.__WL_beanIsLoaded = true;
        
        
        __WL_beanIsLoaded = true;
      } else {
        if(__WL_verbose) {
          Debug.say("__WL_loadGroup0 could not find primary key " +
          __WL_pk);
        }
        throw new NoSuchEntityException("Bean with " +
        "primary key: '" + __WL_pk + "' not found.");
      }
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }
    
    
  }  
    // loadGroup from ResultSet to bean method for the 'defaultGroup' group.  public stockmanagementpro.SupplierBean_qfsutw__WebLogic_CMP_RDBMS  __WL_loadGroup0FromRS  (java.sql.ResultSet __WL_rs,   java.lang.Integer __WL_offsetIntObj,   Object __WL_pk,  stockmanagementpro.SupplierBean_qfsutw__WebLogic_CMP_RDBMS __WL_bean)  throws java.sql.SQLException, java.lang.Exception  {    if (__WL_verbose) {      Debug.say("__WL_loadGroup0FromRS");    }        int __WL_offset = __WL_offsetIntObj.intValue();        if (__WL_pk == null) {      if (!(__WL_bean.__WL_isLoaded[0] || __WL_bean.__WL_isModified[0])) {        __WL_bean.supplierName = (java.lang.String)__WL_rs.getString(1+__WL_offset);        if (__WL_rs.wasNull()) {           __WL_bean.supplierName = null;        }      }      else {        __WL_rs.getString(1+__WL_offset);      }    } else {      __WL_bean.__WL_setPrimaryKey((java.lang.String) __WL_pk);    }    if (!(__WL_bean.__WL_isLoaded[3] || __WL_bean.__WL_isModified[3])) {      __WL_bean.abbreviation = (java.lang.String)__WL_rs.getString(2+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.abbreviation = null;      }    }    else {      __WL_rs.getString(2+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[9] || __WL_bean.__WL_isModified[9])) {      __WL_bean.address = (java.lang.String)__WL_rs.getString(3+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.address = null;      }    }    else {      __WL_rs.getString(3+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[12] || __WL_bean.__WL_isModified[12])) {      __WL_bean.bankAccount = (java.lang.String)__WL_rs.getString(4+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.bankAccount = null;      }    }    else {      __WL_rs.getString(4+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[11] || __WL_bean.__WL_isModified[11])) {      __WL_bean.bankName = (java.lang.String)__WL_rs.getString(5+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.bankName = null;      }    }    else {      __WL_rs.getString(5+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[4] || __WL_bean.__WL_isModified[4])) {      __WL_bean.companyPhone = (java.lang.String)__WL_rs.getString(6+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.companyPhone = null;      }    }    else {      __WL_rs.getString(6+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[13] || __WL_bean.__WL_isModified[13])) {      __WL_bean.email = (java.lang.String)__WL_rs.getString(7+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.email = null;      }    }    else {      __WL_rs.getString(7+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[7] || __WL_bean.__WL_isModified[7])) {      __WL_bean.fax = (java.lang.String)__WL_rs.getString(8+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.fax = null;      }    }    else {      __WL_rs.getString(8+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[8] || __WL_bean.__WL_isModified[8])) {      __WL_bean.fixedPhone = (java.lang.String)__WL_rs.getString(9+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.fixedPhone = null;      }    }    else {      __WL_rs.getString(9+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[14] || __WL_bean.__WL_isModified[14])) {      __WL_bean.homesite = (java.lang.String)__WL_rs.getString(10+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.homesite = null;      }    }    else {      __WL_rs.getString(10+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[5] || __WL_bean.__WL_isModified[5])) {      __WL_bean.linkman = (java.lang.String)__WL_rs.getString(11+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.linkman = null;      }    }    else {      __WL_rs.getString(11+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[6] || __WL_bean.__WL_isModified[6])) {      __WL_bean.mobilePhone = (java.lang.String)__WL_rs.getString(12+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.mobilePhone = null;      }    }    else {      __WL_rs.getString(12+__WL_offset);