Fix sonar issue: try with resources

Issue-ID: DCAEGEN2-818
Change-Id: I419e7db32e39dc4a52a3d33b074b0a289a66ab21
Signed-off-by: arindamm <arind.mondal@samsung.com>

diff --git a/UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java b/UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java
index a91e5c6..c195117 100644 (file)
--- a/UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java
+++ b/UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java
@@ -174,10 +174,8 @@ public class VESAdapterInitializer implements CommandLineRunner, Ordered {
 
        public void fetchMappingFile() {
                
-               try (Connection con = DriverManager.getConnection(dBurl, user, pwd)) {
+               try (Connection con = DriverManager.getConnection(dBurl, user, pwd);PreparedStatement pstmt = con.prepareStatement("SELECT * FROM mapping_file");ResultSet rs = pstmt.executeQuery()) {
                        LOGGER.info("Retrieving data from DB");
-                       PreparedStatement pstmt = con.prepareStatement("SELECT * FROM mapping_file");
-                       ResultSet rs = pstmt.executeQuery();
                        // parsing the column each time is a linear search
                        int column1Pos = rs.findColumn("enterpriseid");
                        int column2Pos = rs.findColumn("mappingfilecontents");