/*-
* ============LICENSE_START=======================================================
- * OPENECOMP - MSO
+ * ONAP - SO
* ================================================================================
* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
* ================================================================================
import javax.xml.xpath.XPathExpressionException;
import javax.xml.xpath.XPathFactory;
+import org.openecomp.mso.logger.MsoLogger;
import org.w3c.dom.Document;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
public final class XmlTool {
private static final Map<String, Integer> ENTITIES = new HashMap<String, Integer>();
-
+ private static final MsoLogger LOGGER = MsoLogger.getMsoLogger (MsoLogger.Catalog.BPEL);
static {
ENTITIES.put("amp", new Integer(38));
ENTITIES.put("quot", new Integer(34));
*/
public static String removeNamespaces(Object xml) {
if (xml == null) {
+ LOGGER.debug("removeNamespaces input object is null , returning null");
return null;
}
try {
stream.close();
} catch (Exception e) {
- // Ignore
+ LOGGER.debug("Exception at readResourceFile close stream: " + e);
}
}
}
/*-\r
* ============LICENSE_START=======================================================\r
- * OPENECOMP - MSO\r
+ * ONAP - SO\r
* ================================================================================\r
* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.\r
* ================================================================================\r
\r
public class URNMapPlugin extends AbstractCockpitPlugin{\r
public static final String ID = "urnMap-plugin";\r
-\r
+ \r
+ @Override\r
public String getId() {\r
return ID;\r
}\r
\r
@Override\r
public Set<Class<?>> getResourceClasses() {\r
- Set<Class<?>> classes = new HashSet<Class<?>>();\r
+ Set<Class<?>> classes = new HashSet<>();\r
\r
classes.add(URNMapPluginRootResource.class);\r
\r
/*-\r
* ============LICENSE_START=======================================================\r
- * OPENECOMP - MSO\r
+ * ONAP - SO\r
* ================================================================================\r
* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.\r
* ================================================================================\r
import java.sql.Connection;\r
import java.sql.PreparedStatement;\r
import java.sql.ResultSet;\r
+import java.sql.SQLException;\r
import java.util.ArrayList;\r
import java.util.List;\r
import java.util.StringTokenizer;\r
public List<URNData> getUrnDataMap() \r
{ \r
List<URNData> list = new ArrayList();\r
- \r
+ PreparedStatement psData = null;\r
try {\r
\r
conn = getDBConnection();\r
- PreparedStatement psData = conn\r
+ psData = conn\r
.prepareStatement("select * from MSO_URN_MAPPING order by NAME_");\r
\r
ResultSet r = psData.executeQuery();\r
list.add(d); \r
}\r
\r
- psData.close();\r
- conn.close();\r
- \r
} catch (Exception e) \r
{\r
- \r
- e.printStackTrace();\r
+ msoLogger.debug("Exception in getUrnDataMap " + e); \r
+ } finally {\r
+ if(psData != null){\r
+ try {\r
+ psData.close();\r
+ conn.close();\r
+ } catch (SQLException e) {\r
+ msoLogger.debug("Exception while closing the PreparedStatement: " + e);\r
+ }\r
+ }\r
+ if(conn != null){\r
+ try {\r
+ conn.close();\r
+ } catch (SQLException e) {\r
+ msoLogger.debug("Exception while closing the connection: " + e);\r
+ }\r
+ }\r
}\r
\r
for(URNData d: list)\r
\r
} catch (Exception e) \r
{\r
- \r
- e.printStackTrace();\r
+ msoLogger.debug("Exception in DBConnection " + e);\r
}\r
\r
return conn;\r
nRow.setVer_("1"); \r
final String myKey = key_;\r
final String myValue = value_;\r
- \r
+ PreparedStatement psData = null;\r
+ \r
msoLogger.debug("----------- START ----------------------");\r
try {\r
\r
conn = getDBConnection();\r
- PreparedStatement psData = conn\r
+ psData = conn\r
.prepareStatement("Insert into MSO_URN_MAPPING values ('" + key_ + "', '" + value_ + "', '1')");\r
\r
- psData.executeUpdate();\r
- \r
- psData.close();\r
- conn.close();\r
- //} \r
+ psData.executeUpdate(); \r
\r
} catch (Exception e) \r
{\r
- \r
- e.printStackTrace();\r
+ msoLogger.debug("Exception in insertNewRow " + e);\r
+ }finally {\r
+ if(psData != null){\r
+ try {\r
+ psData.close();\r
+ conn.close();\r
+ } catch (SQLException e) {\r
+ msoLogger.debug("Exception while closing the PreparedStatement: " + e);\r
+ }\r
+ }\r
+ if(conn != null){\r
+ try {\r
+ conn.close();\r
+ } catch (SQLException e) {\r
+ msoLogger.debug("Exception while closing the connection: " + e);\r
+ }\r
+ }\r
}\r
// getQueryService().executeQuery("cockpit.urnMap.insertNewRow", nRow, URNData.class);\r
}\r
public void getPersistData(URNData d) { \r
\r
//getQueryService().executeQuery("cockpit.urnMap.persistURNData", d, URNData.class);\r
- \r
+ PreparedStatement psData = null;\r
try {\r
\r
conn = getDBConnection();\r
- PreparedStatement psData = conn\r
+ psData = conn\r
.prepareStatement("UPDATE MSO_URN_MAPPING set VALUE_ ='"+ d.getURNValue() + "' WHERE NAME_='" + d.getURNName() + "'");\r
\r
psData.executeUpdate();\r
- \r
- psData.close();\r
- conn.close();\r
+ \r
} catch (Exception e) \r
{\r
- \r
- e.printStackTrace();\r
+ msoLogger.debug("Exception in PersistData " + e);\r
+ }finally {\r
+ if(psData != null){\r
+ try {\r
+ psData.close();\r
+ conn.close();\r
+ } catch (SQLException e) {\r
+ msoLogger.debug("Exception while closing the PreparedStatement: " + e);\r
+ }\r
+ }\r
+ if(conn != null){\r
+ try {\r
+ conn.close();\r
+ } catch (SQLException e) {\r
+ msoLogger.debug("Exception while closing the connection: " + e);\r
+ }\r
+ }\r
}\r
\r
}\r