private void setupRankingList() {

    RestMessage rms = WebUtils.prepareRestTransmission("UsageStatistics/").sendGetRestMessage();
    if ((rms == null)
        || (rms.getListEntrySets().isEmpty())
        || (rms.getStatus() != RestStatusEnum.OK)) {
      logger.warn("received no UsageData_Ranking data ");
      return;
    }
    listHitOID = new ArrayList<BigDecimal>();

    for (RestEntrySet res : rms.getListEntrySets()) {
      Iterator<String> it = res.getKeyIterator();
      String key = "";
      while (it.hasNext()) {
        key = (String) it.next();

        if ("object_id".equals(key)) {
          listHitOID.add(new BigDecimal(res.getValue(key)));
          logger.info("Key" + key + ": " + res.getValue(key) + "");
        }
      }
    }
  }
  /**
   * @see de.dini.oanetzwerk.server.handler.AbstractKeyWordHandler#deleteKeyWord(java.lang.String[])
   */
  @Override
  protected String deleteKeyWord(String[] path) throws NotEnoughParametersException {

    if (path.length < 1)
      throw new NotEnoughParametersException(
          "This method needs at least 1 parameter: the internal object ID");

    BigDecimal object_id;

    try {

      object_id = new BigDecimal(path[0]);

    } catch (NumberFormatException ex) {

      logger.error(path[0] + " is NOT a number!", ex);

      this.rms = new RestMessage(RestKeyword.FullTextLinks);
      this.rms.setStatus(RestStatusEnum.WRONG_PARAMETER);
      this.rms.setStatusDescription(path[0] + " is NOT a number!");

      return RestXmlCodec.encodeRestMessage(this.rms);
    }

    DBAccessNG dbng = DBAccessNG.getInstance(super.getDataSource());
    MultipleStatementConnection stmtconn = null;

    this.rms = new RestMessage(RestKeyword.FullTextLinks);

    try {

      stmtconn = (MultipleStatementConnection) dbng.getMultipleStatementConnection();

      stmtconn.loadStatement(dbng.deleteFromDB().FullTextLinks(stmtconn.connection, object_id));
      this.result = stmtconn.execute();

      logWarnings();

      if (this.result.getUpdateCount() < 1) {

        stmtconn.rollback();
        throw new SQLException("FullTextLinks entries could not be deleted");

      } else {

        stmtconn.commit();
      }

      RestEntrySet res = new RestEntrySet();

      res.addEntry("oid", object_id.toPlainString());

      this.rms.addEntrySet(res);

    } catch (SQLException ex) {

      logger.error(
          "An error occured while processing Delete FullTextLinks: " + ex.getLocalizedMessage(),
          ex);
      this.rms.setStatus(RestStatusEnum.SQL_ERROR);
      this.rms.setStatusDescription(ex.getLocalizedMessage());

    } catch (WrongStatementException ex) {

      logger.error(
          "An error occured while processing Delete FullTextLinks: " + ex.getLocalizedMessage(),
          ex);
      this.rms.setStatus(RestStatusEnum.WRONG_STATEMENT);
      this.rms.setStatusDescription(ex.getLocalizedMessage());

    } finally {

      if (stmtconn != null) {

        try {

          stmtconn.close();
          stmtconn = null;

        } catch (SQLException ex) {

          ex.printStackTrace();
          logger.error(ex.getLocalizedMessage(), ex);
        }
      }

      this.result = null;
      dbng = null;
    }

    return RestXmlCodec.encodeRestMessage(this.rms);
  }
  /**
   * @see de.dini.oanetzwerk.server.handler.AbstractKeyWordHandler#putKeyWord(java.lang.String[],
   *     java.lang.String)
   */
  @Override
  protected String putKeyWord(String[] path, String data) {

    BigDecimal object_id = null;
    String mimeformat = null;
    String link = null;

    this.rms = RestXmlCodec.decodeRestMessage(data);
    RestEntrySet res = this.rms.getListEntrySets().get(0);

    Iterator<String> it = res.getKeyIterator();
    String key = "";

    try {

      object_id = new BigDecimal(path[0]);

      if (object_id.intValue() < 0) {

        logger.error(path[0] + " is NOT a valid number for this parameter!");

        this.rms = new RestMessage(RestKeyword.FullTextLinks);
        this.rms.setStatus(RestStatusEnum.WRONG_PARAMETER);
        this.rms.setStatusDescription(path[0] + " is NOT a valid number for this parameter!");

        return RestXmlCodec.encodeRestMessage(this.rms);
      }

    } catch (NumberFormatException ex) {

      logger.error(path[0] + " is NOT a number!", ex);

      this.rms = new RestMessage(RestKeyword.FullTextLinks);
      this.rms.setStatus(RestStatusEnum.WRONG_PARAMETER);
      this.rms.setStatusDescription(path[0] + " is NOT a number!");

      return RestXmlCodec.encodeRestMessage(this.rms);
    }

    try {

      while (it.hasNext()) {

        key = it.next();

        if (logger.isDebugEnabled()) logger.debug("key = " + key);

        //				if (key.equalsIgnoreCase ("object_id"))
        //					object_id = new BigDecimal (res.getValue (key));

        //				else if (key.equalsIgnoreCase ("mimeformat"))
        if (key.equalsIgnoreCase("mimeformat")) mimeformat = new String(res.getValue(key));
        else if (key.equalsIgnoreCase("link")) link = new String(res.getValue(key));
        else continue;
      }

    } catch (NumberFormatException ex) {

      logger.error(res.getValue(key) + " is NOT a number!", ex);

      this.rms = new RestMessage(RestKeyword.FullTextLinks);
      this.rms.setStatusDescription(res.getValue(key) + " is NOT a number!");

      return RestXmlCodec.encodeRestMessage(this.rms);
    }

    this.rms = new RestMessage(RestKeyword.FullTextLinks);

    DBAccessNG dbng = DBAccessNG.getInstance(super.getDataSource());
    ;
    MultipleStatementConnection stmtconn = null;
    res = new RestEntrySet();

    try {

      stmtconn = (MultipleStatementConnection) dbng.getMultipleStatementConnection();

      stmtconn.loadStatement(
          dbng.insertIntoDB().FullTextLinks(stmtconn.connection, object_id, mimeformat, link));

      this.result = stmtconn.execute();

      logWarnings();

      stmtconn.commit();
      stmtconn.loadStatement(dbng.selectFromDB().FullTextLinks(stmtconn.connection, object_id));

      this.result = stmtconn.execute();

      if (this.result.getResultSet().next()) {

        res.addEntry(
            "object_id", this.result.getResultSet().getBigDecimal("object_id").toPlainString());
        stmtconn.commit();

        this.rms.setStatus(RestStatusEnum.OK);

      } else {

        this.rms.setStatus(RestStatusEnum.NO_OBJECT_FOUND_ERROR);
        this.rms.setStatusDescription("No matching WorklflowDB Entry found");
      }

    } catch (SQLException ex) {

      logger.error(ex.getLocalizedMessage(), ex);
      this.rms.setStatus(RestStatusEnum.SQL_ERROR);
      this.rms.setStatusDescription(ex.getLocalizedMessage());

    } catch (WrongStatementException ex) {

      logger.error(ex.getLocalizedMessage(), ex);
      this.rms.setStatus(RestStatusEnum.WRONG_STATEMENT);
      this.rms.setStatusDescription(ex.getLocalizedMessage());

    } finally {

      if (stmtconn != null) {

        try {

          stmtconn.close();
          stmtconn = null;

        } catch (SQLException ex) {

          logger.error(ex.getLocalizedMessage(), ex);
        }
      }

      this.rms.addEntrySet(res);
      res = null;
      this.result = null;
      dbng = null;
    }

    return RestXmlCodec.encodeRestMessage(this.rms);
  }
  /**
   * @throws NotEnoughParametersException
   * @see de.dini.oanetzwerk.server.handler.AbstractKeyWordHandler#getKeyWord(java.lang.String[])
   */
  @Override
  protected String getKeyWord(String[] path) throws NotEnoughParametersException {

    if (path.length < 1)
      throw new NotEnoughParametersException(
          "This method needs at least 1 parameter: the internal object ID");

    BigDecimal object_id;

    try {

      object_id = new BigDecimal(path[0]);

      if (object_id.intValue() < 0) {

        logger.error(path[0] + " is NOT a valid number for this parameter!");

        this.rms = new RestMessage(RestKeyword.FullTextLinks);
        this.rms.setStatus(RestStatusEnum.WRONG_PARAMETER);
        this.rms.setStatusDescription(path[0] + " is NOT a valid number for this parameter!");

        return RestXmlCodec.encodeRestMessage(this.rms);
      }

    } catch (NumberFormatException ex) {

      logger.error(path[0] + " is NOT a number!", ex);

      this.rms = new RestMessage(RestKeyword.FullTextLinks);
      this.rms.setStatus(RestStatusEnum.WRONG_PARAMETER);
      this.rms.setStatusDescription(path[0] + " is NOT a number!");

      return RestXmlCodec.encodeRestMessage(this.rms);
    }

    DBAccessNG dbng = DBAccessNG.getInstance(super.getDataSource());
    SingleStatementConnection stmtconn = null;

    try {

      stmtconn = (SingleStatementConnection) dbng.getSingleStatementConnection();

      stmtconn.loadStatement(dbng.selectFromDB().FullTextLinks(stmtconn.connection, object_id));
      this.result = stmtconn.execute();

      logWarnings();

      RestEntrySet entrySet;
      boolean resultSetWasEmpty = true;
      while (this.result.getResultSet().next()) {

        if (logger.isDebugEnabled())
          logger.debug(
              "DB returned: \n\tobject_id = " + this.result.getResultSet().getBigDecimal(1));

        entrySet = new RestEntrySet();
        entrySet.addEntry(
            "object_id", this.result.getResultSet().getBigDecimal("object_id").toPlainString());
        entrySet.addEntry("mimeformat", this.result.getResultSet().getString("mimeformat"));
        entrySet.addEntry("link", this.result.getResultSet().getString("link"));
        this.rms.addEntrySet(entrySet);

        resultSetWasEmpty = false;
      }

      if (resultSetWasEmpty == true) {
        this.rms.setStatus(RestStatusEnum.NO_OBJECT_FOUND_ERROR);
        this.rms.setStatusDescription("No matching object found.");
      } else {
        this.rms.setStatus(RestStatusEnum.OK);
      }

    } catch (SQLException ex) {

      logger.error(
          "An error occured while processing Get WorklflowDB: " + ex.getLocalizedMessage(), ex);
      this.rms.setStatus(RestStatusEnum.SQL_ERROR);
      this.rms.setStatusDescription(ex.getLocalizedMessage());

    } catch (WrongStatementException ex) {

      logger.error(
          "An error occured while processing Get ObjectEntry: " + ex.getLocalizedMessage(), ex);
      this.rms.setStatus(RestStatusEnum.WRONG_STATEMENT);
      this.rms.setStatusDescription(ex.getLocalizedMessage());

    } finally {

      if (stmtconn != null) {

        try {

          stmtconn.close();
          stmtconn = null;

        } catch (SQLException ex) {

          ex.printStackTrace();
          logger.error(ex.getLocalizedMessage());
        }
      }

      this.result = null;
      dbng = null;
    }

    return RestXmlCodec.encodeRestMessage(this.rms);
  }