From 417c0ab02b909f19cea5fa947a10c2089789d363 Mon Sep 17 00:00:00 2001 From: Arindam Mondal Date: Thu, 20 Sep 2018 19:51:53 +0900 Subject: Fix try-with-resources Issue-ID: DCAEGEN2-818 Change-Id: I7d8afc8bb78c9534671602ed37db7f6d14f5de81 Signed-off-by: arind.mondal --- .../org/onap/universalvesadapter/service/VESAdapterInitializer.java | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'UniversalVesAdapter/src') 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 ca1bcc9..b63eb1e 100644 --- a/UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java +++ b/UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java @@ -147,10 +147,9 @@ public class VESAdapterInitializer implements CommandLineRunner, Ordered { } public void fetchMappingFile() { - try (Connection con = DriverManager.getConnection(dBurl, user, pwd)) { + String query = "SELECT * FROM mapping_file"; + try (Connection con = DriverManager.getConnection(dBurl, user, pwd);PreparedStatement pstmt = con.prepareStatement(query);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"); -- cgit 1.2.3-korg