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



          if ( machtype != null )
          {
            machtypeCollection.add(machtype);
          }
        }
        
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

            {
              retVal += "." + bom_lifecycle;
            }
          }
        }
        
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

              p.mPid = pkg_id;
              p.mDirectlyPlanned = true;
              packageCollection.add(p);
            }
          }
          
          rset1.close();
          stmt1.close();
 
          // get planned package dependency info
          CallableStatement stmt2 = mConnection.prepareCall(
          "select pl.pv_id, p.pkg_name, dpv.v_ext " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +

              p.mDependencyCollection.add(pkg_name + v_ext);
              p.mDependencyIDCollection.add(-1);
            }
          }
          
          rset2.close();
          stmt2.close();
          
          // get planned package build info
          CallableStatement stmt3 = mConnection.prepareCall(
          "select pl.pv_id, bm.bm_name, bsa.bsa_name " +
          "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' " +

              {
                p.mBuildStandardCollection.add(bs);
              }
            }
          }
          
          rset3.close();
          stmt3.close();
 
          // get planned package unit test info
          CallableStatement stmt4 = mConnection.prepareCall(
          "select pl.pv_id, tt.test_type_name " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +

              {
                p.mHasAutomatedUnitTests = true;
              }
            }
          }
          
          rset4.close();
          stmt4.close();
 
          // get planned package build failure info
          CallableStatement stmt5 = mConnection.prepareCall(
          "select pl.pv_id, u.user_email " +
          "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 " +

            if ( !ignore )
            {
              p.mBuildFailureEmailCollection.add(user_email);
            }
          }
          
          rset5.close();
          stmt5.close();
 
          // get planned package do not ripple info
          CallableStatement stmt6 = mConnection.prepareCall(
          "select pl.pv_id " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +

            if ( !ignore )
            {
              p.mDoNotRipple = true;
            }
          }
          
          rset6.close();
          stmt6.close();
 
          // get planned package advisory ripple info
          CallableStatement stmt7 = mConnection.prepareCall(
          "select pl.pv_id " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +

            {
              p.mAdvisoryRipple = true;
            }
          }
          
          rset7.close();
          stmt7.close();
          
          // get released package info
          CallableStatement stmt8 = mConnection.prepareCall(
          "select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext, pv.pkg_label, pv.src_path, pv.ripple_field " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.packages p " +
          "where rc.rtag_id=" + baseline +

              }
 
              plannedPackage.mVersion = pkg_version;
            }
          }
          
          rset8.close();
          stmt8.close();
 
          // get released package dependency info
          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 " +

            {
              p.mDependencyCollection.add(pkg_name + v_ext);
              p.mDependencyIDCollection.add(dpv_id);
            }
          }
          
          rset9.close();
          stmt9.close();
           
          // get released package build info
          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 " +

              {
                p.mBuildStandardCollection.add(bs);
              }
            }
          }
          
          rset10.close();
          stmt10.close();
 
          // get released package unit test info
          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 " +

              {
                p.mHasAutomatedUnitTests = true;
              }
            }
          }
          
          rset11.close();
          stmt11.close();
 
          // get released package build failure email info
          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 " +

            if ( !ignore )
            {
              p.mBuildFailureEmailCollection.add(user_email);
            }
          }
          
          rset12.close();
          stmt12.close();
 
          // get released package do not ripple info
          CallableStatement stmt13 = mConnection.prepareCall(
          "select rc.pv_id " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +

            if ( !ignore )
            {
              p.mDoNotRipple = true;
            }
          }
          
          rset13.close();
          stmt13.close();
 
          // get released advisory ripple info
          CallableStatement stmt14 = mConnection.prepareCall(
          "select rc.pv_id " +
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +

            if ( !ignore )
            {
              p.mAdvisoryRipple = true;
            }
          }
          
          rset14.close();
          stmt14.close();
        }
        else
        {
          // get released product info
          CallableStatement stmt = mConnection.prepareCall(

            }
              
            Package p = new Package(pv_id, pkg_name, pkg_version, v_ext, pkg_name + "." + pkg_version, pkg_label, src_path, 'x');
            packageCollection.add(p);
          }
          
          rset.close();
          stmt.close();
        }
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )

          if ( config != null )
          {
            retVal += config;
          }
        }
        
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

          if ( config != null )
          {
            retVal += config;
          }
        }
        
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

            
            Package p = new Package(pv_id, pkg_name, pkg_version, v_ext, pkg_name + "." + pkg_version, pkg_label, src_path, 'x');
            resultset.add(p);
            pkg.mDependencyCollection.add(p.mAlias);
          }
          
          rset.close();
          stmt.close();
        }
        catch ( SQLException e )
        {
          if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
          {

          if ( supportedBuildStandard )
          {
            p.mBuildStandardCollection.add(bs);
          }
        }
        
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

        
        while( rset1.next() )
        {
          rsetSize++;
        }
        
        rset1.close();
        stmt1.close();
 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
          // show stopper

          
          while( rset2.next() )
          {
            rsetSize++;
          }
          
          rset2.close();
          stmt2.close();
 
          if ( rsetSize > 1 )
          {
            mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
            // show stopper

            
            while( rset3.next() )
            {
              rsetSize++;
            }
            
            rset3.close();
            stmt3.close();
 
            if ( rsetSize > 1 )
            {
              mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);
              // show stopper

          if ( !rset.wasNull() )
          {
            retVal = false;
          }
        }
        
        rset.close();
        stmt.close();
 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryDirectedRunLevel rsetSize > 1");
          // show stopper

            {
              retVal = true;
            }
          }
        }
        
        rset.close();
        stmt.close();
 
        if ( rsetSize > 1 )
        {
          mLogger.fatal("queryReleaseConfig 1 rsetSize > 1");
          // show stopper

          
          ReleaseConfig releaseConfig = new ReleaseConfig( rtag_id, rcon_id, dm, gbe_buildfilter );
          mReleaseConfigCollection.add(releaseConfig);
        }
        
        
        rset.close();
        stmt.close();
        disconnect();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )

          
          ReleaseConfig releaseConfig = new ReleaseConfig( rtag_id, rcon_id, dm, gbe_buildfilter );
          mReleaseConfigCollection.add(releaseConfig);
        }
        
        rset.close();
        stmt.close();
        disconnect();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )

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

          mLogger.fatal("queryRunLevel 2 rsetSize == 0");
          // show stopper
          throw new Exception();
        }
        
        rset.close();
        stmt.close();
        disconnect();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )

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

            // indefinite pause is non null
            mLogger.warn("queryRunLevelSchedule indefinite pause");
            retVal = false;
          }
        }
        
        rset.close();
        stmt.close();
      }
      catch ( SQLException e )
      {
        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
        {

          
          while( rset.next() )
          {
            update = true;
          }
          
          rset.close();
          stmt.close();
        }
        
        if ( !update )
        {
          // check if the rcon_id is still configured

            
            while( rset.next() )
            {
              configured = true;
            }
            
            rset.close();
            stmt.close();
          }
          CallableStatement stmt = mConnection.prepareCall("insert into release_manager.run_level (rcon_id) values (" + rcon_id + ")" );
          stmt.executeUpdate();
          stmt.close();
        }
 
        {
          CallableStatement stmt = mConnection.prepareCall("update release_manager.run_level set current_run_level=" + runLevel + " where rcon_id=" + rcon_id);
          stmt.executeUpdate();
          stmt.close();
        }
        mConnection.commit();
        disconnect();
      }
      catch( SQLException e )

Rev 820	Rev 830
Line 171...	Line 171...
171	`if ( machtype != null )`	171	`if ( machtype != null )`
172	`{`	172	`{`
173	`machtypeCollection.add(machtype);`	173	`machtypeCollection.add(machtype);`
174	`}`	174	`}`
175	`}`	175	`}`
-		176
-		177	`rset.close();`
-		178	`stmt.close();`
176	`}`	179	`}`
177	`catch ( SQLException e )`	180	`catch ( SQLException e )`
178	`{`	181	`{`
179	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	182	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
180	`{`	183	`{`
Line 278...	Line 281...
278	`{`	281	`{`
279	`retVal += "." + bom_lifecycle;`	282	`retVal += "." + bom_lifecycle;`
280	`}`	283	`}`
281	`}`	284	`}`
282	`}`	285	`}`
-		286
-		287	`rset.close();`
-		288	`stmt.close();`
283	`}`	289	`}`
284	`catch ( SQLException e )`	290	`catch ( SQLException e )`
285	`{`	291	`{`
286	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	292	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
287	`{`	293	`{`
Line 1421...	Line 1427...
1421	`p.mPid = pkg_id;`	1427	`p.mPid = pkg_id;`
1422	`p.mDirectlyPlanned = true;`	1428	`p.mDirectlyPlanned = true;`
1423	`packageCollection.add(p);`	1429	`packageCollection.add(p);`
1424	`}`	1430	`}`
1425	`}`	1431	`}`
-		1432
-		1433	`rset1.close();`
-		1434	`stmt1.close();`
1426		1435
1427	`// get planned package dependency info`	1436	`// get planned package dependency info`
1428	`CallableStatement stmt2 = mConnection.prepareCall(`	1437	`CallableStatement stmt2 = mConnection.prepareCall(`
1429	`"select pl.pv_id, p.pkg_name, dpv.v_ext " +`	1438	`"select pl.pv_id, p.pkg_name, dpv.v_ext " +`
1430	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`	1439	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`
Line 1477...	Line 1486...
1477	`p.mDependencyCollection.add(pkg_name + v_ext);`	1486	`p.mDependencyCollection.add(pkg_name + v_ext);`
1478	`p.mDependencyIDCollection.add(-1);`	1487	`p.mDependencyIDCollection.add(-1);`
1479	`}`	1488	`}`
1480	`}`	1489	`}`
1481		1490
-		1491	`rset2.close();`
-		1492	`stmt2.close();`
-		1493
1482	`// get planned package build info`	1494	`// get planned package build info`
1483	`CallableStatement stmt3 = mConnection.prepareCall(`	1495	`CallableStatement stmt3 = mConnection.prepareCall(`
1484	`"select pl.pv_id, bm.bm_name, bsa.bsa_name " +`	1496	`"select pl.pv_id, bm.bm_name, bsa.bsa_name " +`
1485	`"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 " +`	1497	`"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 " +`
1486	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1498	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
Line 1587...	Line 1599...
1587	`{`	1599	`{`
1588	`p.mBuildStandardCollection.add(bs);`	1600	`p.mBuildStandardCollection.add(bs);`
1589	`}`	1601	`}`
1590	`}`	1602	`}`
1591	`}`	1603	`}`
-		1604
-		1605	`rset3.close();`
-		1606	`stmt3.close();`
1592		1607
1593	`// get planned package unit test info`	1608	`// get planned package unit test info`
1594	`CallableStatement stmt4 = mConnection.prepareCall(`	1609	`CallableStatement stmt4 = mConnection.prepareCall(`
1595	`"select pl.pv_id, tt.test_type_name " +`	1610	`"select pl.pv_id, tt.test_type_name " +`
1596	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`	1611	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`
Line 1637...	Line 1652...
1637	`{`	1652	`{`
1638	`p.mHasAutomatedUnitTests = true;`	1653	`p.mHasAutomatedUnitTests = true;`
1639	`}`	1654	`}`
1640	`}`	1655	`}`
1641	`}`	1656	`}`
-		1657
-		1658	`rset4.close();`
-		1659	`stmt4.close();`
1642		1660
1643	`// get planned package build failure info`	1661	`// get planned package build failure info`
1644	`CallableStatement stmt5 = mConnection.prepareCall(`	1662	`CallableStatement stmt5 = mConnection.prepareCall(`
1645	`"select pl.pv_id, u.user_email " +`	1663	`"select pl.pv_id, u.user_email " +`
1646	`"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 " +`	1664	`"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 " +`
Line 1683...	Line 1701...
1683	`if ( !ignore )`	1701	`if ( !ignore )`
1684	`{`	1702	`{`
1685	`p.mBuildFailureEmailCollection.add(user_email);`	1703	`p.mBuildFailureEmailCollection.add(user_email);`
1686	`}`	1704	`}`
1687	`}`	1705	`}`
-		1706
-		1707	`rset5.close();`
-		1708	`stmt5.close();`
1688		1709
1689	`// get planned package do not ripple info`	1710	`// get planned package do not ripple info`
1690	`CallableStatement stmt6 = mConnection.prepareCall(`	1711	`CallableStatement stmt6 = mConnection.prepareCall(`
1691	`"select pl.pv_id " +`	1712	`"select pl.pv_id " +`
1692	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +`	1713	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +`
Line 1721...	Line 1742...
1721	`if ( !ignore )`	1742	`if ( !ignore )`
1722	`{`	1743	`{`
1723	`p.mDoNotRipple = true;`	1744	`p.mDoNotRipple = true;`
1724	`}`	1745	`}`
1725	`}`	1746	`}`
-		1747
-		1748	`rset6.close();`
-		1749	`stmt6.close();`
1726		1750
1727	`// get planned package advisory ripple info`	1751	`// get planned package advisory ripple info`
1728	`CallableStatement stmt7 = mConnection.prepareCall(`	1752	`CallableStatement stmt7 = mConnection.prepareCall(`
1729	`"select pl.pv_id " +`	1753	`"select pl.pv_id " +`
1730	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`	1754	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`
Line 1760...	Line 1784...
1760	`{`	1784	`{`
1761	`p.mAdvisoryRipple = true;`	1785	`p.mAdvisoryRipple = true;`
1762	`}`	1786	`}`
1763	`}`	1787	`}`
1764		1788
-		1789	`rset7.close();`
-		1790	`stmt7.close();`
-		1791
1765	`// get released package info`	1792	`// get released package info`
1766	`CallableStatement stmt8 = mConnection.prepareCall(`	1793	`CallableStatement stmt8 = mConnection.prepareCall(`
1767	`"select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext, pv.pkg_label, pv.src_path, pv.ripple_field " +`	1794	`"select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext, pv.pkg_label, pv.src_path, pv.ripple_field " +`
1768	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.packages p " +`	1795	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.packages p " +`
1769	`"where rc.rtag_id=" + baseline +`	1796	`"where rc.rtag_id=" + baseline +`
Line 1863...	Line 1890...
1863	`}`	1890	`}`
1864		1891
1865	`plannedPackage.mVersion = pkg_version;`	1892	`plannedPackage.mVersion = pkg_version;`
1866	`}`	1893	`}`
1867	`}`	1894	`}`
-		1895
-		1896	`rset8.close();`
-		1897	`stmt8.close();`
1868		1898
1869	`// get released package dependency info`	1899	`// get released package dependency info`
1870	`CallableStatement stmt9 = mConnection.prepareCall(`	1900	`CallableStatement stmt9 = mConnection.prepareCall(`
1871	`"select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +`	1901	`"select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +`
1872	`"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 " +`	1902	`"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 " +`
Line 1926...	Line 1956...
1926	`{`	1956	`{`
1927	`p.mDependencyCollection.add(pkg_name + v_ext);`	1957	`p.mDependencyCollection.add(pkg_name + v_ext);`
1928	`p.mDependencyIDCollection.add(dpv_id);`	1958	`p.mDependencyIDCollection.add(dpv_id);`
1929	`}`	1959	`}`
1930	`}`	1960	`}`
-		1961
-		1962	`rset9.close();`
-		1963	`stmt9.close();`
1931		1964
1932	`// get released package build info`	1965	`// get released package build info`
1933	`CallableStatement stmt10 = mConnection.prepareCall(`	1966	`CallableStatement stmt10 = mConnection.prepareCall(`
1934	`"select rc.pv_id, bm.bm_name, bsa.bsa_name " +`	1967	`"select rc.pv_id, bm.bm_name, bsa.bsa_name " +`
1935	`"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 " +`	1968	`"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 " +`
Line 2036...	Line 2069...
2036	`{`	2069	`{`
2037	`p.mBuildStandardCollection.add(bs);`	2070	`p.mBuildStandardCollection.add(bs);`
2038	`}`	2071	`}`
2039	`}`	2072	`}`
2040	`}`	2073	`}`
-		2074
-		2075	`rset10.close();`
-		2076	`stmt10.close();`
2041		2077
2042	`// get released package unit test info`	2078	`// get released package unit test info`
2043	`CallableStatement stmt11 = mConnection.prepareCall(`	2079	`CallableStatement stmt11 = mConnection.prepareCall(`
2044	`"select rc.pv_id, tt.test_type_name " +`	2080	`"select rc.pv_id, tt.test_type_name " +`
2045	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`	2081	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`
Line 2085...	Line 2121...
2085	`{`	2121	`{`
2086	`p.mHasAutomatedUnitTests = true;`	2122	`p.mHasAutomatedUnitTests = true;`
2087	`}`	2123	`}`
2088	`}`	2124	`}`
2089	`}`	2125	`}`
-		2126
-		2127	`rset11.close();`
-		2128	`stmt11.close();`
2090		2129
2091	`// get released package build failure email info`	2130	`// get released package build failure email info`
2092	`CallableStatement stmt12 = mConnection.prepareCall(`	2131	`CallableStatement stmt12 = mConnection.prepareCall(`
2093	`"select rc.pv_id, u.user_email " +`	2132	`"select rc.pv_id, u.user_email " +`
2094	`"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 " +`	2133	`"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 " +`
Line 2130...	Line 2169...
2130	`if ( !ignore )`	2169	`if ( !ignore )`
2131	`{`	2170	`{`
2132	`p.mBuildFailureEmailCollection.add(user_email);`	2171	`p.mBuildFailureEmailCollection.add(user_email);`
2133	`}`	2172	`}`
2134	`}`	2173	`}`
-		2174
-		2175	`rset12.close();`
-		2176	`stmt12.close();`
2135		2177
2136	`// get released package do not ripple info`	2178	`// get released package do not ripple info`
2137	`CallableStatement stmt13 = mConnection.prepareCall(`	2179	`CallableStatement stmt13 = mConnection.prepareCall(`
2138	`"select rc.pv_id " +`	2180	`"select rc.pv_id " +`
2139	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +`	2181	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +`
Line 2167...	Line 2209...
2167	`if ( !ignore )`	2209	`if ( !ignore )`
2168	`{`	2210	`{`
2169	`p.mDoNotRipple = true;`	2211	`p.mDoNotRipple = true;`
2170	`}`	2212	`}`
2171	`}`	2213	`}`
-		2214
-		2215	`rset13.close();`
-		2216	`stmt13.close();`
2172		2217
2173	`// get released advisory ripple info`	2218	`// get released advisory ripple info`
2174	`CallableStatement stmt14 = mConnection.prepareCall(`	2219	`CallableStatement stmt14 = mConnection.prepareCall(`
2175	`"select rc.pv_id " +`	2220	`"select rc.pv_id " +`
2176	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`	2221	`"from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`
Line 2204...	Line 2249...
2204	`if ( !ignore )`	2249	`if ( !ignore )`
2205	`{`	2250	`{`
2206	`p.mAdvisoryRipple = true;`	2251	`p.mAdvisoryRipple = true;`
2207	`}`	2252	`}`
2208	`}`	2253	`}`
-		2254
-		2255	`rset14.close();`
-		2256	`stmt14.close();`
2209	`}`	2257	`}`
2210	`else`	2258	`else`
2211	`{`	2259	`{`
2212	`// get released product info`	2260	`// get released product info`
2213	`CallableStatement stmt = mConnection.prepareCall(`	2261	`CallableStatement stmt = mConnection.prepareCall(`
Line 2269...	Line 2317...
2269	`}`	2317	`}`
2270		2318
2271	`Package p = new Package(pv_id, pkg_name, pkg_version, v_ext, pkg_name + "." + pkg_version, pkg_label, src_path, 'x');`	2319	`Package p = new Package(pv_id, pkg_name, pkg_version, v_ext, pkg_name + "." + pkg_version, pkg_label, src_path, 'x');`
2272	`packageCollection.add(p);`	2320	`packageCollection.add(p);`
2273	`}`	2321	`}`
-		2322
-		2323	`rset.close();`
-		2324	`stmt.close();`
2274	`}`	2325	`}`
2275	`}`	2326	`}`
2276	`catch ( SQLException e )`	2327	`catch ( SQLException e )`
2277	`{`	2328	`{`
2278	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	2329	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
Line 2335...	Line 2386...
2335	`if ( config != null )`	2386	`if ( config != null )`
2336	`{`	2387	`{`
2337	`retVal += config;`	2388	`retVal += config;`
2338	`}`	2389	`}`
2339	`}`	2390	`}`
-		2391
-		2392	`rset.close();`
-		2393	`stmt.close();`
2340	`}`	2394	`}`
2341	`catch ( SQLException e )`	2395	`catch ( SQLException e )`
2342	`{`	2396	`{`
2343	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	2397	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
2344	`{`	2398	`{`
Line 2386...	Line 2440...
2386	`if ( config != null )`	2440	`if ( config != null )`
2387	`{`	2441	`{`
2388	`retVal += config;`	2442	`retVal += config;`
2389	`}`	2443	`}`
2390	`}`	2444	`}`
-		2445
-		2446	`rset.close();`
-		2447	`stmt.close();`
2391	`}`	2448	`}`
2392	`catch ( SQLException e )`	2449	`catch ( SQLException e )`
2393	`{`	2450	`{`
2394	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	2451	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
2395	`{`	2452	`{`
Line 2533...	Line 2590...
2533		2590
2534	`Package p = new Package(pv_id, pkg_name, pkg_version, v_ext, pkg_name + "." + pkg_version, pkg_label, src_path, 'x');`	2591	`Package p = new Package(pv_id, pkg_name, pkg_version, v_ext, pkg_name + "." + pkg_version, pkg_label, src_path, 'x');`
2535	`resultset.add(p);`	2592	`resultset.add(p);`
2536	`pkg.mDependencyCollection.add(p.mAlias);`	2593	`pkg.mDependencyCollection.add(p.mAlias);`
2537	`}`	2594	`}`
-		2595
-		2596	`rset.close();`
-		2597	`stmt.close();`
2538	`}`	2598	`}`
2539	`catch ( SQLException e )`	2599	`catch ( SQLException e )`
2540	`{`	2600	`{`
2541	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	2601	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
2542	`{`	2602	`{`
Line 2759...	Line 2819...
2759	`if ( supportedBuildStandard )`	2819	`if ( supportedBuildStandard )`
2760	`{`	2820	`{`
2761	`p.mBuildStandardCollection.add(bs);`	2821	`p.mBuildStandardCollection.add(bs);`
2762	`}`	2822	`}`
2763	`}`	2823	`}`
-		2824
-		2825	`rset.close();`
-		2826	`stmt.close();`
2764	`}`	2827	`}`
2765	`catch ( SQLException e )`	2828	`catch ( SQLException e )`
2766	`{`	2829	`{`
2767	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	2830	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
2768	`{`	2831	`{`
Line 2959...	Line 3022...
2959		3022
2960	`while( rset1.next() )`	3023	`while( rset1.next() )`
2961	`{`	3024	`{`
2962	`rsetSize++;`	3025	`rsetSize++;`
2963	`}`	3026	`}`
-		3027
-		3028	`rset1.close();`
-		3029	`stmt1.close();`
2964		3030
2965	`if ( rsetSize > 1 )`	3031	`if ( rsetSize > 1 )`
2966	`{`	3032	`{`
2967	`mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);`	3033	`mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);`
2968	`// show stopper`	3034	`// show stopper`
Line 2982...	Line 3048...
2982		3048
2983	`while( rset2.next() )`	3049	`while( rset2.next() )`
2984	`{`	3050	`{`
2985	`rsetSize++;`	3051	`rsetSize++;`
2986	`}`	3052	`}`
-		3053
-		3054	`rset2.close();`
-		3055	`stmt2.close();`
2987		3056
2988	`if ( rsetSize > 1 )`	3057	`if ( rsetSize > 1 )`
2989	`{`	3058	`{`
2990	`mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);`	3059	`mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);`
2991	`// show stopper`	3060	`// show stopper`
Line 3005...	Line 3074...
3005		3074
3006	`while( rset3.next() )`	3075	`while( rset3.next() )`
3007	`{`	3076	`{`
3008	`rsetSize++;`	3077	`rsetSize++;`
3009	`}`	3078	`}`
-		3079
-		3080	`rset3.close();`
-		3081	`stmt3.close();`
3010		3082
3011	`if ( rsetSize > 1 )`	3083	`if ( rsetSize > 1 )`
3012	`{`	3084	`{`
3013	`mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);`	3085	`mLogger.fatal("queryPackageVersions rsetSize > 1 " + pkg_id + " " + pkg_version);`
3014	`// show stopper`	3086	`// show stopper`
Line 3628...	Line 3700...
3628	`if ( !rset.wasNull() )`	3700	`if ( !rset.wasNull() )`
3629	`{`	3701	`{`
3630	`retVal = false;`	3702	`retVal = false;`
3631	`}`	3703	`}`
3632	`}`	3704	`}`
-		3705
-		3706	`rset.close();`
-		3707	`stmt.close();`
3633		3708
3634	`if ( rsetSize > 1 )`	3709	`if ( rsetSize > 1 )`
3635	`{`	3710	`{`
3636	`mLogger.fatal("queryDirectedRunLevel rsetSize > 1");`	3711	`mLogger.fatal("queryDirectedRunLevel rsetSize > 1");`
3637	`// show stopper`	3712	`// show stopper`
Line 3707...	Line 3782...
3707	`{`	3782	`{`
3708	`retVal = true;`	3783	`retVal = true;`
3709	`}`	3784	`}`
3710	`}`	3785	`}`
3711	`}`	3786	`}`
-		3787
-		3788	`rset.close();`
-		3789	`stmt.close();`
3712		3790
3713	`if ( rsetSize > 1 )`	3791	`if ( rsetSize > 1 )`
3714	`{`	3792	`{`
3715	`mLogger.fatal("queryReleaseConfig 1 rsetSize > 1");`	3793	`mLogger.fatal("queryReleaseConfig 1 rsetSize > 1");`
3716	`// show stopper`	3794	`// show stopper`
Line 3796...	Line 3874...
3796		3874
3797	`ReleaseConfig releaseConfig = new ReleaseConfig( rtag_id, rcon_id, dm, gbe_buildfilter );`	3875	`ReleaseConfig releaseConfig = new ReleaseConfig( rtag_id, rcon_id, dm, gbe_buildfilter );`
3798	`mReleaseConfigCollection.add(releaseConfig);`	3876	`mReleaseConfigCollection.add(releaseConfig);`
3799	`}`	3877	`}`
3800		3878
-		3879
-		3880	`rset.close();`
-		3881	`stmt.close();`
3801	`disconnect();`	3882	`disconnect();`
3802	`}`	3883	`}`
3803	`catch ( SQLException e )`	3884	`catch ( SQLException e )`
3804	`{`	3885	`{`
3805	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	3886	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
Line 3886...	Line 3967...
3886		3967
3887	`ReleaseConfig releaseConfig = new ReleaseConfig( rtag_id, rcon_id, dm, gbe_buildfilter );`	3968	`ReleaseConfig releaseConfig = new ReleaseConfig( rtag_id, rcon_id, dm, gbe_buildfilter );`
3888	`mReleaseConfigCollection.add(releaseConfig);`	3969	`mReleaseConfigCollection.add(releaseConfig);`
3889	`}`	3970	`}`
3890		3971
-		3972	`rset.close();`
-		3973	`stmt.close();`
3891	`disconnect();`	3974	`disconnect();`
3892	`}`	3975	`}`
3893	`catch ( SQLException e )`	3976	`catch ( SQLException e )`
3894	`{`	3977	`{`
3895	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	3978	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
Line 3944...	Line 4027...
3944	`mLogger.fatal("queryRunLevel 1 rsetSize > 1");`	4027	`mLogger.fatal("queryRunLevel 1 rsetSize > 1");`
3945	`// show stopper`	4028	`// show stopper`
3946	`throw new Exception();`	4029	`throw new Exception();`
3947	`}`	4030	`}`
3948		4031
-		4032	`rset.close();`
-		4033	`stmt.close();`
3949	`disconnect();`	4034	`disconnect();`
3950	`}`	4035	`}`
3951	`catch ( SQLException e )`	4036	`catch ( SQLException e )`
3952	`{`	4037	`{`
3953	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	4038	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
Line 4042...	Line 4127...
4042	`mLogger.fatal("queryRunLevel 2 rsetSize == 0");`	4127	`mLogger.fatal("queryRunLevel 2 rsetSize == 0");`
4043	`// show stopper`	4128	`// show stopper`
4044	`throw new Exception();`	4129	`throw new Exception();`
4045	`}`	4130	`}`
4046		4131
-		4132	`rset.close();`
-		4133	`stmt.close();`
4047	`disconnect();`	4134	`disconnect();`
4048	`}`	4135	`}`
4049	`catch ( SQLException e )`	4136	`catch ( SQLException e )`
4050	`{`	4137	`{`
4051	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	4138	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
Line 4116...	Line 4203...
4116	`mLogger.fatal("querySingleRunLevel rsetSize != 1");`	4203	`mLogger.fatal("querySingleRunLevel rsetSize != 1");`
4117	`// show stopper`	4204	`// show stopper`
4118	`throw new Exception();`	4205	`throw new Exception();`
4119	`}`	4206	`}`
4120		4207
-		4208	`rset.close();`
-		4209	`stmt.close();`
4121	`disconnect();`	4210	`disconnect();`
4122	`}`	4211	`}`
4123	`catch ( SQLException e )`	4212	`catch ( SQLException e )`
4124	`{`	4213	`{`
4125	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	4214	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
Line 4251...	Line 4340...
4251	`// indefinite pause is non null`	4340	`// indefinite pause is non null`
4252	`mLogger.warn("queryRunLevelSchedule indefinite pause");`	4341	`mLogger.warn("queryRunLevelSchedule indefinite pause");`
4253	`retVal = false;`	4342	`retVal = false;`
4254	`}`	4343	`}`
4255	`}`	4344	`}`
-		4345
-		4346	`rset.close();`
-		4347	`stmt.close();`
4256	`}`	4348	`}`
4257	`catch ( SQLException e )`	4349	`catch ( SQLException e )`
4258	`{`	4350	`{`
4259	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`	4351	`if ( mConnection == null \|\| ( mConnection != null && !mConnection.isValid(10) ) )`
4260	`{`	4352	`{`
Line 4298...	Line 4390...
4298		4390
4299	`while( rset.next() )`	4391	`while( rset.next() )`
4300	`{`	4392	`{`
4301	`update = true;`	4393	`update = true;`
4302	`}`	4394	`}`
-		4395
-		4396	`rset.close();`
-		4397	`stmt.close();`
4303	`}`	4398	`}`
4304		4399
4305	`if ( !update )`	4400	`if ( !update )`
4306	`{`	4401	`{`
4307	`// check if the rcon_id is still configured`	4402	`// check if the rcon_id is still configured`
Line 4312...	Line 4407...
4312		4407
4313	`while( rset.next() )`	4408	`while( rset.next() )`
4314	`{`	4409	`{`
4315	`configured = true;`	4410	`configured = true;`
4316	`}`	4411	`}`
-		4412
-		4413	`rset.close();`
-		4414	`stmt.close();`
4317	`}`	4415	`}`
4318	`CallableStatement stmt = mConnection.prepareCall("insert into release_manager.run_level (rcon_id) values (" + rcon_id + ")" );`	4416	`CallableStatement stmt = mConnection.prepareCall("insert into release_manager.run_level (rcon_id) values (" + rcon_id + ")" );`
4319	`stmt.executeUpdate();`	4417	`stmt.executeUpdate();`
-		4418	`stmt.close();`
4320	`}`	4419	`}`
4321		4420
4322	`{`	4421	`{`
4323	`CallableStatement stmt = mConnection.prepareCall("update release_manager.run_level set current_run_level=" + runLevel + " where rcon_id=" + rcon_id);`	4422	`CallableStatement stmt = mConnection.prepareCall("update release_manager.run_level set current_run_level=" + runLevel + " where rcon_id=" + rcon_id);`
4324	`stmt.executeUpdate();`	4423	`stmt.executeUpdate();`
-		4424	`stmt.close();`
4325	`}`	4425	`}`
4326	`mConnection.commit();`	4426	`mConnection.commit();`
4327	`disconnect();`	4427	`disconnect();`
4328	`}`	4428	`}`
4329	`catch( SQLException e )`	4429	`catch( SQLException e )`

Subversion Repositories DevTools

(root)/buildtool/trunk/src/generated/com/erggroup/buildtool/ripple/ReleaseManager.java @ 832 – Rev 820 → 830