}
    
    if(__WL_verbose) {
      Debug.say("Finder produced statement string " + __WL_query);
    }
    
    
    
    try {
      __WL_con = __WL_pm.getConnection();
    } 
    catch (java.lang.Exception e) {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
      throw new javax.ejb.FinderException("Couldn't get connection: " + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    }
    
    
    
    try {
      
      __WL_stmt = __WL_con.prepareStatement(__WL_query);
      // preparedStatementParamIndex reset.
            if (param0 == null) {        __WL_stmt.setNull(1,java.sql.Types.VARCHAR);      } else {        __WL_stmt.setString(1, param0);        if (__WL_verbose) {          Debug.say("paramIdx :"+1+" binded with value :"+param0);        }      }      
      __WL_rs = __WL_stmt.executeQuery();
      
      
            Map __WL_pkMap = new HashMap();      
      while (__WL_rs.next()) {
                Integer __WL_offsetIntObj = new Integer(0);        Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);        if (__WL_pk != null) {           __WL_bean = (com.xc.hotelmanager.hotel.control.entity.TbCustomer_vrnevs__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool();          __WL_bean.__WL_initialize();          __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean);                    __WL_eo = __WL_pm.finderCacheInsert(__WL_bean, __WL_getIsLocal());          if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);          __WL_pkMap.put(__WL_pk, __WL_bean);        }                
      }
      
      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_pkMap.size() != 1) {
        Loggable l = EJBLogger.logfinderReturnedMultipleValuesLoggable("findByPrimaryKey");
        throw new javax.ejb.FinderException(l.getMessage());
      }
      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 __WL_offset = 0;
    
    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.cid, WL0.cname, WL0.cnote, WL0.csex, WL0.cstuts  FROM Customer WL0  WHERE WL0.cid = ? ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.cid, WL0.cname, WL0.cnote, WL0.csex, WL0.cstuts  FROM Customer WL0  WHERE WL0.cid = ?  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.cid, WL0.cname, WL0.cnote, WL0.csex, WL0.cstuts  FROM Customer WL0  WHERE WL0.cid = ?  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, "cid")) {        __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[0] || this.__WL_isModified[0])) {          this.cid = (java.lang.String)__WL_rs.getString(1+__WL_offset);          if (__WL_rs.wasNull()) {             this.cid = null;          }        }        else {          __WL_rs.getString(1+__WL_offset);        }        if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {          this.cname = (java.lang.String)__WL_rs.getString(2+__WL_offset);          if (__WL_rs.wasNull()) {             this.cname = null;          }        }        else {          __WL_rs.getString(2+__WL_offset);        }        if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {          this.cnote = (java.lang.String)__WL_rs.getString(3+__WL_offset);          if (__WL_rs.wasNull()) {             this.cnote = null;          }        }        else {          __WL_rs.getString(3+__WL_offset);        }        if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {          this.csex = (java.lang.String)__WL_rs.getString(4+__WL_offset);          if (__WL_rs.wasNull()) {             this.csex = null;          }        }        else {          __WL_rs.getString(4+__WL_offset);        }        if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {          this.cstuts = (java.lang.String)__WL_rs.getString(5+__WL_offset);          if (__WL_rs.wasNull()) {             this.cstuts = null;          }        }        else {          __WL_rs.getString(5+__WL_offset);        }        this.__WL_isLoaded[0] = true;        this.__WL_isLoaded[1] = true;        this.__WL_isLoaded[4] = true;        this.__WL_isLoaded[2] = true;        this.__WL_isLoaded[3] = 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,   com.xc.hotelmanager.hotel.control.entity.TbCustomer_vrnevs_Intf beanIntf)   throws java.sql.SQLException, java.lang.Exception  {    com.xc.hotelmanager.hotel.control.entity.TbCustomer_vrnevs__WebLogic_CMP_RDBMS __WL_bean = (com.xc.hotelmanager.hotel.control.entity.TbCustomer_vrnevs__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.cid = (java.lang.String)__WL_rs.getString(1+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.cid = null;      }    }    else {      __WL_rs.getString(1+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[1] || __WL_bean.__WL_isModified[1])) {      __WL_bean.cname = (java.lang.String)__WL_rs.getString(2+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.cname = null;      }    }    else {      __WL_rs.getString(2+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[4] || __WL_bean.__WL_isModified[4])) {      __WL_bean.cnote = (java.lang.String)__WL_rs.getString(3+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.cnote = null;      }    }    else {      __WL_rs.getString(3+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[2] || __WL_bean.__WL_isModified[2])) {      __WL_bean.csex = (java.lang.String)__WL_rs.getString(4+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.csex = null;      }    }    else {      __WL_rs.getString(4+__WL_offset);    }    if (!(__WL_bean.__WL_isLoaded[3] || __WL_bean.__WL_isModified[3])) {      __WL_bean.cstuts = (java.lang.String)__WL_rs.getString(5+__WL_offset);      if (__WL_rs.wasNull()) {         __WL_bean.cstuts = null;      }    }    else {      __WL_rs.getString(5+__WL_offset);    }    __WL_bean.__WL_isLoaded[0] = true;    __WL_bean.__WL_isLoaded[1] = true;    __WL_bean.__WL_isLoaded[4] = true;    __WL_bean.__WL_isLoaded[2] = true;    __WL_bean.__WL_isLoaded[3] = 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.String __WL_pk = null;
    
    __WL_pk = (java.lang.String)__WL_rs.getString(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("TbCustomer_vrnevs__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.String __WL_pk = null;        __WL_pk = this.cid;    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();
      
      
      
      
      // initialize state before this instance goes back into the pool
      if (!__WL_getIsRemoved()) __WL_initialize();
      
    } finally {
      __WL_method_state = oldState;
    }
    
  }
  
  public void __WL_copyFrom(CMPBean otherBean, boolean __WL_initSnapshotVars) {
    TbCustomer_vrnevs__WebLogic_CMP_RDBMS __WL_bean = null;    try {      __WL_bean = (TbCustomer_vrnevs__WebLogic_CMP_RDBMS)otherBean;    } catch (RuntimeException re) {
      if (__WL_verbose) {
        Debug.say("rethrowing RuntimeException.");
        re.printStackTrace();
      }
      throw re;
    } catch (Exception ex) {
      if (__WL_verbose) {
        Debug.say("wrapping Exception in PersistenceRuntimeException.");
        ex.printStackTrace();
      }
      throw new PersistenceRuntimeException(ex);
    }
    if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {      if (__WL_bean.__WL_isLoaded[0]) {        if (__WL_verbose) {          Debug.say("copying field 'cid' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.cid = __WL_bean.cid;        this.__WL_isLoaded[0] = true;        if (!__WL_initSnapshotVars) this.__WL_isModified[0] = true;      }    }        if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {      if (__WL_bean.__WL_isLoaded[1]) {        if (__WL_verbose) {          Debug.say("copying field 'cname' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.cname = __WL_bean.cname;        this.__WL_isLoaded[1] = true;        if (!__WL_initSnapshotVars) this.__WL_isModified[1] = true;      }    }        if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {      if (__WL_bean.__WL_isLoaded[2]) {        if (__WL_verbose) {          Debug.say("copying field 'csex' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.csex = __WL_bean.csex;        this.__WL_isLoaded[2] = true;        if (!__WL_initSnapshotVars) this.__WL_isModified[2] = true;      }    }        if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {      if (__WL_bean.__WL_isLoaded[3]) {        if (__WL_verbose) {          Debug.say("copying field 'cstuts' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.cstuts = __WL_bean.cstuts;        this.__WL_isLoaded[3] = true;        if (!__WL_initSnapshotVars) this.__WL_isModified[3] = true;      }    }        if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {      if (__WL_bean.__WL_isLoaded[4]) {        if (__WL_verbose) {          Debug.say("copying field 'cnote' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.cnote = __WL_bean.cnote;        this.__WL_isLoaded[4] = true;        if (!__WL_initSnapshotVars) this.__WL_isModified[4] = true;      }    }        this.__WL_modifiedBeanIsRegistered = __WL_bean.__WL_modifiedBeanIsRegistered;    this.__WL_beanIsLoaded = __WL_bean.__WL_beanIsLoaded;        
  }
  
  public void __WL_loadGroupByIndex(int index, java.sql.ResultSet rs,