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



        sql = "select gm.gbe_value from release_manager.release_config rc, release_manager.gbe_machtype gm where rc.rtag_id=" + baseline + " and gm.gbe_id=rc.gbe_id";
      }
      else
      {
        sql = 
        "select gm.gbe_value " +
          "from deployment_manager.boms b, release_manager.release_config rc, release_manager.gbe_machtype gm " +
          "where b.bom_id=" + baseline +
          " and rc.rtag_id=b.rtag_id_fk "+
          " and gm.gbe_id=rc.gbe_id";
      }
 
      try
      {
        CallableStatement stmt = mConnection.prepareCall(sql);
        ResultSet rset = stmt.executeQuery();
        

          mLogger.error("queryMachtypes database access error only");
          throw new SQLException();
        }
        else
        {
          mLogger.fatal("queryMachtypes show stopper:" + e.toString());
          throw new Exception("queryMachtypes show stopper");
        }
      }
    }
  }

    {
      try
      {
        if (daemonMode)
        {
          mLogger.warn("queryPackageVersions: stmt0");
          Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();
          globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());
 
          CallableStatement stmt0 = mConnection.prepareCall(
          "select u.user_email " +

          rset0.close();
          stmt0.close();
          
          // get planned package info
          // devi 48629 support multiple wips on the same package and build in the order they were released
          mLogger.warn("queryPackageVersions: stmt1");
          CallableStatement stmt1 = mConnection.prepareCall(
                "select pl.pv_id, p.pkg_id, p.pkg_name," +
                       "pv.v_ext, pv.change_type, pv.ripple_field," +
                       "pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
                       "pv.modified_stamp," +

          
          rset1.close();
          stmt1.close();
 
          // get planned package dependency info
          mLogger.warn("queryPackageVersions: stmt2");
          CallableStatement stmt2 = mConnection.prepareCall(
          "select pl.pv_id, p.pkg_name, dpv.v_ext, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and pd.pv_id=pl.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +

          
          rset2.close();
          stmt2.close();
          
          // get planned package build info
          mLogger.warn("queryPackageVersions: stmt3");
          CallableStatement stmt3 = mConnection.prepareCall(
          "select pl.pv_id, bm.bm_name, bsa.bsa_name, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +

          
          rset3.close();
          stmt3.close();
 
          // get planned package unit test info
          mLogger.warn("queryPackageVersions: stmt4");
          CallableStatement stmt4 = mConnection.prepareCall(
          "select pl.pv_id, tt.test_type_name, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +

          rset4.close();
          stmt4.close();
 
          // get planned package build failure info...
          // global and project wide based
          mLogger.warn("queryPackageVersions: stmt50");
          CallableStatement stmt50 = mConnection.prepareCall(
          "select pl.pv_id, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv " +
          "where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id " +

              
          rset50.close();
          stmt50.close();
 
          // view based
          mLogger.warn("queryPackageVersions: stmt5");
          CallableStatement stmt5 = mConnection.prepareCall(
          "select pl.pv_id, u.user_email, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +
          "where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and af.view_id=pl.view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +

          
          rset5.close();
          stmt5.close();
 
          // package version
          mLogger.warn("queryPackageVersions: stmt51");
          CallableStatement stmt51 = mConnection.prepareCall(
          "select pl.pv_id, u1.user_email, u2.user_email, u3.user_email, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.users u1, release_manager.users u2, release_manager.users u3 " +
          "where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and u1.user_id=pv.creator_id and u2.user_id=pv.owner_id and u3.user_id=pv.modifier_id " +

          
          rset51.close();
          stmt51.close();
 
          // get planned package advisory ripple info
          mLogger.warn("queryPackageVersions: stmt7");
          CallableStatement stmt7 = mConnection.prepareCall(
          "select pl.pv_id, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and ar.rtag_id=pl.rtag_id and ar.pv_id=pl.pv_id " +

          
          rset7.close();
          stmt7.close();
          
          // get released package info
          mLogger.warn("queryPackageVersions: stmt8");
          CallableStatement stmt8 = mConnection.prepareCall(
            "select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +
                "pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +
                "pv.build_number_limit," +
                "release_manager.PK_RMAPI.return_vcs_tag(rc.pv_id) AS vcsTag" +

            " where rc.rtag_id=" + baseline +
              " and pv.pv_id = rc.pv_id" +
              " and p.pkg_id = pv.pkg_id" +
            " order by rc.pv_id"
          );
mLogger.warn("queryPackageVersions: stmt8 Prepared");
          ResultSet rset8 = stmt8.executeQuery();
mLogger.warn("queryPackageVersions: stmt8 Query Done");
          
          while( rset8.next() )
          {
            int pv_id = rset8.getInt("pv_id");
            

 
              plannedPackage.mVersion = pkg_version;
            }
          }
          
mLogger.warn("queryPackageVersions: stmt8 processing complete");
          rset8.close();
          stmt8.close();
 
          // get released package dependency info
          // the not exists subquery was added to ignore dependencies for 'pegged' package versions in a release - DEVI 48876
          // this is the ONLY support for dealing with an inconsistent set of package versions
          mLogger.warn("queryPackageVersions: stmt9");
          CallableStatement stmt9 = mConnection.prepareCall(
          "select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +
          "where rc.rtag_id=" + baseline +
          " and pv.pv_id = rc.pv_id and pd.pv_id=pv.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +
          " and not exists (select pv_id from pegged_versions where pv_id=pv.pv_id and rtag_id=rc.rtag_id) " +
          "order by rc.pv_id"
          );
mLogger.warn("queryPackageVersions: stmt9 prepared");
          ResultSet rset9 = stmt9.executeQuery();
mLogger.warn("queryPackageVersions: stmt9 query done");
             
          while( rset9.next() )
          {
            boolean ignore = false;
             

            {
              p.mDependencyCollection.add(pkg_name + v_ext);
              p.mDependencyIDCollection.add(dpv_id);
            }
          }
mLogger.warn("queryPackageVersions: stmt9 processing complete");
 
          rset9.close();
          stmt9.close();
           
          // get released package build info
          mLogger.warn("queryPackageVersions: stmt10");
          CallableStatement stmt10 = mConnection.prepareCall(
          "select rc.pv_id, bm.bm_name, bsa.bsa_name " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +
          "where rc.rtag_id=" + baseline +
          " and pv.pv_id = rc.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +

          
          rset10.close();
          stmt10.close();
 
          // get released package unit test info
          mLogger.warn("queryPackageVersions: stmt11");
          CallableStatement stmt11 = mConnection.prepareCall(
          "select rc.pv_id, tt.test_type_name " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +
          "where rc.rtag_id=" + baseline +
          " and pv.pv_id = rc.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +

          rset11.close();
          stmt11.close();
 
          // get released package build failure info...
          // global and project wide based
          mLogger.warn("queryPackageVersions: stmt120");
          CallableStatement stmt120 = mConnection.prepareCall(
          "select rc.pv_id " +
          "from release_manager.release_content rc, release_manager.release_tags rt, release_manager.package_versions pv " +
          "where rc.rtag_id=" + baseline + " and rt.rtag_id=rc.rtag_id " +
          "and pv.pv_id = rc.pv_id " +

              
          rset120.close();
          stmt120.close();
          
          // view based
          mLogger.warn("queryPackageVersions: stmt12");
          CallableStatement stmt12 = mConnection.prepareCall(
          "select rc.pv_id, u.user_email " +
          "from release_manager.release_content rc, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +
          "where rc.rtag_id=" + baseline + " and rt.rtag_id=rc.rtag_id " +
          "and pv.pv_id = rc.pv_id and af.view_id=rc.base_view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +

          
          rset12.close();
          stmt12.close();
 
          // get released advisory ripple info
          mLogger.warn("queryPackageVersions: stmt14");
          CallableStatement stmt14 = mConnection.prepareCall(
          "select rc.pv_id " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +
          "where rc.rtag_id=" + baseline +
          " and pv.pv_id = rc.pv_id and ar.rtag_id=rc.rtag_id and ar.pv_id=rc.pv_id " +

          // in all cases, build a meaningful email body to inform the user
          // of the snapshot of build information that applied to the build and store in:
          // - mTestBuildEmailBody
 
          // an op code of 1 means test build
          mLogger.warn("queryPackageVersions: stmt141");
          instruction.value = 0;
          while ( getDaemonInst( baseline, instruction, 1, pvid, userid ) )
          {
            // can only do one test build at a time - others will be discarded until future cycle
            boolean discard = false;

              String pkg_name = "";
              String pkg_ext = "";
              String testBuildVcsTag = "null";
 
              // get wip package info
              mLogger.warn("queryPackageVersions: stmt15");
              CallableStatement stmt15 = mConnection.prepareCall(
              "select p.pkg_name, pv.v_ext, release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag " +
              " from release_manager.work_in_progress wip," +
                    "release_manager.package_versions pv," +
                    "release_manager.packages p" +

              }
              
              rset15.close();
              stmt15.close();
              
              mLogger.warn("queryPackageVersions: stmt16");
              if ( rsetSize == 0 )
              {
                mLogger.error("queryPackageVersions rset15 no wip found " + instruction.value);
                markDaemonInstCompleted( instruction.value );
              }

                
                rset16.close();
                stmt16.close();
  
                // get planned package build info
                mLogger.warn("queryPackageVersions: stmt17");
                CallableStatement stmt17 = mConnection.prepareCall(
                "select bm.bm_name, bsa.bsa_name " +
                "from release_manager.work_in_progress wip, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +
                "where wip.rtag_id=" + baseline +
                " and wip.pv_id=" + testBuildPvId +

          }
        }
        else
        {
          // get released product info
          mLogger.warn("queryPackageVersions: stmt18");
          CallableStatement stmt = mConnection.prepareCall(
            "select oc.prod_id, p.pkg_name, pv.pkg_version, pv.v_ext," +
                   "release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag" +
            " from deployment_manager.bom_contents bc," +
                "deployment_manager.operating_systems os," +

 
  /**disconnect from oracle
   */
  public void disconnectForPlanning( boolean priority ) throws Exception
  {
    mLogger.warn("disconnectForPlanning");
    
    if ( !priority )
    {
      // allow another low priority thread to connect
      mLowPriorityQueue.unlock();

        boolean update = false;
        {
          // check if the rcon_id exists in the table
          CallableStatement stmt = mConnection.prepareCall("select rcon_id from release_manager.run_level where rcon_id=" + rcon_id);
          ResultSet rset = stmt.executeQuery();
mLogger.warn("updateCurrentRunLevel: checked existance: " + rcon_id);
          
          while( rset.next() )
          {
            update = true;
          }

        if ( !update && insert )
        {
          
          if (isRconIdConfigured( rcon_id ))
          {
mLogger.warn("updateCurrentRunLevel: Must insert: " + rcon_id);
            CallableStatement stmt = mConnection.prepareCall("insert into release_manager.run_level (rcon_id) values (" + rcon_id + ")" );
            stmt.executeUpdate();
            stmt.close();
          }
        }
 
        {
          // DEVI 52589 provide a keep alive indication
mLogger.warn("updateCurrentRunLevel: Set Runlevel:" + runLevel + ", rcon_id: " + rcon_id);
          PreparedStatement stmt = mConnection.prepareCall("update release_manager.run_level set current_run_level=" + runLevel + ", keep_alive=SYSDATE where rcon_id=" + rcon_id);
          stmt.executeUpdate();
          stmt.close();
        }
mLogger.warn("updateCurrentRunLevel: committing");
        commit();
mLogger.warn("updateCurrentRunLevel: committed");
      }
      catch( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

Rev 2541	Rev 4123
Line 221...	Line 221...
221	`sql = "select gm.gbe_value from release_manager.release_config rc, release_manager.gbe_machtype gm where rc.rtag_id=" + baseline + " and gm.gbe_id=rc.gbe_id";`	221	`sql = "select gm.gbe_value from release_manager.release_config rc, release_manager.gbe_machtype gm where rc.rtag_id=" + baseline + " and gm.gbe_id=rc.gbe_id";`
222	`}`	222	`}`
223	`else`	223	`else`
224	`{`	224	`{`
225	`sql =`	225	`sql =`
-		226	`"select gm.gbe_value " +`
226	`"select gm.gbe_value from deployment_manager.boms b, release_manager.release_config rc, release_manager.gbe_machtype gm where b.bom_id=" +`	227	`"from deployment_manager.boms b, release_manager.release_config rc, release_manager.gbe_machtype gm " +`
-		228	`"where b.bom_id=" + baseline +`
227	`baseline + " and rc.rtag_id=b.rtag_id_fk and gm.gbe_id=rc.gbe_id";`	229	`" and rc.rtag_id=b.rtag_id_fk "+`
-		230	`" and gm.gbe_id=rc.gbe_id";`
228	`}`	231	`}`
229		232
230	`try`	233	`try`
231	`{`	234	`{`
232	`CallableStatement stmt = mConnection.prepareCall(sql);`	235	`CallableStatement stmt = mConnection.prepareCall(sql);`
233	`ResultSet rset = stmt.executeQuery();`	236	`ResultSet rset = stmt.executeQuery();`
234		237
Line 252...	Line 255...
252	`mLogger.error("queryMachtypes database access error only");`	255	`mLogger.error("queryMachtypes database access error only");`
253	`throw new SQLException();`	256	`throw new SQLException();`
254	`}`	257	`}`
255	`else`	258	`else`
256	`{`	259	`{`
257	`mLogger.fatal("queryMachtypes show stopper");`	260	`mLogger.fatal("queryMachtypes show stopper:" + e.toString());`
258	`throw new Exception("queryMachtypes show stopper");`	261	`throw new Exception("queryMachtypes show stopper");`
259	`}`	262	`}`
260	`}`	263	`}`
261	`}`	264	`}`
262	`}`	265	`}`
Line 1507...	Line 1510...
1507	`{`	1510	`{`
1508	`try`	1511	`try`
1509	`{`	1512	`{`
1510	`if (daemonMode)`	1513	`if (daemonMode)`
1511	`{`	1514	`{`
1512	`mLogger.debug("queryPackageVersions: stmt0");`	1515	`mLogger.warn("queryPackageVersions: stmt0");`
1513	`Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();`	1516	`Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();`
1514	`globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());`	1517	`globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());`
1515		1518
1516	`CallableStatement stmt0 = mConnection.prepareCall(`	1519	`CallableStatement stmt0 = mConnection.prepareCall(`
1517	`"select u.user_email " +`	1520	`"select u.user_email " +`
Line 1538...	Line 1541...
1538	`rset0.close();`	1541	`rset0.close();`
1539	`stmt0.close();`	1542	`stmt0.close();`
1540		1543
1541	`// get planned package info`	1544	`// get planned package info`
1542	`// devi 48629 support multiple wips on the same package and build in the order they were released`	1545	`// devi 48629 support multiple wips on the same package and build in the order they were released`
1543	`mLogger.debug("queryPackageVersions: stmt1");`	1546	`mLogger.warn("queryPackageVersions: stmt1");`
1544	`CallableStatement stmt1 = mConnection.prepareCall(`	1547	`CallableStatement stmt1 = mConnection.prepareCall(`
1545	`"select pl.pv_id, p.pkg_id, p.pkg_name," +`	1548	`"select pl.pv_id, p.pkg_id, p.pkg_name," +`
1546	`"pv.v_ext, pv.change_type, pv.ripple_field," +`	1549	`"pv.v_ext, pv.change_type, pv.ripple_field," +`
1547	`"pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +`	1550	`"pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +`
1548	`"pv.modified_stamp," +`	1551	`"pv.modified_stamp," +`
Line 1681...	Line 1684...
1681		1684
1682	`rset1.close();`	1685	`rset1.close();`
1683	`stmt1.close();`	1686	`stmt1.close();`
1684		1687
1685	`// get planned package dependency info`	1688	`// get planned package dependency info`
1686	`mLogger.debug("queryPackageVersions: stmt2");`	1689	`mLogger.warn("queryPackageVersions: stmt2");`
1687	`CallableStatement stmt2 = mConnection.prepareCall(`	1690	`CallableStatement stmt2 = mConnection.prepareCall(`
1688	`"select pl.pv_id, p.pkg_name, dpv.v_ext, pv.modified_stamp " +`	1691	`"select pl.pv_id, p.pkg_name, dpv.v_ext, pv.modified_stamp " +`
1689	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`	1692	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`
1690	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1693	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1691	`"and pv.pv_id = pl.pv_id and pd.pv_id=pl.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +`	1694	`"and pv.pv_id = pl.pv_id and pd.pv_id=pl.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +`
Line 1739...	Line 1742...
1739		1742
1740	`rset2.close();`	1743	`rset2.close();`
1741	`stmt2.close();`	1744	`stmt2.close();`
1742		1745
1743	`// get planned package build info`	1746	`// get planned package build info`
1744	`mLogger.debug("queryPackageVersions: stmt3");`	1747	`mLogger.warn("queryPackageVersions: stmt3");`
1745	`CallableStatement stmt3 = mConnection.prepareCall(`	1748	`CallableStatement stmt3 = mConnection.prepareCall(`
1746	`"select pl.pv_id, bm.bm_name, bsa.bsa_name, pv.modified_stamp " +`	1749	`"select pl.pv_id, bm.bm_name, bsa.bsa_name, pv.modified_stamp " +`
1747	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`	1750	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`
1748	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1751	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1749	`"and pv.pv_id = pl.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +`	1752	`"and pv.pv_id = pl.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +`
Line 1802...	Line 1805...
1802		1805
1803	`rset3.close();`	1806	`rset3.close();`
1804	`stmt3.close();`	1807	`stmt3.close();`
1805		1808
1806	`// get planned package unit test info`	1809	`// get planned package unit test info`
1807	`mLogger.debug("queryPackageVersions: stmt4");`	1810	`mLogger.warn("queryPackageVersions: stmt4");`
1808	`CallableStatement stmt4 = mConnection.prepareCall(`	1811	`CallableStatement stmt4 = mConnection.prepareCall(`
1809	`"select pl.pv_id, tt.test_type_name, pv.modified_stamp " +`	1812	`"select pl.pv_id, tt.test_type_name, pv.modified_stamp " +`
1810	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`	1813	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`
1811	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1814	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1812	`"and pv.pv_id = pl.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +`	1815	`"and pv.pv_id = pl.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +`
Line 1856...	Line 1859...
1856	`rset4.close();`	1859	`rset4.close();`
1857	`stmt4.close();`	1860	`stmt4.close();`
1858		1861
1859	`// get planned package build failure info...`	1862	`// get planned package build failure info...`
1860	`// global and project wide based`	1863	`// global and project wide based`
1861	`mLogger.debug("queryPackageVersions: stmt50");`	1864	`mLogger.warn("queryPackageVersions: stmt50");`
1862	`CallableStatement stmt50 = mConnection.prepareCall(`	1865	`CallableStatement stmt50 = mConnection.prepareCall(`
1863	`"select pl.pv_id, pv.modified_stamp " +`	1866	`"select pl.pv_id, pv.modified_stamp " +`
1864	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv " +`	1867	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv " +`
1865	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`	1868	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`
1866	`"and pv.pv_id = pl.pv_id " +`	1869	`"and pv.pv_id = pl.pv_id " +`
Line 1896...	Line 1899...
1896		1899
1897	`rset50.close();`	1900	`rset50.close();`
1898	`stmt50.close();`	1901	`stmt50.close();`
1899		1902
1900	`// view based`	1903	`// view based`
1901	`mLogger.debug("queryPackageVersions: stmt5");`	1904	`mLogger.warn("queryPackageVersions: stmt5");`
1902	`CallableStatement stmt5 = mConnection.prepareCall(`	1905	`CallableStatement stmt5 = mConnection.prepareCall(`
1903	`"select pl.pv_id, u.user_email, pv.modified_stamp " +`	1906	`"select pl.pv_id, u.user_email, pv.modified_stamp " +`
1904	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +`	1907	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +`
1905	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`	1908	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`
1906	`"and pv.pv_id = pl.pv_id and af.view_id=pl.view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +`	1909	`"and pv.pv_id = pl.pv_id and af.view_id=pl.view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +`
Line 1938...	Line 1941...
1938		1941
1939	`rset5.close();`	1942	`rset5.close();`
1940	`stmt5.close();`	1943	`stmt5.close();`
1941		1944
1942	`// package version`	1945	`// package version`
1943	`mLogger.debug("queryPackageVersions: stmt51");`	1946	`mLogger.warn("queryPackageVersions: stmt51");`
1944	`CallableStatement stmt51 = mConnection.prepareCall(`	1947	`CallableStatement stmt51 = mConnection.prepareCall(`
1945	`"select pl.pv_id, u1.user_email, u2.user_email, u3.user_email, pv.modified_stamp " +`	1948	`"select pl.pv_id, u1.user_email, u2.user_email, u3.user_email, pv.modified_stamp " +`
1946	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.users u1, release_manager.users u2, release_manager.users u3 " +`	1949	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.users u1, release_manager.users u2, release_manager.users u3 " +`
1947	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`	1950	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`
1948	`"and pv.pv_id = pl.pv_id and u1.user_id=pv.creator_id and u2.user_id=pv.owner_id and u3.user_id=pv.modifier_id " +`	1951	`"and pv.pv_id = pl.pv_id and u1.user_id=pv.creator_id and u2.user_id=pv.owner_id and u3.user_id=pv.modifier_id " +`
Line 1986...	Line 1989...
1986		1989
1987	`rset51.close();`	1990	`rset51.close();`
1988	`stmt51.close();`	1991	`stmt51.close();`
1989		1992
1990	`// get planned package advisory ripple info`	1993	`// get planned package advisory ripple info`
1991	`mLogger.debug("queryPackageVersions: stmt7");`	1994	`mLogger.warn("queryPackageVersions: stmt7");`
1992	`CallableStatement stmt7 = mConnection.prepareCall(`	1995	`CallableStatement stmt7 = mConnection.prepareCall(`
1993	`"select pl.pv_id, pv.modified_stamp " +`	1996	`"select pl.pv_id, pv.modified_stamp " +`
1994	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`	1997	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`
1995	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1998	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1996	`"and pv.pv_id = pl.pv_id and ar.rtag_id=pl.rtag_id and ar.pv_id=pl.pv_id " +`	1999	`"and pv.pv_id = pl.pv_id and ar.rtag_id=pl.rtag_id and ar.pv_id=pl.pv_id " +`
Line 2027...	Line 2030...
2027		2030
2028	`rset7.close();`	2031	`rset7.close();`
2029	`stmt7.close();`	2032	`stmt7.close();`
2030		2033
2031	`// get released package info`	2034	`// get released package info`
2032	`mLogger.debug("queryPackageVersions: stmt8");`	2035	`mLogger.warn("queryPackageVersions: stmt8");`
2033	`CallableStatement stmt8 = mConnection.prepareCall(`	2036	`CallableStatement stmt8 = mConnection.prepareCall(`
2034	`"select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +`	2037	`"select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +`
2035	`"pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +`	2038	`"pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +`
2036	`"pv.build_number_limit," +`	2039	`"pv.build_number_limit," +`
2037	`"release_manager.PK_RMAPI.return_vcs_tag(rc.pv_id) AS vcsTag" +`	2040	`"release_manager.PK_RMAPI.return_vcs_tag(rc.pv_id) AS vcsTag" +`
Line 2041...	Line 2044...
2041	`" where rc.rtag_id=" + baseline +`	2044	`" where rc.rtag_id=" + baseline +`
2042	`" and pv.pv_id = rc.pv_id" +`	2045	`" and pv.pv_id = rc.pv_id" +`
2043	`" and p.pkg_id = pv.pkg_id" +`	2046	`" and p.pkg_id = pv.pkg_id" +`
2044	`" order by rc.pv_id"`	2047	`" order by rc.pv_id"`
2045	`);`	2048	`);`
-		2049	`mLogger.warn("queryPackageVersions: stmt8 Prepared");`
2046	`ResultSet rset8 = stmt8.executeQuery();`	2050	`ResultSet rset8 = stmt8.executeQuery();`
-		2051	`mLogger.warn("queryPackageVersions: stmt8 Query Done");`
2047		2052
2048	`while( rset8.next() )`	2053	`while( rset8.next() )`
2049	`{`	2054	`{`
2050	`int pv_id = rset8.getInt("pv_id");`	2055	`int pv_id = rset8.getInt("pv_id");`
2051		2056
Line 2161...	Line 2166...
2161		2166
2162	`plannedPackage.mVersion = pkg_version;`	2167	`plannedPackage.mVersion = pkg_version;`
2163	`}`	2168	`}`
2164	`}`	2169	`}`
2165		2170
-		2171	`mLogger.warn("queryPackageVersions: stmt8 processing complete");`
2166	`rset8.close();`	2172	`rset8.close();`
2167	`stmt8.close();`	2173	`stmt8.close();`
2168		2174
2169	`// get released package dependency info`	2175	`// get released package dependency info`
2170	`// the not exists subquery was added to ignore dependencies for 'pegged' package versions in a release - DEVI 48876`	2176	`// the not exists subquery was added to ignore dependencies for 'pegged' package versions in a release - DEVI 48876`
2171	`// this is the ONLY support for dealing with an inconsistent set of package versions`	2177	`// this is the ONLY support for dealing with an inconsistent set of package versions`
2172	`mLogger.debug("queryPackageVersions: stmt9");`	2178	`mLogger.warn("queryPackageVersions: stmt9");`
2173	`CallableStatement stmt9 = mConnection.prepareCall(`	2179	`CallableStatement stmt9 = mConnection.prepareCall(`
2174	`"select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +`	2180	`"select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +`
2175	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`	2181	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`
2176	`"where rc.rtag_id=" + baseline +`	2182	`"where rc.rtag_id=" + baseline +`
2177	`" and pv.pv_id = rc.pv_id and pd.pv_id=pv.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +`	2183	`" and pv.pv_id = rc.pv_id and pd.pv_id=pv.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +`
2178	`" and not exists (select pv_id from pegged_versions where pv_id=pv.pv_id and rtag_id=rc.rtag_id) " +`	2184	`" and not exists (select pv_id from pegged_versions where pv_id=pv.pv_id and rtag_id=rc.rtag_id) " +`
2179	`"order by rc.pv_id"`	2185	`"order by rc.pv_id"`
2180	`);`	2186	`);`
-		2187	`mLogger.warn("queryPackageVersions: stmt9 prepared");`
2181	`ResultSet rset9 = stmt9.executeQuery();`	2188	`ResultSet rset9 = stmt9.executeQuery();`
-		2189	`mLogger.warn("queryPackageVersions: stmt9 query done");`
2182		2190
2183	`while( rset9.next() )`	2191	`while( rset9.next() )`
2184	`{`	2192	`{`
2185	`boolean ignore = false;`	2193	`boolean ignore = false;`
2186		2194
Line 2230...	Line 2238...
2230	`{`	2238	`{`
2231	`p.mDependencyCollection.add(pkg_name + v_ext);`	2239	`p.mDependencyCollection.add(pkg_name + v_ext);`
2232	`p.mDependencyIDCollection.add(dpv_id);`	2240	`p.mDependencyIDCollection.add(dpv_id);`
2233	`}`	2241	`}`
2234	`}`	2242	`}`
-		2243	`mLogger.warn("queryPackageVersions: stmt9 processing complete");`
2235		2244
2236	`rset9.close();`	2245	`rset9.close();`
2237	`stmt9.close();`	2246	`stmt9.close();`
2238		2247
2239	`// get released package build info`	2248	`// get released package build info`
2240	`mLogger.debug("queryPackageVersions: stmt10");`	2249	`mLogger.warn("queryPackageVersions: stmt10");`
2241	`CallableStatement stmt10 = mConnection.prepareCall(`	2250	`CallableStatement stmt10 = mConnection.prepareCall(`
2242	`"select rc.pv_id, bm.bm_name, bsa.bsa_name " +`	2251	`"select rc.pv_id, bm.bm_name, bsa.bsa_name " +`
2243	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`	2252	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`
2244	`"where rc.rtag_id=" + baseline +`	2253	`"where rc.rtag_id=" + baseline +`
2245	`" and pv.pv_id = rc.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +`	2254	`" and pv.pv_id = rc.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +`
Line 2298...	Line 2307...
2298		2307
2299	`rset10.close();`	2308	`rset10.close();`
2300	`stmt10.close();`	2309	`stmt10.close();`
2301		2310
2302	`// get released package unit test info`	2311	`// get released package unit test info`
2303	`mLogger.debug("queryPackageVersions: stmt11");`	2312	`mLogger.warn("queryPackageVersions: stmt11");`
2304	`CallableStatement stmt11 = mConnection.prepareCall(`	2313	`CallableStatement stmt11 = mConnection.prepareCall(`
2305	`"select rc.pv_id, tt.test_type_name " +`	2314	`"select rc.pv_id, tt.test_type_name " +`
2306	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`	2315	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`
2307	`"where rc.rtag_id=" + baseline +`	2316	`"where rc.rtag_id=" + baseline +`
2308	`" and pv.pv_id = rc.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +`	2317	`" and pv.pv_id = rc.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +`
Line 2352...	Line 2361...
2352	`rset11.close();`	2361	`rset11.close();`
2353	`stmt11.close();`	2362	`stmt11.close();`
2354		2363
2355	`// get released package build failure info...`	2364	`// get released package build failure info...`
2356	`// global and project wide based`	2365	`// global and project wide based`
2357	`mLogger.debug("queryPackageVersions: stmt120");`	2366	`mLogger.warn("queryPackageVersions: stmt120");`
2358	`CallableStatement stmt120 = mConnection.prepareCall(`	2367	`CallableStatement stmt120 = mConnection.prepareCall(`
2359	`"select rc.pv_id " +`	2368	`"select rc.pv_id " +`
2360	`"from release_manager.release_content rc, release_manager.release_tags rt, release_manager.package_versions pv " +`	2369	`"from release_manager.release_content rc, release_manager.release_tags rt, release_manager.package_versions pv " +`
2361	`"where rc.rtag_id=" + baseline + " and rt.rtag_id=rc.rtag_id " +`	2370	`"where rc.rtag_id=" + baseline + " and rt.rtag_id=rc.rtag_id " +`
2362	`"and pv.pv_id = rc.pv_id " +`	2371	`"and pv.pv_id = rc.pv_id " +`
Line 2392...	Line 2401...
2392		2401
2393	`rset120.close();`	2402	`rset120.close();`
2394	`stmt120.close();`	2403	`stmt120.close();`
2395		2404
2396	`// view based`	2405	`// view based`
2397	`mLogger.debug("queryPackageVersions: stmt12");`	2406	`mLogger.warn("queryPackageVersions: stmt12");`
2398	`CallableStatement stmt12 = mConnection.prepareCall(`	2407	`CallableStatement stmt12 = mConnection.prepareCall(`
2399	`"select rc.pv_id, u.user_email " +`	2408	`"select rc.pv_id, u.user_email " +`
2400	`"from release_manager.release_content rc, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +`	2409	`"from release_manager.release_content rc, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +`
2401	`"where rc.rtag_id=" + baseline + " and rt.rtag_id=rc.rtag_id " +`	2410	`"where rc.rtag_id=" + baseline + " and rt.rtag_id=rc.rtag_id " +`
2402	`"and pv.pv_id = rc.pv_id and af.view_id=rc.base_view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +`	2411	`"and pv.pv_id = rc.pv_id and af.view_id=rc.base_view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +`
Line 2434...	Line 2443...
2434		2443
2435	`rset12.close();`	2444	`rset12.close();`
2436	`stmt12.close();`	2445	`stmt12.close();`
2437		2446
2438	`// get released advisory ripple info`	2447	`// get released advisory ripple info`
2439	`mLogger.debug("queryPackageVersions: stmt14");`	2448	`mLogger.warn("queryPackageVersions: stmt14");`
2440	`CallableStatement stmt14 = mConnection.prepareCall(`	2449	`CallableStatement stmt14 = mConnection.prepareCall(`
2441	`"select rc.pv_id " +`	2450	`"select rc.pv_id " +`
2442	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`	2451	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`
2443	`"where rc.rtag_id=" + baseline +`	2452	`"where rc.rtag_id=" + baseline +`
2444	`" and pv.pv_id = rc.pv_id and ar.rtag_id=rc.rtag_id and ar.pv_id=rc.pv_id " +`	2453	`" and pv.pv_id = rc.pv_id and ar.rtag_id=rc.rtag_id and ar.pv_id=rc.pv_id " +`
Line 2518...	Line 2527...
2518	`// in all cases, build a meaningful email body to inform the user`	2527	`// in all cases, build a meaningful email body to inform the user`
2519	`// of the snapshot of build information that applied to the build and store in:`	2528	`// of the snapshot of build information that applied to the build and store in:`
2520	`// - mTestBuildEmailBody`	2529	`// - mTestBuildEmailBody`
2521		2530
2522	`// an op code of 1 means test build`	2531	`// an op code of 1 means test build`
2523	`mLogger.debug("queryPackageVersions: stmt141");`	2532	`mLogger.warn("queryPackageVersions: stmt141");`
2524	`instruction.value = 0;`	2533	`instruction.value = 0;`
2525	`while ( getDaemonInst( baseline, instruction, 1, pvid, userid ) )`	2534	`while ( getDaemonInst( baseline, instruction, 1, pvid, userid ) )`
2526	`{`	2535	`{`
2527	`// can only do one test build at a time - others will be discarded until future cycle`	2536	`// can only do one test build at a time - others will be discarded until future cycle`
2528	`boolean discard = false;`	2537	`boolean discard = false;`
Line 2558...	Line 2567...
2558	`String pkg_name = "";`	2567	`String pkg_name = "";`
2559	`String pkg_ext = "";`	2568	`String pkg_ext = "";`
2560	`String testBuildVcsTag = "null";`	2569	`String testBuildVcsTag = "null";`
2561		2570
2562	`// get wip package info`	2571	`// get wip package info`
2563	`mLogger.debug("queryPackageVersions: stmt15");`	2572	`mLogger.warn("queryPackageVersions: stmt15");`
2564	`CallableStatement stmt15 = mConnection.prepareCall(`	2573	`CallableStatement stmt15 = mConnection.prepareCall(`
2565	`"select p.pkg_name, pv.v_ext, release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag " +`	2574	`"select p.pkg_name, pv.v_ext, release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag " +`
2566	`" from release_manager.work_in_progress wip," +`	2575	`" from release_manager.work_in_progress wip," +`
2567	`"release_manager.package_versions pv," +`	2576	`"release_manager.package_versions pv," +`
2568	`"release_manager.packages p" +`	2577	`"release_manager.packages p" +`
Line 2602...	Line 2611...
2602	`}`	2611	`}`
2603		2612
2604	`rset15.close();`	2613	`rset15.close();`
2605	`stmt15.close();`	2614	`stmt15.close();`
2606		2615
2607	`mLogger.debug("queryPackageVersions: stmt16");`	2616	`mLogger.warn("queryPackageVersions: stmt16");`
2608	`if ( rsetSize == 0 )`	2617	`if ( rsetSize == 0 )`
2609	`{`	2618	`{`
2610	`mLogger.error("queryPackageVersions rset15 no wip found " + instruction.value);`	2619	`mLogger.error("queryPackageVersions rset15 no wip found " + instruction.value);`
2611	`markDaemonInstCompleted( instruction.value );`	2620	`markDaemonInstCompleted( instruction.value );`
2612	`}`	2621	`}`
Line 2665...	Line 2674...
2665		2674
2666	`rset16.close();`	2675	`rset16.close();`
2667	`stmt16.close();`	2676	`stmt16.close();`
2668		2677
2669	`// get planned package build info`	2678	`// get planned package build info`
2670	`mLogger.debug("queryPackageVersions: stmt17");`	2679	`mLogger.warn("queryPackageVersions: stmt17");`
2671	`CallableStatement stmt17 = mConnection.prepareCall(`	2680	`CallableStatement stmt17 = mConnection.prepareCall(`
2672	`"select bm.bm_name, bsa.bsa_name " +`	2681	`"select bm.bm_name, bsa.bsa_name " +`
2673	`"from release_manager.work_in_progress wip, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`	2682	`"from release_manager.work_in_progress wip, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`
2674	`"where wip.rtag_id=" + baseline +`	2683	`"where wip.rtag_id=" + baseline +`
2675	`" and wip.pv_id=" + testBuildPvId +`	2684	`" and wip.pv_id=" + testBuildPvId +`
Line 2713...	Line 2722...
2713	`}`	2722	`}`
2714	`}`	2723	`}`
2715	`else`	2724	`else`
2716	`{`	2725	`{`
2717	`// get released product info`	2726	`// get released product info`
2718	`mLogger.debug("queryPackageVersions: stmt18");`	2727	`mLogger.warn("queryPackageVersions: stmt18");`
2719	`CallableStatement stmt = mConnection.prepareCall(`	2728	`CallableStatement stmt = mConnection.prepareCall(`
2720	`"select oc.prod_id, p.pkg_name, pv.pkg_version, pv.v_ext," +`	2729	`"select oc.prod_id, p.pkg_name, pv.pkg_version, pv.v_ext," +`
2721	`"release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag" +`	2730	`"release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag" +`
2722	`" from deployment_manager.bom_contents bc," +`	2731	`" from deployment_manager.bom_contents bc," +`
2723	`"deployment_manager.operating_systems os," +`	2732	`"deployment_manager.operating_systems os," +`
Line 4589...	Line 4598...
4589		4598
4590	`/**disconnect from oracle`	4599	`/**disconnect from oracle`
4591	`*/`	4600	`*/`
4592	`public void disconnectForPlanning( boolean priority ) throws Exception`	4601	`public void disconnectForPlanning( boolean priority ) throws Exception`
4593	`{`	4602	`{`
4594	`mLogger.debug("disconnectForPlanning");`	4603	`mLogger.warn("disconnectForPlanning");`
4595		4604
4596	`if ( !priority )`	4605	`if ( !priority )`
4597	`{`	4606	`{`
4598	`// allow another low priority thread to connect`	4607	`// allow another low priority thread to connect`
4599	`mLowPriorityQueue.unlock();`	4608	`mLowPriorityQueue.unlock();`
Line 5743...	Line 5752...
5743	`boolean update = false;`	5752	`boolean update = false;`
5744	`{`	5753	`{`
5745	`// check if the rcon_id exists in the table`	5754	`// check if the rcon_id exists in the table`
5746	`CallableStatement stmt = mConnection.prepareCall("select rcon_id from release_manager.run_level where rcon_id=" + rcon_id);`	5755	`CallableStatement stmt = mConnection.prepareCall("select rcon_id from release_manager.run_level where rcon_id=" + rcon_id);`
5747	`ResultSet rset = stmt.executeQuery();`	5756	`ResultSet rset = stmt.executeQuery();`
-		5757	`mLogger.warn("updateCurrentRunLevel: checked existance: " + rcon_id);`
5748		5758
5749	`while( rset.next() )`	5759	`while( rset.next() )`
5750	`{`	5760	`{`
5751	`update = true;`	5761	`update = true;`
5752	`}`	5762	`}`
Line 5760...	Line 5770...
5760	`if ( !update && insert )`	5770	`if ( !update && insert )`
5761	`{`	5771	`{`
5762		5772
5763	`if (isRconIdConfigured( rcon_id ))`	5773	`if (isRconIdConfigured( rcon_id ))`
5764	`{`	5774	`{`
-		5775	`mLogger.warn("updateCurrentRunLevel: Must insert: " + rcon_id);`
5765	`CallableStatement stmt = mConnection.prepareCall("insert into release_manager.run_level (rcon_id) values (" + rcon_id + ")" );`	5776	`CallableStatement stmt = mConnection.prepareCall("insert into release_manager.run_level (rcon_id) values (" + rcon_id + ")" );`
5766	`stmt.executeUpdate();`	5777	`stmt.executeUpdate();`
5767	`stmt.close();`	5778	`stmt.close();`
5768	`}`	5779	`}`
5769	`}`	5780	`}`
5770		5781
5771	`{`	5782	`{`
5772	`// DEVI 52589 provide a keep alive indication`	5783	`// DEVI 52589 provide a keep alive indication`
-		5784	`mLogger.warn("updateCurrentRunLevel: Set Runlevel:" + runLevel + ", rcon_id: " + rcon_id);`
5773	`PreparedStatement stmt = mConnection.prepareCall("update release_manager.run_level set current_run_level=" + runLevel + ", keep_alive=SYSDATE where rcon_id=" + rcon_id);`	5785	`PreparedStatement stmt = mConnection.prepareCall("update release_manager.run_level set current_run_level=" + runLevel + ", keep_alive=SYSDATE where rcon_id=" + rcon_id);`
5774	`stmt.executeUpdate();`	5786	`stmt.executeUpdate();`
5775	`stmt.close();`	5787	`stmt.close();`
5776	`}`	5788	`}`
-		5789	`mLogger.warn("updateCurrentRunLevel: committing");`
5777	`commit();`	5790	`commit();`
-		5791	`mLogger.warn("updateCurrentRunLevel: committed");`
5778	`}`	5792	`}`
5779	`catch( SQLException e )`	5793	`catch( SQLException e )`
5780	`{`	5794	`{`
5781	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	5795	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
5782	`{`	5796	`{`

Subversion Repositories DevTools

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