diff options
| author |   Vijay Venkatesh Kumar <vv770d@att.com> | 2018-11-02 03:07:18 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2018-11-02 03:07:18 +0000 |
| commit | 3d0e5068a95eb32087531598036073ea9c0d48c5 (patch) | |
| tree | 406bb1c7fcfe451eda9d972e85eaf62927e0e108 | |
| parent | cf689ad9076191a548e42b5927160a510c38b57a (diff) | |
| parent | 4f9b555bf0671cdfe1764ea2801b1251b473ae73 (diff) | |
Merge "Fix sonar issue: try with resources"
| -rw-r--r-- | UniversalVesAdapter/src/main/java/org/onap/universalvesadapter/service/VESAdapterInitializer.java | 4 |
1 files changed, 1 insertions, 3 deletions
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 --- 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"); |