case DDConstants.SELECT_FOR_UPDATE_DISABLED:
      __WL_query = "SELECT WL0.DEPT_NO, WL0.EMP_NO, WL0.FIRST_NAME, WL0.FULL_NAME, WL0.HIRE_DATE, WL0.JOB_CODE, WL0.JOB_COUNTRY, WL0.JOB_GRADE, WL0.LAST_NAME, WL0.PHONE_EXT, WL0.SALARY  FROM EMPLOYEE WL0  WHERE WL0.EMP_NO = ? ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.DEPT_NO, WL0.EMP_NO, WL0.FIRST_NAME, WL0.FULL_NAME, WL0.HIRE_DATE, WL0.JOB_CODE, WL0.JOB_COUNTRY, WL0.JOB_GRADE, WL0.LAST_NAME, WL0.PHONE_EXT, WL0.SALARY  FROM EMPLOYEE WL0  WHERE WL0.EMP_NO = ?  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.DEPT_NO, WL0.EMP_NO, WL0.FIRST_NAME, WL0.FULL_NAME, WL0.HIRE_DATE, WL0.JOB_CODE, WL0.JOB_COUNTRY, WL0.JOB_GRADE, WL0.LAST_NAME, WL0.PHONE_EXT, WL0.SALARY  FROM EMPLOYEE WL0  WHERE WL0.EMP_NO = ?  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.Short __WL_pk = (java.lang.Short) __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, "empNo")) {        __WL_stmt.setShort(1, __WL_pk.shortValue());        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[5] || this.__WL_isModified[5])) {          this.deptNo = (java.lang.String)__WL_rs.getString(1+__WL_offset);          if (__WL_rs.wasNull()) {             this.deptNo = null;          }        }        else {          __WL_rs.getString(1+__WL_offset);        }        if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {          this.empNo = new Short(__WL_rs.getShort(2+__WL_offset));          if (__WL_rs.wasNull()) {             this.empNo = null;          }        }        else {          __WL_rs.getShort(2+__WL_offset);        }        if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {          this.firstName = (java.lang.String)__WL_rs.getString(3+__WL_offset);          if (__WL_rs.wasNull()) {             this.firstName = null;          }        }        else {          __WL_rs.getString(3+__WL_offset);        }        if (!(this.__WL_isLoaded[10] || this.__WL_isModified[10])) {          this.fullName = (java.lang.String)__WL_rs.getString(4+__WL_offset);          if (__WL_rs.wasNull()) {             this.fullName = null;          }        }        else {          __WL_rs.getString(4+__WL_offset);        }        if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {          this.hireDate = (java.sql.Timestamp)__WL_rs.getTimestamp(5+__WL_offset);          if (__WL_rs.wasNull()) {             this.hireDate = null;          }        }        else {          __WL_rs.getTimestamp(5+__WL_offset);        }        if (!(this.__WL_isLoaded[6] || this.__WL_isModified[6])) {          this.jobCode = (java.lang.String)__WL_rs.getString(6+__WL_offset);          if (__WL_rs.wasNull()) {             this.jobCode = null;          }        }        else {          __WL_rs.getString(6+__WL_offset);        }        if (!(this.__WL_isLoaded[8] || this.__WL_isModified[8])) {          this.jobCountry = (java.lang.String)__WL_rs.getString(7+__WL_offset);          if (__WL_rs.wasNull()) {             this.jobCountry = null;          }        }        else {          __WL_rs.getString(7+__WL_offset);        }        if (!(this.__WL_isLoaded[7] || this.__WL_isModified[7])) {          this.jobGrade = new Short(__WL_rs.getShort(8+__WL_offset));          if (__WL_rs.wasNull()) {             this.jobGrade = null;          }        }        else {          __WL_rs.getShort(8+__WL_offset);        }        if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {          this.lastName = (java.lang.String)__WL_rs.getString(9+__WL_offset);          if (__WL_rs.wasNull()) {             this.lastName = null;          }        }        else {          __WL_rs.getString(9+__WL_offset);        }        if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {          this.phoneExt = (java.lang.String)__WL_rs.getString(10+__WL_offset);          if (__WL_rs.wasNull()) {             this.phoneExt = null;          }        }        else {          __WL_rs.getString(10+__WL_offset);        }        if (!(this.__WL_isLoaded[9] || this.__WL_isModified[9])) {          this.salary = (java.math.BigDecimal)__WL_rs.getBigDecimal(11+__WL_offset);          if (__WL_rs.wasNull()) {             this.salary = null;          }        }        else {          __WL_rs.getBigDecimal(11+__WL_offset);        }        this.__WL_isLoaded[5] = true;        this.__WL_isLoaded[0] = true;        this.__WL_isLoaded[1] = true;        this.__WL_isLoaded[10] = true;        this.__WL_isLoaded[4] = true;        this.__WL_isLoaded[6] = true;        this.__WL_isLoaded[8] = true;        this.__WL_isLoaded[7] = true;        this.__WL_isLoaded[2] = true;        this.__WL_isLoaded[3] = true;        this.__WL_isLoaded[9] = true;        this.__WL_beanIsLoaded = true;
        
        
        __WL_beanIsLoaded = true;
        
      } else {
        if(__WL_verbose) {
          Debug.say("__WL_loadGroup0 could not find primary key " +
          __WL_pk);
        }
        Loggable l = EJBLogger.lognoSuchEntityExceptionLoggable(__WL_pk.toString());
        throw new NoSuchEntityException(l.getMessage());
        
      }
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }
    
    
  }  
    // loadGroup from ResultSet to bean method for the 'defaultGroup' group.  public void __WL_loadGroup0FromRS  (java.sql.ResultSet __WL_rs,   java.lang.Integer __WL_offsetIntObj,   testent.Employee_az16cs_Intf beanIntf)   throws java.sql.SQLException, java.lang.Exception  {    testent.Employee_az16cs__WebLogic_CMP_RDBMS __WL_bean = (testent.Employee_az16cs__WebLogic_CMP_RDBMS)beanIntf;    if (__WL_verbose) {      Debug.say("__WL_loadGroup0FromRS");    }        int __WL_offset = __WL_offsetIntObj.intValue();        if (!(__WL_bean.__WL_isLoaded[0] || __WL_bean.__WL_isModified[0])) {      __WL_bean.empNo = new Short(__WL_rs.getShort(1+__WL_offset));      if (__WL_rs.wasNull()) {         __WL_bean.empNo = null;      }    }    else {      __WL_rs.getShort(1+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[5] || __WL_bean.__WL_isModified[5])) {      __WL_bean.deptNo = (java.lang.String)__WL_rs.getString(2+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.deptNo = null;      }    }    else {      __WL_rs.getString(2+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[1] || __WL_bean.__WL_isModified[1])) {      __WL_bean.firstName = (java.lang.String)__WL_rs.getString(3+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.firstName = null;      }    }    else {      __WL_rs.getString(3+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[10] || __WL_bean.__WL_isModified[10])) {      __WL_bean.fullName = (java.lang.String)__WL_rs.getString(4+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.fullName = null;      }    }    else {      __WL_rs.getString(4+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[4] || __WL_bean.__WL_isModified[4])) {      __WL_bean.hireDate = (java.sql.Timestamp)__WL_rs.getTimestamp(5+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.hireDate = null;      }    }    else {      __WL_rs.getTimestamp(5+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[6] || __WL_bean.__WL_isModified[6])) {      __WL_bean.jobCode = (java.lang.String)__WL_rs.getString(6+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.jobCode = null;      }    }    else {      __WL_rs.getString(6+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[8] || __WL_bean.__WL_isModified[8])) {      __WL_bean.jobCountry = (java.lang.String)__WL_rs.getString(7+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.jobCountry = null;      }    }    else {      __WL_rs.getString(7+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[7] || __WL_bean.__WL_isModified[7])) {      __WL_bean.jobGrade = new Short(__WL_rs.getShort(8+__WL_offset));      if (__WL_rs.wasNull()) {         __WL_bean.jobGrade = null;      }    }    else {      __WL_rs.getShort(8+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[2] || __WL_bean.__WL_isModified[2])) {      __WL_bean.lastName = (java.lang.String)__WL_rs.getString(9+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.lastName = null;      }    }    else {      __WL_rs.getString(9+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[3] || __WL_bean.__WL_isModified[3])) {      __WL_bean.phoneExt = (java.lang.String)__WL_rs.getString(10+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.phoneExt = null;      }    }    else {      __WL_rs.getString(10+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[9] || __WL_bean.__WL_isModified[9])) {      __WL_bean.salary = (java.math.BigDecimal)__WL_rs.getBigDecimal(11+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.salary = null;      }    }    else {      __WL_rs.getBigDecimal(11+__WL_offset);    }    __WL_bean.__WL_isLoaded[5] = true;    __WL_bean.__WL_isLoaded[0] = true;    __WL_bean.__WL_isLoaded[1] = true;    __WL_bean.__WL_isLoaded[10] = true;    __WL_bean.__WL_isLoaded[4] = true;    __WL_bean.__WL_isLoaded[6] = true;    __WL_bean.__WL_isLoaded[8] = true;    __WL_bean.__WL_isLoaded[7] = true;    __WL_bean.__WL_isLoaded[2] = true;    __WL_bean.__WL_isLoaded[3] = true;    __WL_bean.__WL_isLoaded[9] = true;    __WL_bean.__WL_beanIsLoaded = true;    __WL_beanIsLoaded = true;  }  
  
  
  public static Object __WL_getPKFromRS(java.sql.ResultSet __WL_rs, java.lang.Integer __WL_offsetIntObj, ClassLoader __WL_classLoader)
  throws java.sql.SQLException, java.lang.Exception
  {
    int __WL_offset = __WL_offsetIntObj.intValue();    
    java.lang.Short __WL_pk = null;
    
    __WL_pk = new Short(__WL_rs.getShort(1+__WL_offset));    if (__WL_rs.wasNull()) {       __WL_pk = null;    }    
    
    return __WL_pk;
  }
  
  public Object __WL_getPKFromRSInstance(java.sql.ResultSet __WL_rs, java.lang.Integer __WL_offsetIntObj, ClassLoader __WL_classLoader)
  throws java.sql.SQLException, java.lang.Exception
  {
    return __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);
  }
  
  //End finder methods.
  //=================================================================
  
  //=================================================================
  //Home methods.
  
  
  //End home methods.
  //=================================================================
  
  //=================================================================
  // ejbSelect methods defined in this Bean's abstract class
  
  
  
  
  //=================================================================
  // ejbSelectInternal methods that are to run in this Bean
  
  
  
  
  
  //=================================================================
  
  // ================================================================
  // Implementation of CMPBean
  public void __WL_setup(java.util.Map bmMap, PersistenceManager __WL_pm) {
    if (__WL_verbose) {
      Debug.say("Employee_az16cs__WebLogic_CMP_RDBMS.setup called.");
    }
    if (__WL_debug) {
      Debug.assertion(bmMap!=null);
      Debug.assertion(__WL_pm !=null);
    }
    this.__WL_pm = (RDBMSPersistenceManager)__WL_pm; 
    this.__WL_classLoader = this.__WL_pm.getClassLoader();
    if (__WL_debug) {
      Debug.assertion(this.__WL_classLoader != null);
    }
    
    
  }
  
  public EntityContext __WL_getEntityContext() {
    return __WL_ctx;
  }
  
  public Object __WL_getPrimaryKey() {
    java.lang.Short __WL_pk = null;        __WL_pk = this.empNo;    return __WL_pk;    
  }
  
  public void __WL_superEjbLoad()  {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJBLOAD;
      super.ejbLoad();
    } finally {
      __WL_method_state = oldState;
    }
  }
  
  public void __WL_superEjbStore()  {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJBSTORE;
      if (__WL_verbose) {
        Debug.say("__WL_superEjbStore "+ __WL_ctx.getPrimaryKey());
      }
      super.ejbStore();
    } finally {
      __WL_method_state = oldState;
    }
  }
  
  public void __WL_superEjbRemove()  throws javax.ejb.RemoveException {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJB_REMOVE;
      if (__WL_verbose) {
        Debug.say("__WL_superEjbRemove " + __WL_ctx.getPrimaryKey());
      }
      super.ejbRemove();