X-Git-Url: https://gerrit.onap.org/r/gitweb?p=dmaap%2Fdatarouter.git;a=blobdiff_plain;f=datarouter-prov%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fdmaap%2Fdatarouter%2Fprovisioning%2Fbeans%2FParameters.java;h=79fc91b112c69303ef1cc23aa26bbbd39ccd6dda;hp=14a0a9dcb61320528a668169e3630013738e6daa;hb=adb2ad2d16e851fbf8dcc71af68949a74463204d;hpb=68a9ca240970fceaf12bbe91b7bad8e1d98ecd93

diff --git a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/Parameters.java b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/Parameters.java
index 14a0a9dc..79fc91b1 100644
--- a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/Parameters.java
+++ b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/Parameters.java
@@ -108,8 +108,8 @@ public class Parameters extends Syncable {
     public static Collection<Parameters> getParameterCollection() {
         Collection<Parameters> coll = new ArrayList<>();
         try (Connection conn = ProvDbUtils.getInstance().getConnection();
-            PreparedStatement ps = conn.prepareStatement("select * from PARAMETERS")) {
-            ResultSet rs = ps.executeQuery();
+            PreparedStatement ps = conn.prepareStatement("select * from PARAMETERS");
+            ResultSet rs = ps.executeQuery()) {
             while (rs.next()) {
                 Parameters param = new Parameters(rs);
                 coll.add(param);
@@ -132,9 +132,10 @@ public class Parameters extends Syncable {
             PreparedStatement stmt = conn.prepareStatement(
                 "select KEYNAME, VALUE from PARAMETERS where KEYNAME = ?")) {
             stmt.setString(1, key);
-            ResultSet rs = stmt.executeQuery();
-            if (rs.next()) {
-                val = new Parameters(rs);
+            try (ResultSet rs = stmt.executeQuery()) {
+                if (rs.next()) {
+                    val = new Parameters(rs);
+                }
             }
         } catch (SQLException e) {
             intlogger.error(SQLEXCEPTION + e.getMessage(), e);