@Override public void init(Properties props) throws ConfigurationException { dbSvc = getDbLibService(); if(dbSvc == null) { LOG.error("SvcLogic cannot acquire DBLIB_SERVICE"); return; } try { dbSvc.getData("select 1 from DUAL", new ArrayList<String>(), null); LOG.debug("SQL test was successful"); } catch (SQLException e) { LOG.error("Failed SQL test", e); } }
@Override public String retrieveConfigFileName(String xmlID) { String fileContent = ""; String queryString = "select " + Constants.FILE_CONTENT_TABLE_FIELD_NAME + " " + "from " + Constants.CONFIGFILES_TABLE_NAME + " " + "where " + Constants.FILE_NAME_TABLE_FIELD_NAME + " = ?"; ArrayList<String> argList = new ArrayList<>(); argList.add(xmlID); try { final CachedRowSet data = dbLibService.getData(queryString, argList, schema); if (data.first()) { fileContent = data.getString(Constants.FILE_CONTENT_TABLE_FIELD_NAME); } } catch (Exception e) { logger.error("Error Accessing Database " + e); throw new DataAccessException(e); } return fileContent; }
private static int getLastSequenceNumber(String tableName, String requestId) throws SQLException { String sql = "SELECT sequence_number FROM " + tableName + " WHERE request_id = '" + requestId + "' ORDER BY sequence_number DESC"; CachedRowSet rs = null; try { rs = dbLibService.getData(sql, null, null); if (rs.next()) { return rs.getInt("sequence_number"); } } finally { if (rs != null) { try { rs.close(); } catch (Exception e) { LOG.warn("Failed to close CachedRowSet", e); } } } return 0; } }
public QueryStatus query(String resource, boolean localOnly, String select, String key, String prefix, String orderBy, SvcLogicContext ctx) throws SvcLogicException { DbLibService dblibSvc = getDbLibService(); if (dblibSvc == null) { return (QueryStatus.FAILURE); } String sqlQuery = resolveCtxVars(key, ctx); try { CachedRowSet results = dblibSvc.getData(sqlQuery, null, null); QueryStatus retval = QueryStatus.SUCCESS; if (!results.next()) { retval = QueryStatus.NOT_FOUND; LOG.debug("No data found"); } else { saveCachedRowSetToCtx(results, ctx, prefix, dblibSvc); } return (retval); } catch (Exception e) { LOG.error("Caught SQL exception", e); return (QueryStatus.FAILURE); } }
@Override public Integer getInProgressRequestsCount() throws APPCException { final String inProgressRequestCountQuery = "SELECT COUNT(*) as VALUE FROM " + TransactionConstants.TRANSACTIONS + WHERE + STATE.getColumnName() + " IN (?,?) "; ArrayList<String> checkInProgressParams = new ArrayList<>(); checkInProgressParams.add(RequestStatus.RECEIVED.name()); checkInProgressParams.add(RequestStatus.ACCEPTED.name()); try(CachedRowSet rowSet=dbLibService.getData(inProgressRequestCountQuery,checkInProgressParams,SCHEMA)){ if (rowSet.first()) { int count = rowSet.getInt("VALUE"); logger.info("In progress request count fetched from database successfully."); return count; } } catch (SQLException e) { logger.error("Error checking in progress request count in the transaction table", e); throw new APPCException(ERROR_ACCESSING_DATABASE, e); } logger.error("Error checking in progress request count in the transaction table"); throw new APPCException(ERROR_ACCESSING_DATABASE); }
CachedRowSet resultSet = dbLibService.getData(queryString.toString(), argList, SCHEMA); while (resultSet.next()) { String name = resultSet.getString(TRANSACTION_ATTRIBUTES.STATE.getColumnName());
public static String getServiceInstanceId(String requestId) throws SQLException { init(); String sql = "SELECT service_instance_id FROM OUTGOING_MESSAGE WHERE request_id = '" + requestId + "' ORDER BY sequence_number DESC"; CachedRowSet rs = null; try { rs = dbLibService.getData(sql, null, null); if (rs.next()) { return rs.getString("service_instance_id"); } } finally { if (rs != null) { try { rs.close(); } catch (Exception e) { LOG.warn("Failed to close CachedRowSet", e); } } } return null; }
@Override public QueryStatus exists(String resource, String key, String prefix, SvcLogicContext ctx) throws SvcLogicException { DbLibService dblibSvc = getDbLibService(); if (dblibSvc == null) { return (QueryStatus.FAILURE); } String theStmt = resolveCtxVars(key, ctx); try { CachedRowSet results = dblibSvc.getData(theStmt, null, null); if (!results.next()) { return (QueryStatus.NOT_FOUND); } int numRows = results.getInt(1); if (numRows > 0) { return (QueryStatus.SUCCESS); } else { return (QueryStatus.NOT_FOUND); } } catch (Exception e) { LOG.error("Caught SQL exception", e); return (QueryStatus.FAILURE); } }
final CachedRowSet data = dbLibService.getData(query.toString(), argList, "sdnctl"); if (data.first()) { vnfModel = data.getString("ARTIFACT_CONTENT");
logger.debug(duplicateRequestCheckQuery.toString()); try (CachedRowSet rowSet = dbLibService.getData(duplicateRequestCheckQuery.toString(), duplicateCheckParams, SCHEMA)) { if (rowSet.first()) {
private Integer getNextInternalVersion(String artifactName) throws APPCException { if (logger.isDebugEnabled()) { logger.debug("Entering getNextInternalVersion with artifactName:" + artifactName); } Integer version = 1; try { initializeDBLibService(); ArrayList<String> arguments = new ArrayList<>(); arguments.add(artifactName); CachedRowSet rowSet = dbLibService.getData(SELECT_MAX_INT_VERSION, arguments, SCHEMA); if (rowSet.first()) { version = rowSet.getInt(Constants.SDC_ARTIFACTS_FIELDS.INTERNAL_VERSION .toString()); } }catch (SQLException e) { logger.error("Error getting internal version for artifact name " + artifactName , e); throw new APPCException(e); } if (logger.isDebugEnabled()) { logger.debug("Exiting getNextInternalVersion with retrieved version:" + version.toString()); } return version; }
@Override public boolean retrieveConnectionDetails(String vnfType, ConnectionDetails connectionDetails) { boolean recordFound = false; String queryString = "select " + Constants.USER_NAME_TABLE_FIELD_NAME + "," + Constants.PASSWORD_TABLE_FIELD_NAME + "," + Constants.PORT_NUMBER_TABLE_FIELD_NAME + " " + "from " + Constants.DEVICE_AUTHENTICATION_TABLE_NAME + " " + "where " + Constants.VNF_TYPE_TABLE_FIELD_NAME + " = ?"; ArrayList<String> argList = new ArrayList<>(); argList.add(vnfType); try { final CachedRowSet data = dbLibService.getData(queryString, argList, schema); if (data.first()) { connectionDetails.setUsername(data.getString(Constants.USER_NAME_TABLE_FIELD_NAME)); connectionDetails.setPassword(data.getString(Constants.PASSWORD_TABLE_FIELD_NAME)); connectionDetails.setPort(data.getInt(Constants.PORT_NUMBER_TABLE_FIELD_NAME)); recordFound = true; } } catch (SQLException e) { logger.error("Error Accessing Database " + e); throw new DataAccessException(e); } return recordFound; }
arguments.add(vnfType); arguments.add(fileCategory); CachedRowSet rowSet = dbLibService.getData(SELECT_QUERY_SDC_REFERENCE, arguments, SCHEMA); if (rowSet.first()) { reference = new SDCReference();
try (CachedRowSet rowSet = dbLibService.getData(IN_PROGRESS_REQUESTS_QUERY, inProgressQueryParams, SCHEMA)) { List<TransactionRecord> inProgressRecords = new ArrayList<>(); TransactionRecord transaction;
arguments.add(resourceVersion); arguments.add(artifactType); CachedRowSet rowSet = dbLibService.getData(SELECT_QUERY, arguments, SCHEMA); if (rowSet.first()) { artifact = new SDCArtifact();