logger.error(" retrieveFromDB(), DB query failed. query= " + query + "\n ERROR " + ee);
if (logger.isErrorEnabled()) { logger.error(" retrieveFromDB(), DB query failed. query= " + query + "\n ERROR " + ee); }
  protected String getPackagedPOLNSN(String type_id) {    String query = (String) fileParameters_.get("packagedPOLQuery");    String consumer_id = type_id.substring(type_id.indexOf("/") + 1);    Vector result = null;    String nomen = null;    if (query != null) {      int i = query.indexOf(":nsn");      String q1 = query.substring(0, i) + "'" + consumer_id + "'";      String q2 = query.substring(i + 4, query.length());      query = q1 + q2;      try {        result = executeQuery(query);        if (result.isEmpty()) {          // this is fine - means the type_id is not a Packaged POL MEI          return null;        } else {          Object row[] = (Object[]) result.firstElement();          nomen = (String) row[0];        } // if      } catch (Exception ee) {        logger.error(" retrieveFromDB(), DB query failed. query= " + query + "\n ERROR " + ee);        return null;      } // try    } // if    return nomen;  } // getPackagedPOLNSN