Subversion Repositories DevTools

Rev

Rev 820 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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 )