summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rwxr-xr-xdblib/provider/src/main/java/org/onap/ccsdk/sli/core/dblib/CachedDataSource.java10
1 files changed, 1 insertions, 9 deletions
diff --git a/dblib/provider/src/main/java/org/onap/ccsdk/sli/core/dblib/CachedDataSource.java b/dblib/provider/src/main/java/org/onap/ccsdk/sli/core/dblib/CachedDataSource.java
index a5902d54b..4d920e6a0 100755
--- a/dblib/provider/src/main/java/org/onap/ccsdk/sli/core/dblib/CachedDataSource.java
+++ b/dblib/provider/src/main/java/org/onap/ccsdk/sli/core/dblib/CachedDataSource.java
@@ -603,22 +603,14 @@ public abstract class CachedDataSource implements DataSource, SQLExecutionMonito
protected boolean unlockTable(Connection conn) {
boolean retValue = false;
- Statement lock = null;
- try {
+ try (Statement lock = conn.createStatement()){
if(LOGGER.isDebugEnabled()) {
LOGGER.debug("Executing 'UNLOCK TABLES' on connection " + conn.toString());
}
- lock = conn.createStatement();
retValue = lock.execute("UNLOCK TABLES");
} catch(Exception exc){
LOGGER.error("", exc);
retValue = false;
- } finally {
- try {
- lock.close();
- } catch(Exception exc) {
-
- }
}
return retValue;
}