WebSVN – DevTools – Diff – /buildtool/trunk/src/generated/com/erggroup/buildtool/ripple/ReleaseManager.java



 
  /**collection of RunLevel objects
   * @attribute
   */
  private Vector<RunLevel> mRunLevelCollection = new Vector<RunLevel>();
  
  /**in daemon mode
   *   select gm.gbe_value from release_config rc, gbe_machtype gm
   *   where rc.rtag_id=<baseline> and gm.gbe_id=rc.gbe_id;
   * in escrow mode
   *   select gm.gbe_value from boms b, release_manager.release_config rc,

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryMachtypes show stopper");
          throw new Exception("queryMachtypes show stopper");
        }
      }
    }
  }
 

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryBaselineName show stopper");
          throw new Exception("queryBaselineName show stopper");
        }
      }
    }
    mLogger.info("queryBaselineName returned " + retVal);
    return retVal;

      try
      {
        if (daemonMode)
        {
          Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();
 
 
 
 
 
 
 
 
 
 
 
 
 
          globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());
 
 
 
 
 
 
          CallableStatement stmt0 = mConnection.prepareCall(
          "select u.user_email " +
          "from release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u, release_manager.views v, release_manager.release_tags rt " +
          "where rt.rtag_id=" + baseline + " " +

            
            if ( rset1.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset1 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset1 null pv_id");
            }
            
            int pkg_id = rset1.getInt("pkg_id");
            
            if ( rset1.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset1 null pkg_id " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset1 null pkg_id " + pv_id);
            }
 
            String pkg_name = rset1.getString("pkg_name");
             
            if ( pkg_name == null )
            {
              mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset1 null pkg_name " + pv_id);
            }
 
            String v_ext = rset1.getString("v_ext");
             
            if ( v_ext == null )

            
            if ( rset2.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset2 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset2 null pv_id");
            }
            
            Package p = findPackage(pv_id, packageCollection);
            
            if ( p == NULL_PACKAGE )

            
            if ( pkg_name == null )
            {
              mLogger.fatal("queryPackageVersions rset2 null pkg_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset2 null pkg_name " + pv_id);
            }
            
            String v_ext = rset2.getString("v_ext");
            
            if ( v_ext == null )

            
            if ( rset3.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset3 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset3 null pv_id");
            }
             
            Package p = findPackage(pv_id, packageCollection);
             
            if ( p == NULL_PACKAGE )

             
            if ( bm_name == null )
            {
              mLogger.fatal("queryPackageVersions rset3 null bm_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset3 null bm_name " + pv_id);
            }
             
            String bsa_name = rset3.getString("bsa_name");
             
            if ( bsa_name == null )
            {
              mLogger.fatal("queryPackageVersions rset3 null bsa_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset3 null bsa_name " + pv_id);
            }
 
            if ( !ignore )
            {
              boolean supportedBuildStandard = true;

             
            if ( rset4.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset4 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset4 null pv_id");
            }
             
            Package p = findPackage(pv_id, packageCollection);
             
            if ( p == NULL_PACKAGE )

             
            if ( test_type_name == null )
            {
              mLogger.fatal("queryPackageVersions rset4 null test_type_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset4 null test_type_name " + pv_id);
            }
             
            if ( !ignore )
            {
              if ( test_type_name.compareTo("Autobuild UTF") == 0 )

             
            if ( rset50.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset50 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset50 null pv_id");
            }
              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )

             
            if ( rset5.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset5 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset5 null pv_id");
            }
              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )

             
            if ( rset51.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset51 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset51 null pv_id");
            }
              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )

              
            if ( rset7.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset7 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset7 null pv_id");
            }
               
            Package p = findPackage(pv_id, packageCollection);
               
            if ( p == NULL_PACKAGE )

            
            if ( rset8.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset8 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset8 null pv_id");
            }
            
            int pkg_id = rset8.getInt("pkg_id");
            
            if ( rset8.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset8 null pkg_id " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset8 null pkg_id " + pv_id);
            }
            
            String pkg_name = rset8.getString("pkg_name");
            
            if ( pkg_name == null )
            {
              mLogger.fatal("queryPackageVersions rset8 null pkg_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset8 null pkg_name " + pv_id);
            }
            
            String pkg_version = rset8.getString("pkg_version");
            
            if ( pkg_version == null )
            {
              mLogger.fatal("queryPackageVersions rset8 null pkg_version " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset8 null pkg_version " + pv_id);
            }
            
            String v_ext = rset8.getString("v_ext");
            
            if ( v_ext == null )

             
            if ( rset9.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset9 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset9 null pv_id");
            }
             
            int dpv_id = rset9.getInt(2);
             
            if ( rset9.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset9 null dpv_id " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset9 null dpv_id " + pv_id);
            }
             
            Package p = findPackage(pv_id, packageCollection);
             
            if ( p == NULL_PACKAGE )

             
            if ( pkg_name == null )
            {
              mLogger.fatal("queryPackageVersions rset9 null pkg_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset9 null pkg_name " + pv_id);
            }
             
            String v_ext = rset9.getString("v_ext");
             
            if ( v_ext == null )

             
            if ( rset10.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset10 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset10 null pv_id");
            }
              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )

              
            if ( bm_name == null )
            {
              mLogger.fatal("queryPackageVersions rset10 null bm_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset10 null bm_name " + pv_id);
            }
              
            String bsa_name = rset10.getString("bsa_name");
              
            if ( bsa_name == null )
            {
              mLogger.fatal("queryPackageVersions rset10 null bsa_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset10 null bsa_name " + pv_id);
            }
 
            if ( !ignore )
            {
              boolean supportedBuildStandard = true;

              
            if ( rset11.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset11 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset11 null pv_id");
            }
              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )

              
            if ( test_type_name == null )
            {
              mLogger.fatal("queryPackageVersions rset11 null test_type_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset11 null test_type_name " + pv_id);
            }
              
            if ( !ignore )
            {
              if ( test_type_name.compareTo("Autobuild UTF") == 0 )

             
            if ( rset120.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset120 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset120 null pv_id");
            }
              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )

              
            if ( rset12.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset12 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset12 null pv_id");
            }
               
            Package p = findPackage(pv_id, packageCollection);
               
            if ( p == NULL_PACKAGE )

               
            if ( rset14.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset14 null pv_id");
              // show stopper
              throw new Exception("queryPackageVersions rset14 null pv_id");
            }
                
            Package p = findPackage(pv_id, packageCollection);
                
            if ( p == NULL_PACKAGE )

              
            if ( rset.wasNull() )
            {
              mLogger.fatal("queryPackageVersions rset null prod_id");
              // show stopper
              throw new Exception("queryPackageVersions rset null prod_id");
            }
              
            String pkg_name = rset.getString("pkg_name");
              
            if ( pkg_name == null )
            {
              mLogger.fatal("queryPackageVersions rset null pkg_name " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset null pkg_name " + pv_id);
            }
              
            String pkg_version = rset.getString("pkg_version");
              
            if ( pkg_version == null )
            {
              mLogger.fatal("queryPackageVersions rset null pkg_version " + pv_id);
              // show stopper
              throw new Exception("queryPackageVersions rset null pkg_version " + pv_id);
            }
              
            String v_ext = rset.getString("v_ext");
             
            if ( v_ext == null )

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryPackageVersions show stopper");
          throw new Exception("queryPackageVersions show stopper");
        }
      }
    }
    
    if (!daemonMode)

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryMailServer show stopper");
          throw new Exception("queryMailServer show stopper");
        }
      }
    }
    
    mLogger.info("queryMailServer returned " + retVal);

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryMailSender show stopper");
          throw new Exception("queryMailSender show stopper");
        }
      }
    }
 
    mLogger.debug("queryMailSender returned " + retVal);
    return retVal;
  }
 
  /**only used in daemon mode
   * select u.user_email from release_manager.build_service_config bsc, users u
   * where bsc.service='GLOBAL EMAIL ADDRESS LIST' and u.full_name=bsc.config
   * returns the configured global email addresses
   */
  String queryGlobalAddresses() throws SQLException, Exception
  {
    mLogger.debug("queryGlobalAddresses");
    String retVal = new String();
 
    if ( !mUseDatabase )
    {
      mLogger.info("queryGlobalAddresses !mUseDatabase");
      // a highly unlikely address
      retVal = "buildadm@erggroup.com";
    }
    else
    {
      try
      {
        CallableStatement stmt = mConnection.prepareCall(
        "select u.user_email from release_manager.build_service_config bsc, users u " +
        "where bsc.service='GLOBAL EMAIL ADDRESS LIST' and u.full_name=bsc.config"
        );
        ResultSet rset = stmt.executeQuery();
        
        while( rset.next() )
        {
          String email = rset.getString("user_email");
           
          if ( email != null )
          {
            retVal += email;
          }
        }
            
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {
          mLogger.error("queryGlobalAddresses database access error only");
          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryGlobalAddresses show stopper");
          throw new Exception("queryGlobalAddresses show stopper");
        }
      }
    }
 
    mLogger.debug("queryGlobalAddresses returned " + retVal);
    return retVal;
  }
 
  /**called only in escrow mode
   * if checkCollection is true, checks the pv_id is in the packageCollection
   * if checkCollection is false, or the pv_id is not in the collection
   * 1 traverses the pv_id package dependencies
   *   select dpv.pv_id, p.pkg_name, dpv.pkg_version, dpv.v_ext, dpv.pkg_label, dpv.src_path

            
            if ( rset.wasNull() )
            {
              mLogger.fatal("traverseDependencies null pv_id");
              // show stopper
              throw new Exception("traverseDependencies null pv_id");
            }
            
            String pkg_name = rset.getString("pkg_name");
            
            if ( pkg_name == null )
            {
              mLogger.fatal("traverseDependencies null pkg_name " + pv_id);
              // show stopper
              throw new Exception("traverseDependencies null pkg_name " + pv_id);
            }
            
            String pkg_version = rset.getString("pkg_version");
            
            if ( pkg_version == null )
            {
              mLogger.fatal("traverseDependencies null pkg_version " + pv_id);
              // show stopper
              throw new Exception("traverseDependencies null pkg_version " + pv_id);
            }
            
            String v_ext = rset.getString("v_ext");
            
            if ( v_ext == null )

            throw new SQLException();
          }
          else
          {
            mLogger.fatal("traverseDependencies show stopper");
            throw new Exception("traverseDependencies show stopper");
          }
        }
      }
      
      for (Iterator<Package> it = resultset.iterator(); it.hasNext(); )

          
          if ( bm_name == null )
          {
            mLogger.fatal("queryBuildInfo null bm_name " + p.mId);
            // show stopper
            throw new Exception("queryBuildInfo null bm_name " + p.mId);
          }
          else if ( bm_name.compareTo("Solaris") == 0 )
          {
            bs.setSolaris();
          }

           
          if ( bsa_name == null )
          {
            mLogger.fatal("queryBuildInfo null bsa_name " + p.mId);
            // show stopper
            throw new Exception("queryBuildInfo null bsa_name " + p.mId);
          }
          else if ( bsa_name.compareTo("Production") == 0 )
          {
            bs.setProduction();
          }

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryBuildInfo show stopper");
          throw new Exception("queryBuildInfo show stopper");
        }
      }
    }
  }
 

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("claimMutex show stopper");
          throw new Exception("claimMutex show stopper");
        }
      }
    }
  }
 

        throw new SQLException();
      }
      else
      {
        mLogger.fatal("clearBuildFile show stopper");
        throw new Exception("clearBuildFile show stopper");
      }
    }
         
    mLogger.info("clearBuildFile returned " + retVal);
    return retVal;

        throw new SQLException();
      }
      else
      {
        mLogger.fatal("publishBuildFile show stopper");
        throw new Exception("publishBuildFile show stopper");
      }
    }
    catch ( Exception e )
    {
      // this catch and rethrow is historical
      // problems were found using CallableStatement when updating a CLOB column with data > 4000 bytes
      mLogger.fatal("publishBuildFile caught Exception " + e.getMessage());
      throw new Exception("publishBuildFile caught Exception " + e.getMessage());
    }
    mLogger.info("publishBuildFile returned " + retVal);
    return retVal;
  }
 

 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
          // show stopper
          throw new Exception("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
        }
        
        if ( rsetSize == 1 )
        {
          retVal = true;

 
          if ( rsetSize > 1 )
          {
            mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
            // show stopper
            throw new Exception("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
          }
          
          if ( rsetSize == 1 )
          {
            retVal = true;

 
            if ( rsetSize > 1 )
            {
              mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
              // show stopper
              throw new Exception("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
            }
            
            if ( rsetSize == 1 )
            {
              retVal = true;

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryPackageVersions show stopper");
          throw new Exception("queryPackageVersions show stopper");
        }
      }
    }
    
    mLogger.info("queryPackageVersions returned " + retVal);

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("claimVersion show stopper");
          throw new Exception("claimVersion show stopper");
        }
      }
    }
  }
 

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("clearCurrentPackageBeingBuilt show stopper");
          throw new Exception("clearCurrentPackageBeingBuilt show stopper");
        }
      }
    }
  }
 

        if ( result <= 0 && result != -2 )
        {
          // -2 if already released
          // flag build failure
          mLogger.fatal("autoMakeRelease show stopper PK_RMAPI.AUTO_MAKE_RELEASE failed, returned" + result);
          throw new Exception("autoMakeRelease show stopper PK_RMAPI.AUTO_MAKE_RELEASE failed, returned" + result);
        }
        stmt.close();
        mConnection.commit();
        disconnect();
      }

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("autoMakeRelease show stopper");
          throw new Exception("autoMakeRelease show stopper");
        }
      }
    }
  }
 

        
        if ( result != 0 )
        {
          // flag build failure
          mLogger.fatal("insertPackageMetrics show stopper PK_RMAPI.INSERT_PACKAGE_METRICS failed, returned" + result);
          throw new Exception("insertPackageMetrics show stopper PK_RMAPI.INSERT_PACKAGE_METRICS failed, returned" + result);
        }
        stmt.close();
        mConnection.commit();
        disconnect();
      }

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("insertPackageMetrics show stopper");
          throw new Exception("insertPackageMetrics show stopper");
        }
      }
    }
  }
 

      
        if ( result != 0 )
        {
          // flag build failure
          mLogger.fatal( "excludeFromBuild show stopper PK_RMAPI.EXCLUDE_INDIRECT_FROM_BUILD failed, returned " + result );
          throw new Exception("excludeFromBuild show stopper PK_RMAPI.EXCLUDE_INDIRECT_FROM_BUILD failed, returned " + result);
        }
        stmt.close();
        mConnection.commit();
        disconnect();
      }

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("excludeFromBuild show stopper");
          throw new Exception("excludeFromBuild show stopper");
        }
      }
    }
  }
 

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("includeToBuild show stopper");
          throw new Exception("includeToBuild show stopper");
        }
      }
    }
  }
 

          mRegistered = true;
        }
        catch(SQLException e)
        {
          mLogger.fatal("connect failed to register the oracle jdbc driver with the driver manager");
          throw new Exception("connect failed to register the oracle jdbc driver with the driver manager");
        }
      }
 
      // DEVI 46868
      // loop indefinitely until a connection attempt succeeds

 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryDirectedRunLevel rsetSize > 1");
          // show stopper
          throw new Exception("queryDirectedRunLevel rsetSize > 1");
        }
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryDirectedRunLevel show stopper");
          throw new Exception("queryDirectedRunLevel show stopper");
        }
      }
    }
   
    mLogger.info("queryDirectedRunLevel returning " + retVal);

 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryReleaseConfig 1 rsetSize > 1");
          // show stopper
          throw new Exception("queryReleaseConfig 1 rsetSize > 1");
        }
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryReleaseConfig 1 show stopper");
          throw new Exception("queryReleaseConfig 1 show stopper");
        }
      }
    }
    
    mLogger.info("queryReleaseConfig 1 returning " + retVal);

          
          if ( rset.wasNull() )
          {
            mLogger.fatal("queryReleaseConfig 2 null rcon_id " + rtag_id);
            // show stopper
            throw new Exception("queryReleaseConfig 2 null rcon_id " + rtag_id);
          }
 
          char dm = 'S';          
          String daemon_mode = rset.getString("daemon_mode");
          

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryReleaseConfig 2 show stopper");
          throw new Exception("queryReleaseConfig 2 show stopper");
        }
      }
    }
  }
 

          
          if ( rset.wasNull() )
          {
            mLogger.fatal("queryReleaseConfig 3 null rtag_id");
            // show stopper
            throw new Exception("queryReleaseConfig 3 null rtag_id");
          }
 
          int rcon_id = rset.getInt("rcon_id");
          
          if ( rset.wasNull() )
          {
            mLogger.fatal("queryReleaseConfig 3 null rcon_id");
            // show stopper
            throw new Exception("queryReleaseConfig 3 null rcon_id");
          }
 
          char dm = 'S';          
          String daemon_mode = rset.getString("daemon_mode");
          

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryReleaseConfig 3 show stopper");
          throw new Exception("queryReleaseConfig 3 show stopper");
        }
      }
    }
  }
 

 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryRunLevel 1 rsetSize > 1");
          // show stopper
          throw new Exception("queryRunLevel 1 rsetSize > 1");
        }
        
        rset.close();
        stmt.close();
        disconnect();

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryRunLevel 1 show stopper");
          throw new Exception("queryRunLevel 1 show stopper");
        }
      }
    }
  }
 

          
          if ( rset.wasNull() )
          {
            mLogger.fatal("queryRunLevel 2 null rcon_id");
            // show stopper
            throw new Exception("queryRunLevel 2 null rcon_id");
          }
          
          current_run_level = rset.getInt("current_run_level");
 
          if ( rset.wasNull() )
          {
            mLogger.fatal("queryRunLevel 2 null current_run_level");
            // show stopper
            throw new Exception("queryRunLevel 2 null current_run_level");
          }
          
          RunLevel runLevel = new RunLevel(rcon_id, "", current_run_level, false);
          mRunLevelCollection.add(runLevel);
        }
 
        if ( rsetSize == 0 )
        {
          mLogger.fatal("queryRunLevel 2 rsetSize == 0");
          // show stopper
          throw new Exception("queryRunLevel 2 rsetSize == 0");
        }
        
        rset.close();
        stmt.close();
        disconnect();

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryRunLevel 2 show stopper");
          throw new Exception("queryRunLevel 2 show stopper");
        }
      }
      
 
    }

 
          if ( rset.wasNull() )
          {
            mLogger.fatal("querySingleRunLevel null current_run_level");
            // show stopper
            throw new Exception("querySingleRunLevel null current_run_level");
          }
          
          RunLevel runLevel = new RunLevel(rcon_id, "", current_run_level, false);
          mRunLevelCollection.add(runLevel);
        }
 
        if ( rsetSize != 1 )
        {
          mLogger.fatal("querySingleRunLevel rsetSize != 1");
          // show stopper
          throw new Exception("querySingleRunLevel rsetSize != 1");
        }
        
        rset.close();
        stmt.close();
        disconnect();

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("querySingleRunLevel show stopper");
          throw new Exception("querySingleRunLevel show stopper");
        }
      }
    }
  }
 

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryRunLevelSchedule show stopper");
          throw new Exception("queryRunLevelSchedule show stopper");
        }
      }
    }
    
    mLogger.info("queryRunLevelSchedule returning " + retVal);

      }
      catch( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {
          mLogger.fatal("updateCurrentRunLevel database access error only");
          throw new Exception("updateCurrentRunLevel database access error only");
        }
        else
        {
          mLogger.fatal("updateCurrentRunLevel show stopper");
          throw new Exception("updateCurrentRunLevel show stopper");
        }
      }
    }
  }
 

          
          if ( rset.wasNull() )
          {
            mLogger.fatal("queryBuildExclusions rset null pv_id");
            // show stopper
            throw new Exception("queryBuildExclusions rset null pv_id");
          }
          
          int rootPvId = rset.getInt("root_pv_id");
          
          if ( rset.wasNull() )

          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryBuildExclusions show stopper");
          throw new Exception("queryBuildExclusions show stopper");
        }
      }
    }
  }
}

Rev 866	Rev 868
Line 124...	Line 124...
124		124
125	`/**collection of RunLevel objects`	125	`/**collection of RunLevel objects`
126	`* @attribute`	126	`* @attribute`
127	`*/`	127	`*/`
128	`private Vector<RunLevel> mRunLevelCollection = new Vector<RunLevel>();`	128	`private Vector<RunLevel> mRunLevelCollection = new Vector<RunLevel>();`
129		129
130	`/**in daemon mode`	130	`/**in daemon mode`
131	`* select gm.gbe_value from release_config rc, gbe_machtype gm`	131	`* select gm.gbe_value from release_config rc, gbe_machtype gm`
132	`* where rc.rtag_id=<baseline> and gm.gbe_id=rc.gbe_id;`	132	`* where rc.rtag_id=<baseline> and gm.gbe_id=rc.gbe_id;`
133	`* in escrow mode`	133	`* in escrow mode`
134	`* select gm.gbe_value from boms b, release_manager.release_config rc,`	134	`* select gm.gbe_value from boms b, release_manager.release_config rc,`
Line 191...	Line 191...
191	`throw new SQLException();`	191	`throw new SQLException();`
192	`}`	192	`}`
193	`else`	193	`else`
194	`{`	194	`{`
195	`mLogger.fatal("queryMachtypes show stopper");`	195	`mLogger.fatal("queryMachtypes show stopper");`
196	`throw new Exception();`	196	`throw new Exception("queryMachtypes show stopper");`
197	`}`	197	`}`
198	`}`	198	`}`
199	`}`	199	`}`
200	`}`	200	`}`
201		201
Line 301...	Line 301...
301	`throw new SQLException();`	301	`throw new SQLException();`
302	`}`	302	`}`
303	`else`	303	`else`
304	`{`	304	`{`
305	`mLogger.fatal("queryBaselineName show stopper");`	305	`mLogger.fatal("queryBaselineName show stopper");`
306	`throw new Exception();`	306	`throw new Exception("queryBaselineName show stopper");`
307	`}`	307	`}`
308	`}`	308	`}`
309	`}`	309	`}`
310	`mLogger.info("queryBaselineName returned " + retVal);`	310	`mLogger.info("queryBaselineName returned " + retVal);`
311	`return retVal;`	311	`return retVal;`
Line 1330...	Line 1330...
1330	`try`	1330	`try`
1331	`{`	1331	`{`
1332	`if (daemonMode)`	1332	`if (daemonMode)`
1333	`{`	1333	`{`
1334	`Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();`	1334	`Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();`
1335	`// populate globalAndProjectWideBuildFailureCollection`	-
1336	`CallableStatement stmt = mConnection.prepareCall(`	-
1337	`"select u.user_email from release_manager.build_service_config bsc, users u " +`	-
1338	`"where bsc.service='GLOBAL EMAIL ADDRESS LIST' and u.full_name=bsc.config"`	-
1339	`);`	-
1340	`ResultSet rset = stmt.executeQuery();`	-
1341		-
1342	`while( rset.next() )`	-
1343	`{`	-
1344	`String email = rset.getString("user_email");`	-
1345		-
1346	`if ( email != null )`	-
1347	`{`	-
1348	`globalAndProjectWideBuildFailureEmailCollection.add(email);`	1335	`globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());`
1349	`}`	-
1350	`}`	-
1351		-
1352	`rset.close();`	-
1353	`stmt.close();`	-
1354		1336
1355	`CallableStatement stmt0 = mConnection.prepareCall(`	1337	`CallableStatement stmt0 = mConnection.prepareCall(`
1356	`"select u.user_email " +`	1338	`"select u.user_email " +`
1357	`"from release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u, release_manager.views v, release_manager.release_tags rt " +`	1339	`"from release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u, release_manager.views v, release_manager.release_tags rt " +`
1358	`"where rt.rtag_id=" + baseline + " " +`	1340	`"where rt.rtag_id=" + baseline + " " +`
Line 1393...	Line 1375...
1393		1375
1394	`if ( rset1.wasNull() )`	1376	`if ( rset1.wasNull() )`
1395	`{`	1377	`{`
1396	`mLogger.fatal("queryPackageVersions rset1 null pv_id");`	1378	`mLogger.fatal("queryPackageVersions rset1 null pv_id");`
1397	`// show stopper`	1379	`// show stopper`
1398	`throw new Exception();`	1380	`throw new Exception("queryPackageVersions rset1 null pv_id");`
1399	`}`	1381	`}`
1400		1382
1401	`int pkg_id = rset1.getInt("pkg_id");`	1383	`int pkg_id = rset1.getInt("pkg_id");`
1402		1384
1403	`if ( rset1.wasNull() )`	1385	`if ( rset1.wasNull() )`
1404	`{`	1386	`{`
1405	`mLogger.fatal("queryPackageVersions rset1 null pkg_id " + pv_id);`	1387	`mLogger.fatal("queryPackageVersions rset1 null pkg_id " + pv_id);`
1406	`// show stopper`	1388	`// show stopper`
1407	`throw new Exception();`	1389	`throw new Exception("queryPackageVersions rset1 null pkg_id " + pv_id);`
1408	`}`	1390	`}`
1409		1391
1410	`String pkg_name = rset1.getString("pkg_name");`	1392	`String pkg_name = rset1.getString("pkg_name");`
1411		1393
1412	`if ( pkg_name == null )`	1394	`if ( pkg_name == null )`
1413	`{`	1395	`{`
1414	`mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);`	1396	`mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);`
1415	`// show stopper`	1397	`// show stopper`
1416	`throw new Exception();`	1398	`throw new Exception("queryPackageVersions rset1 null pkg_name " + pv_id);`
1417	`}`	1399	`}`
1418		1400
1419	`String v_ext = rset1.getString("v_ext");`	1401	`String v_ext = rset1.getString("v_ext");`
1420		1402
1421	`if ( v_ext == null )`	1403	`if ( v_ext == null )`
Line 1489...	Line 1471...
1489		1471
1490	`if ( rset2.wasNull() )`	1472	`if ( rset2.wasNull() )`
1491	`{`	1473	`{`
1492	`mLogger.fatal("queryPackageVersions rset2 null pv_id");`	1474	`mLogger.fatal("queryPackageVersions rset2 null pv_id");`
1493	`// show stopper`	1475	`// show stopper`
1494	`throw new Exception();`	1476	`throw new Exception("queryPackageVersions rset2 null pv_id");`
1495	`}`	1477	`}`
1496		1478
1497	`Package p = findPackage(pv_id, packageCollection);`	1479	`Package p = findPackage(pv_id, packageCollection);`
1498		1480
1499	`if ( p == NULL_PACKAGE )`	1481	`if ( p == NULL_PACKAGE )`
Line 1507...	Line 1489...
1507		1489
1508	`if ( pkg_name == null )`	1490	`if ( pkg_name == null )`
1509	`{`	1491	`{`
1510	`mLogger.fatal("queryPackageVersions rset2 null pkg_name " + pv_id);`	1492	`mLogger.fatal("queryPackageVersions rset2 null pkg_name " + pv_id);`
1511	`// show stopper`	1493	`// show stopper`
1512	`throw new Exception();`	1494	`throw new Exception("queryPackageVersions rset2 null pkg_name " + pv_id);`
1513	`}`	1495	`}`
1514		1496
1515	`String v_ext = rset2.getString("v_ext");`	1497	`String v_ext = rset2.getString("v_ext");`
1516		1498
1517	`if ( v_ext == null )`	1499	`if ( v_ext == null )`
Line 1546...	Line 1528...
1546		1528
1547	`if ( rset3.wasNull() )`	1529	`if ( rset3.wasNull() )`
1548	`{`	1530	`{`
1549	`mLogger.fatal("queryPackageVersions rset3 null pv_id");`	1531	`mLogger.fatal("queryPackageVersions rset3 null pv_id");`
1550	`// show stopper`	1532	`// show stopper`
1551	`throw new Exception();`	1533	`throw new Exception("queryPackageVersions rset3 null pv_id");`
1552	`}`	1534	`}`
1553		1535
1554	`Package p = findPackage(pv_id, packageCollection);`	1536	`Package p = findPackage(pv_id, packageCollection);`
1555		1537
1556	`if ( p == NULL_PACKAGE )`	1538	`if ( p == NULL_PACKAGE )`
Line 1564...	Line 1546...
1564		1546
1565	`if ( bm_name == null )`	1547	`if ( bm_name == null )`
1566	`{`	1548	`{`
1567	`mLogger.fatal("queryPackageVersions rset3 null bm_name " + pv_id);`	1549	`mLogger.fatal("queryPackageVersions rset3 null bm_name " + pv_id);`
1568	`// show stopper`	1550	`// show stopper`
1569	`throw new Exception();`	1551	`throw new Exception("queryPackageVersions rset3 null bm_name " + pv_id);`
1570	`}`	1552	`}`
1571		1553
1572	`String bsa_name = rset3.getString("bsa_name");`	1554	`String bsa_name = rset3.getString("bsa_name");`
1573		1555
1574	`if ( bsa_name == null )`	1556	`if ( bsa_name == null )`
1575	`{`	1557	`{`
1576	`mLogger.fatal("queryPackageVersions rset3 null bsa_name " + pv_id);`	1558	`mLogger.fatal("queryPackageVersions rset3 null bsa_name " + pv_id);`
1577	`// show stopper`	1559	`// show stopper`
1578	`throw new Exception();`	1560	`throw new Exception("queryPackageVersions rset3 null bsa_name " + pv_id);`
1579	`}`	1561	`}`
1580		1562
1581	`if ( !ignore )`	1563	`if ( !ignore )`
1582	`{`	1564	`{`
1583	`boolean supportedBuildStandard = true;`	1565	`boolean supportedBuildStandard = true;`
Line 1661...	Line 1643...
1661		1643
1662	`if ( rset4.wasNull() )`	1644	`if ( rset4.wasNull() )`
1663	`{`	1645	`{`
1664	`mLogger.fatal("queryPackageVersions rset4 null pv_id");`	1646	`mLogger.fatal("queryPackageVersions rset4 null pv_id");`
1665	`// show stopper`	1647	`// show stopper`
1666	`throw new Exception();`	1648	`throw new Exception("queryPackageVersions rset4 null pv_id");`
1667	`}`	1649	`}`
1668		1650
1669	`Package p = findPackage(pv_id, packageCollection);`	1651	`Package p = findPackage(pv_id, packageCollection);`
1670		1652
1671	`if ( p == NULL_PACKAGE )`	1653	`if ( p == NULL_PACKAGE )`
Line 1679...	Line 1661...
1679		1661
1680	`if ( test_type_name == null )`	1662	`if ( test_type_name == null )`
1681	`{`	1663	`{`
1682	`mLogger.fatal("queryPackageVersions rset4 null test_type_name " + pv_id);`	1664	`mLogger.fatal("queryPackageVersions rset4 null test_type_name " + pv_id);`
1683	`// show stopper`	1665	`// show stopper`
1684	`throw new Exception();`	1666	`throw new Exception("queryPackageVersions rset4 null test_type_name " + pv_id);`
1685	`}`	1667	`}`
1686		1668
1687	`if ( !ignore )`	1669	`if ( !ignore )`
1688	`{`	1670	`{`
1689	`if ( test_type_name.compareTo("Autobuild UTF") == 0 )`	1671	`if ( test_type_name.compareTo("Autobuild UTF") == 0 )`
Line 1713...	Line 1695...
1713		1695
1714	`if ( rset50.wasNull() )`	1696	`if ( rset50.wasNull() )`
1715	`{`	1697	`{`
1716	`mLogger.fatal("queryPackageVersions rset50 null pv_id");`	1698	`mLogger.fatal("queryPackageVersions rset50 null pv_id");`
1717	`// show stopper`	1699	`// show stopper`
1718	`throw new Exception();`	1700	`throw new Exception("queryPackageVersions rset50 null pv_id");`
1719	`}`	1701	`}`
1720		1702
1721	`Package p = findPackage(pv_id, packageCollection);`	1703	`Package p = findPackage(pv_id, packageCollection);`
1722		1704
1723	`if ( p == NULL_PACKAGE )`	1705	`if ( p == NULL_PACKAGE )`
Line 1753...	Line 1735...
1753		1735
1754	`if ( rset5.wasNull() )`	1736	`if ( rset5.wasNull() )`
1755	`{`	1737	`{`
1756	`mLogger.fatal("queryPackageVersions rset5 null pv_id");`	1738	`mLogger.fatal("queryPackageVersions rset5 null pv_id");`
1757	`// show stopper`	1739	`// show stopper`
1758	`throw new Exception();`	1740	`throw new Exception("queryPackageVersions rset5 null pv_id");`
1759	`}`	1741	`}`
1760		1742
1761	`Package p = findPackage(pv_id, packageCollection);`	1743	`Package p = findPackage(pv_id, packageCollection);`
1762		1744
1763	`if ( p == NULL_PACKAGE )`	1745	`if ( p == NULL_PACKAGE )`
Line 1795...	Line 1777...
1795		1777
1796	`if ( rset51.wasNull() )`	1778	`if ( rset51.wasNull() )`
1797	`{`	1779	`{`
1798	`mLogger.fatal("queryPackageVersions rset51 null pv_id");`	1780	`mLogger.fatal("queryPackageVersions rset51 null pv_id");`
1799	`// show stopper`	1781	`// show stopper`
1800	`throw new Exception();`	1782	`throw new Exception("queryPackageVersions rset51 null pv_id");`
1801	`}`	1783	`}`
1802		1784
1803	`Package p = findPackage(pv_id, packageCollection);`	1785	`Package p = findPackage(pv_id, packageCollection);`
1804		1786
1805	`if ( p == NULL_PACKAGE )`	1787	`if ( p == NULL_PACKAGE )`
Line 1845...	Line 1827...
1845		1827
1846	`if ( rset7.wasNull() )`	1828	`if ( rset7.wasNull() )`
1847	`{`	1829	`{`
1848	`mLogger.fatal("queryPackageVersions rset7 null pv_id");`	1830	`mLogger.fatal("queryPackageVersions rset7 null pv_id");`
1849	`// show stopper`	1831	`// show stopper`
1850	`throw new Exception();`	1832	`throw new Exception("queryPackageVersions rset7 null pv_id");`
1851	`}`	1833	`}`
1852		1834
1853	`Package p = findPackage(pv_id, packageCollection);`	1835	`Package p = findPackage(pv_id, packageCollection);`
1854		1836
1855	`if ( p == NULL_PACKAGE )`	1837	`if ( p == NULL_PACKAGE )`
Line 1884...	Line 1866...
1884		1866
1885	`if ( rset8.wasNull() )`	1867	`if ( rset8.wasNull() )`
1886	`{`	1868	`{`
1887	`mLogger.fatal("queryPackageVersions rset8 null pv_id");`	1869	`mLogger.fatal("queryPackageVersions rset8 null pv_id");`
1888	`// show stopper`	1870	`// show stopper`
1889	`throw new Exception();`	1871	`throw new Exception("queryPackageVersions rset8 null pv_id");`
1890	`}`	1872	`}`
1891		1873
1892	`int pkg_id = rset8.getInt("pkg_id");`	1874	`int pkg_id = rset8.getInt("pkg_id");`
1893		1875
1894	`if ( rset8.wasNull() )`	1876	`if ( rset8.wasNull() )`
1895	`{`	1877	`{`
1896	`mLogger.fatal("queryPackageVersions rset8 null pkg_id " + pv_id);`	1878	`mLogger.fatal("queryPackageVersions rset8 null pkg_id " + pv_id);`
1897	`// show stopper`	1879	`// show stopper`
1898	`throw new Exception();`	1880	`throw new Exception("queryPackageVersions rset8 null pkg_id " + pv_id);`
1899	`}`	1881	`}`
1900		1882
1901	`String pkg_name = rset8.getString("pkg_name");`	1883	`String pkg_name = rset8.getString("pkg_name");`
1902		1884
1903	`if ( pkg_name == null )`	1885	`if ( pkg_name == null )`
1904	`{`	1886	`{`
1905	`mLogger.fatal("queryPackageVersions rset8 null pkg_name " + pv_id);`	1887	`mLogger.fatal("queryPackageVersions rset8 null pkg_name " + pv_id);`
1906	`// show stopper`	1888	`// show stopper`
1907	`throw new Exception();`	1889	`throw new Exception("queryPackageVersions rset8 null pkg_name " + pv_id);`
1908	`}`	1890	`}`
1909		1891
1910	`String pkg_version = rset8.getString("pkg_version");`	1892	`String pkg_version = rset8.getString("pkg_version");`
1911		1893
1912	`if ( pkg_version == null )`	1894	`if ( pkg_version == null )`
1913	`{`	1895	`{`
1914	`mLogger.fatal("queryPackageVersions rset8 null pkg_version " + pv_id);`	1896	`mLogger.fatal("queryPackageVersions rset8 null pkg_version " + pv_id);`
1915	`// show stopper`	1897	`// show stopper`
1916	`throw new Exception();`	1898	`throw new Exception("queryPackageVersions rset8 null pkg_version " + pv_id);`
1917	`}`	1899	`}`
1918		1900
1919	`String v_ext = rset8.getString("v_ext");`	1901	`String v_ext = rset8.getString("v_ext");`
1920		1902
1921	`if ( v_ext == null )`	1903	`if ( v_ext == null )`
Line 1993...	Line 1975...
1993		1975
1994	`if ( rset9.wasNull() )`	1976	`if ( rset9.wasNull() )`
1995	`{`	1977	`{`
1996	`mLogger.fatal("queryPackageVersions rset9 null pv_id");`	1978	`mLogger.fatal("queryPackageVersions rset9 null pv_id");`
1997	`// show stopper`	1979	`// show stopper`
1998	`throw new Exception();`	1980	`throw new Exception("queryPackageVersions rset9 null pv_id");`
1999	`}`	1981	`}`
2000		1982
2001	`int dpv_id = rset9.getInt(2);`	1983	`int dpv_id = rset9.getInt(2);`
2002		1984
2003	`if ( rset9.wasNull() )`	1985	`if ( rset9.wasNull() )`
2004	`{`	1986	`{`
2005	`mLogger.fatal("queryPackageVersions rset9 null dpv_id " + pv_id);`	1987	`mLogger.fatal("queryPackageVersions rset9 null dpv_id " + pv_id);`
2006	`// show stopper`	1988	`// show stopper`
2007	`throw new Exception();`	1989	`throw new Exception("queryPackageVersions rset9 null dpv_id " + pv_id);`
2008	`}`	1990	`}`
2009		1991
2010	`Package p = findPackage(pv_id, packageCollection);`	1992	`Package p = findPackage(pv_id, packageCollection);`
2011		1993
2012	`if ( p == NULL_PACKAGE )`	1994	`if ( p == NULL_PACKAGE )`
Line 2019...	Line 2001...
2019		2001
2020	`if ( pkg_name == null )`	2002	`if ( pkg_name == null )`
2021	`{`	2003	`{`
2022	`mLogger.fatal("queryPackageVersions rset9 null pkg_name " + pv_id);`	2004	`mLogger.fatal("queryPackageVersions rset9 null pkg_name " + pv_id);`
2023	`// show stopper`	2005	`// show stopper`
2024	`throw new Exception();`	2006	`throw new Exception("queryPackageVersions rset9 null pkg_name " + pv_id);`
2025	`}`	2007	`}`
2026		2008
2027	`String v_ext = rset9.getString("v_ext");`	2009	`String v_ext = rset9.getString("v_ext");`
2028		2010
2029	`if ( v_ext == null )`	2011	`if ( v_ext == null )`
Line 2058...	Line 2040...
2058		2040
2059	`if ( rset10.wasNull() )`	2041	`if ( rset10.wasNull() )`
2060	`{`	2042	`{`
2061	`mLogger.fatal("queryPackageVersions rset10 null pv_id");`	2043	`mLogger.fatal("queryPackageVersions rset10 null pv_id");`
2062	`// show stopper`	2044	`// show stopper`
2063	`throw new Exception();`	2045	`throw new Exception("queryPackageVersions rset10 null pv_id");`
2064	`}`	2046	`}`
2065		2047
2066	`Package p = findPackage(pv_id, packageCollection);`	2048	`Package p = findPackage(pv_id, packageCollection);`
2067		2049
2068	`if ( p == NULL_PACKAGE )`	2050	`if ( p == NULL_PACKAGE )`
Line 2075...	Line 2057...
2075		2057
2076	`if ( bm_name == null )`	2058	`if ( bm_name == null )`
2077	`{`	2059	`{`
2078	`mLogger.fatal("queryPackageVersions rset10 null bm_name " + pv_id);`	2060	`mLogger.fatal("queryPackageVersions rset10 null bm_name " + pv_id);`
2079	`// show stopper`	2061	`// show stopper`
2080	`throw new Exception();`	2062	`throw new Exception("queryPackageVersions rset10 null bm_name " + pv_id);`
2081	`}`	2063	`}`
2082		2064
2083	`String bsa_name = rset10.getString("bsa_name");`	2065	`String bsa_name = rset10.getString("bsa_name");`
2084		2066
2085	`if ( bsa_name == null )`	2067	`if ( bsa_name == null )`
2086	`{`	2068	`{`
2087	`mLogger.fatal("queryPackageVersions rset10 null bsa_name " + pv_id);`	2069	`mLogger.fatal("queryPackageVersions rset10 null bsa_name " + pv_id);`
2088	`// show stopper`	2070	`// show stopper`
2089	`throw new Exception();`	2071	`throw new Exception("queryPackageVersions rset10 null bsa_name " + pv_id);`
2090	`}`	2072	`}`
2091		2073
2092	`if ( !ignore )`	2074	`if ( !ignore )`
2093	`{`	2075	`{`
2094	`boolean supportedBuildStandard = true;`	2076	`boolean supportedBuildStandard = true;`
Line 2172...	Line 2154...
2172		2154
2173	`if ( rset11.wasNull() )`	2155	`if ( rset11.wasNull() )`
2174	`{`	2156	`{`
2175	`mLogger.fatal("queryPackageVersions rset11 null pv_id");`	2157	`mLogger.fatal("queryPackageVersions rset11 null pv_id");`
2176	`// show stopper`	2158	`// show stopper`
2177	`throw new Exception();`	2159	`throw new Exception("queryPackageVersions rset11 null pv_id");`
2178	`}`	2160	`}`
2179		2161
2180	`Package p = findPackage(pv_id, packageCollection);`	2162	`Package p = findPackage(pv_id, packageCollection);`
2181		2163
2182	`if ( p == NULL_PACKAGE )`	2164	`if ( p == NULL_PACKAGE )`
Line 2189...	Line 2171...
2189		2171
2190	`if ( test_type_name == null )`	2172	`if ( test_type_name == null )`
2191	`{`	2173	`{`
2192	`mLogger.fatal("queryPackageVersions rset11 null test_type_name " + pv_id);`	2174	`mLogger.fatal("queryPackageVersions rset11 null test_type_name " + pv_id);`
2193	`// show stopper`	2175	`// show stopper`
2194	`throw new Exception();`	2176	`throw new Exception("queryPackageVersions rset11 null test_type_name " + pv_id);`
2195	`}`	2177	`}`
2196		2178
2197	`if ( !ignore )`	2179	`if ( !ignore )`
2198	`{`	2180	`{`
2199	`if ( test_type_name.compareTo("Autobuild UTF") == 0 )`	2181	`if ( test_type_name.compareTo("Autobuild UTF") == 0 )`
Line 2223...	Line 2205...
2223		2205
2224	`if ( rset120.wasNull() )`	2206	`if ( rset120.wasNull() )`
2225	`{`	2207	`{`
2226	`mLogger.fatal("queryPackageVersions rset120 null pv_id");`	2208	`mLogger.fatal("queryPackageVersions rset120 null pv_id");`
2227	`// show stopper`	2209	`// show stopper`
2228	`throw new Exception();`	2210	`throw new Exception("queryPackageVersions rset120 null pv_id");`
2229	`}`	2211	`}`
2230		2212
2231	`Package p = findPackage(pv_id, packageCollection);`	2213	`Package p = findPackage(pv_id, packageCollection);`
2232		2214
2233	`if ( p == NULL_PACKAGE )`	2215	`if ( p == NULL_PACKAGE )`
Line 2263...	Line 2245...
2263		2245
2264	`if ( rset12.wasNull() )`	2246	`if ( rset12.wasNull() )`
2265	`{`	2247	`{`
2266	`mLogger.fatal("queryPackageVersions rset12 null pv_id");`	2248	`mLogger.fatal("queryPackageVersions rset12 null pv_id");`
2267	`// show stopper`	2249	`// show stopper`
2268	`throw new Exception();`	2250	`throw new Exception("queryPackageVersions rset12 null pv_id");`
2269	`}`	2251	`}`
2270		2252
2271	`Package p = findPackage(pv_id, packageCollection);`	2253	`Package p = findPackage(pv_id, packageCollection);`
2272		2254
2273	`if ( p == NULL_PACKAGE )`	2255	`if ( p == NULL_PACKAGE )`
Line 2306...	Line 2288...
2306		2288
2307	`if ( rset14.wasNull() )`	2289	`if ( rset14.wasNull() )`
2308	`{`	2290	`{`
2309	`mLogger.fatal("queryPackageVersions rset14 null pv_id");`	2291	`mLogger.fatal("queryPackageVersions rset14 null pv_id");`
2310	`// show stopper`	2292	`// show stopper`
2311	`throw new Exception();`	2293	`throw new Exception("queryPackageVersions rset14 null pv_id");`
2312	`}`	2294	`}`
2313		2295
2314	`Package p = findPackage(pv_id, packageCollection);`	2296	`Package p = findPackage(pv_id, packageCollection);`
2315		2297
2316	`if ( p == NULL_PACKAGE )`	2298	`if ( p == NULL_PACKAGE )`
Line 2345...	Line 2327...
2345		2327
2346	`if ( rset.wasNull() )`	2328	`if ( rset.wasNull() )`
2347	`{`	2329	`{`
2348	`mLogger.fatal("queryPackageVersions rset null prod_id");`	2330	`mLogger.fatal("queryPackageVersions rset null prod_id");`
2349	`// show stopper`	2331	`// show stopper`
2350	`throw new Exception();`	2332	`throw new Exception("queryPackageVersions rset null prod_id");`
2351	`}`	2333	`}`
2352		2334
2353	`String pkg_name = rset.getString("pkg_name");`	2335	`String pkg_name = rset.getString("pkg_name");`
2354		2336
2355	`if ( pkg_name == null )`	2337	`if ( pkg_name == null )`
2356	`{`	2338	`{`
2357	`mLogger.fatal("queryPackageVersions rset null pkg_name " + pv_id);`	2339	`mLogger.fatal("queryPackageVersions rset null pkg_name " + pv_id);`
2358	`// show stopper`	2340	`// show stopper`
2359	`throw new Exception();`	2341	`throw new Exception("queryPackageVersions rset null pkg_name " + pv_id);`
2360	`}`	2342	`}`
2361		2343
2362	`String pkg_version = rset.getString("pkg_version");`	2344	`String pkg_version = rset.getString("pkg_version");`
2363		2345
2364	`if ( pkg_version == null )`	2346	`if ( pkg_version == null )`
2365	`{`	2347	`{`
2366	`mLogger.fatal("queryPackageVersions rset null pkg_version " + pv_id);`	2348	`mLogger.fatal("queryPackageVersions rset null pkg_version " + pv_id);`
2367	`// show stopper`	2349	`// show stopper`
2368	`throw new Exception();`	2350	`throw new Exception("queryPackageVersions rset null pkg_version " + pv_id);`
2369	`}`	2351	`}`
2370		2352
2371	`String v_ext = rset.getString("v_ext");`	2353	`String v_ext = rset.getString("v_ext");`
2372		2354
2373	`if ( v_ext == null )`	2355	`if ( v_ext == null )`
Line 2410...	Line 2392...
2410	`throw new SQLException();`	2392	`throw new SQLException();`
2411	`}`	2393	`}`
2412	`else`	2394	`else`
2413	`{`	2395	`{`
2414	`mLogger.fatal("queryPackageVersions show stopper");`	2396	`mLogger.fatal("queryPackageVersions show stopper");`
2415	`throw new Exception();`	2397	`throw new Exception("queryPackageVersions show stopper");`
2416	`}`	2398	`}`
2417	`}`	2399	`}`
2418	`}`	2400	`}`
2419		2401
2420	`if (!daemonMode)`	2402	`if (!daemonMode)`
Line 2478...	Line 2460...
2478	`throw new SQLException();`	2460	`throw new SQLException();`
2479	`}`	2461	`}`
2480	`else`	2462	`else`
2481	`{`	2463	`{`
2482	`mLogger.fatal("queryMailServer show stopper");`	2464	`mLogger.fatal("queryMailServer show stopper");`
2483	`throw new Exception();`	2465	`throw new Exception("queryMailServer show stopper");`
2484	`}`	2466	`}`
2485	`}`	2467	`}`
2486	`}`	2468	`}`
2487		2469
2488	`mLogger.info("queryMailServer returned " + retVal);`	2470	`mLogger.info("queryMailServer returned " + retVal);`
Line 2532...	Line 2514...
2532	`throw new SQLException();`	2514	`throw new SQLException();`
2533	`}`	2515	`}`
2534	`else`	2516	`else`
2535	`{`	2517	`{`
2536	`mLogger.fatal("queryMailSender show stopper");`	2518	`mLogger.fatal("queryMailSender show stopper");`
2537	`throw new Exception();`	2519	`throw new Exception("queryMailSender show stopper");`
2538	`}`	2520	`}`
2539	`}`	2521	`}`
2540	`}`	2522	`}`
2541		2523
2542	`mLogger.debug("queryMailSender returned " + retVal);`	2524	`mLogger.debug("queryMailSender returned " + retVal);`
2543	`return retVal;`	2525	`return retVal;`
2544	`}`	2526	`}`
2545		2527
-		2528	`/**only used in daemon mode`
-		2529	`* select u.user_email from release_manager.build_service_config bsc, users u`
-		2530	`* where bsc.service='GLOBAL EMAIL ADDRESS LIST' and u.full_name=bsc.config`
-		2531	`* returns the configured global email addresses`
-		2532	`*/`
-		2533	`String queryGlobalAddresses() throws SQLException, Exception`
-		2534	`{`
-		2535	`mLogger.debug("queryGlobalAddresses");`
-		2536	`String retVal = new String();`
-		2537
-		2538	`if ( !mUseDatabase )`
-		2539	`{`
-		2540	`mLogger.info("queryGlobalAddresses !mUseDatabase");`
-		2541	`// a highly unlikely address`
-		2542	`retVal = "buildadm@erggroup.com";`
-		2543	`}`
-		2544	`else`
-		2545	`{`
-		2546	`try`
-		2547	`{`
-		2548	`CallableStatement stmt = mConnection.prepareCall(`
-		2549	`"select u.user_email from release_manager.build_service_config bsc, users u " +`
-		2550	`"where bsc.service='GLOBAL EMAIL ADDRESS LIST' and u.full_name=bsc.config"`
-		2551	`);`
-		2552	`ResultSet rset = stmt.executeQuery();`
-		2553
-		2554	`while( rset.next() )`
-		2555	`{`
-		2556	`String email = rset.getString("user_email");`
-		2557
-		2558	`if ( email != null )`
-		2559	`{`
-		2560	`retVal += email;`
-		2561	`}`
-		2562	`}`
-		2563
-		2564	`rset.close();`
-		2565	`stmt.close();`
-		2566	`}`
-		2567	`catch ( SQLException e )`
-		2568	`{`

Subversion Repositories DevTools

(root)/buildtool/trunk/src/generated/com/erggroup/buildtool/ripple/ReleaseManager.java @ 868 – Rev 866 → 868