public List<StatisticReportRecordVO> getStatisticReportRecord(
      String reportDefinitionId, String objectId, AccountUserVO accountUser) throws Exception {
    if (reportDefinitionId == null || objectId == null) {
      throw new IllegalArgumentException("Arguments are null!");
    }

    /*
     * Properties repDefProps = new Properties(); URL url =
     * SimpleStatistics.class.getClassLoader().getResource(REPORTDEFINITION_PROPERTIES_FILE); if
     * (url == null) { throw new FileNotFoundException(REPORTDEFINITION_PROPERTIES_FILE); }
     * repDefProps.load(new FileInputStream(new File(url.toURI())));
     */

    // String repDefId = repDefProps.getProperty(reportDefinitionType);

    // EntityManager em = emf.createEntityManager();
    // String repDefId =
    // ReportDefinitionStorage.getInstance().getReportDefinitionMap().get(reportDefinitionType);

    if (reportDefinitionId == null)
      throw new Exception("Reportdefinition does not exist: " + reportDefinitionId);

    StatisticReportParamsVO repParams = new StatisticReportParamsVO();
    repParams.setReportDefinitionId(reportDefinitionId);

    StatisticReportRecordParamVO param =
        new StatisticReportRecordParamVO(
            "object_id", new StatisticReportRecordStringParamValueVO(objectId));
    repParams.getParamList().add(param);

    String xmlParams = xmlTransforming.transformToStatisticReportParameters(repParams);

    ReportHandler repHandler;
    if (accountUser == null || accountUser.getHandle() == null)
      repHandler = ServiceLocator.getReportHandler();
    else repHandler = ServiceLocator.getReportHandler(accountUser.getHandle());

    String xmlReport = repHandler.retrieve(xmlParams);

    List<StatisticReportRecordVO> reportRecordList =
        xmlTransforming.transformToStatisticReportRecordList(xmlReport);

    return reportRecordList;
  }
 private List<StatisticReportDefinitionVO> retrieveReportDefinitionListFromFile()
     throws Exception {
   String repDefListXML =
       ResourceUtil.getResourceAsString(
           REPORTDEFINITION_FILE, SimpleStatistics.class.getClassLoader());
   String[] repDefs = repDefListXML.split("\n");
   List<StatisticReportDefinitionVO> repDefVOList = new ArrayList<StatisticReportDefinitionVO>();
   for (String repDefXml : repDefs) {
     repDefVOList.add(xmlTransforming.transformToStatisticReportDefinition(repDefXml));
   }
   return repDefVOList;
 }
  /** {@inheritDoc} */
  public void initReportDefinitionsInFramework() {

    try {

      logger.info("Initializing statistic aggregation definitions in framework database");
      AggregationDefinitionHandler adh =
          ServiceLocator.getAggregationDefinitionHandler(AdminHelper.getAdminUserHandle());
      String srwResponseXml = adh.retrieveAggregationDefinitions(new HashMap<String, String[]>());
      List<AggregationDefinitionVO> aggList =
          xmlTransforming.transformToStatisticAggregationDefinitionList(srwResponseXml);

      String aggregationTableName = null;

      for (AggregationDefinitionVO aggDef : aggList) {
        if (aggDef.getName().equals("pubman item statistics without version")) {
          logger.info(
              "Pubman statistic aggregation definition already exists with id "
                  + aggDef.getObjectId());

          aggregationTableName = aggDef.getAggregationTables().get(0).getName();
          logger.info("Pubman aggregated table name:" + aggregationTableName);
          break;
        }
      }

      // No aggregation found, create one
      if (aggregationTableName == null) {
        logger.info("No pubman aggregation definition found, creating one");

        String aggregationDefinitionXml =
            ResourceUtil.getResourceAsString(
                "pubman_object_stats_aggregation.xml", SimpleStatistics.class.getClassLoader());
        String createdAggDefXml = adh.create(aggregationDefinitionXml);
        AggregationDefinitionVO aggCreated =
            xmlTransforming.transformToStatisticAggregationDefinition(createdAggDefXml);
        logger.info("Pubman aggregation definition created with id " + aggCreated.getObjectId());
        aggregationTableName = aggCreated.getAggregationTables().get(0).getName();
        logger.info("Pubman aggregated table name:" + aggregationTableName);
      }

      logger.info("Initializing statistical report definitions in framework database");

      ReportDefinitionHandler repDefHandler =
          ServiceLocator.getReportDefinitionHandler(AdminHelper.getAdminUserHandle());
      // EntityManager em = emf.createEntityManager();
      String repDefFrameworkListXML =
          repDefHandler.retrieveReportDefinitions(new HashMap<String, String[]>());
      List<StatisticReportDefinitionVO> repDefFrameworkList =
          xmlTransforming.transformToStatisticReportDefinitionList(repDefFrameworkListXML);

      List<StatisticReportDefinitionVO> repDefFileList = retrieveReportDefinitionListFromFile();

      // Creating a Hash Map with ReportDefinitions from Framework and sql as key
      HashMap<String, StatisticReportDefinitionVO> repDefFrameworkMap =
          new HashMap<String, StatisticReportDefinitionVO>();

      for (StatisticReportDefinitionVO repDef : repDefFrameworkList) {
        repDefFrameworkMap.put(repDef.getSql(), repDef);
      }

      for (StatisticReportDefinitionVO repDefFile : repDefFileList) {
        String sql = repDefFile.getSql().replaceAll("pubman_object_stats", aggregationTableName);
        StatisticReportDefinitionVO repDefFW = repDefFrameworkMap.get(sql);
        String repDefObjectId;

        // Report Definition already existing
        if (repDefFW != null) {
          // set Property
          // Map<String, String> reportDefMap =
          // ReportDefinitionStorage.getInstance().getReportDefinitionMap();
          // reportDefMap.put(repDefFW.getSql(), repDefFW.getObjectId());
          repDefObjectId = repDefFW.getObjectId();
          logger.info(
              "Report Definition already  existing: "
                  + repDefFW.getObjectId()
                  + " --- "
                  + repDefFW.getSql());

        }
        // Report Definition does not exist yet
        else {
          // create and set
          String repDefFileXML =
              xmlTransforming
                  .transformToStatisticReportDefinition(repDefFile)
                  .replaceAll("pubman_object_stats", aggregationTableName);
          ;
          String repDefFWXMLNew = repDefHandler.create(repDefFileXML);
          StatisticReportDefinitionVO repDefFWNew =
              xmlTransforming.transformToStatisticReportDefinition(repDefFWXMLNew);
          // ReportDefinitionStorage.getInstance().getReportDefinitionMap().put(repDefFWNew.getSql(),
          // repDefFWNew.getObjectId());
          repDefObjectId = repDefFWNew.getObjectId();
          logger.info(
              "Created new report definition and added to Map: "
                  + repDefFWNew.getObjectId()
                  + " --- "
                  + repDefFWNew.getSql());
        }

        if (repDefFile.getName().equals("Item retrievals, all users")) {
          REPORTDEFINITION_NUMBER_OF_ITEM_RETRIEVALS_ALL_USERS = repDefObjectId;
        } else if (repDefFile.getName().equals("File downloads per Item, all users")) {
          REPORTDEFINITION_FILE_DOWNLOADS_PER_ITEM_ALL_USERS = repDefObjectId;
        } else if (repDefFile.getName().equals("File downloads, all users")) {
          REPORTDEFINITION_FILE_DOWNLOADS_PER_FILE_ALL_USERS = repDefObjectId;
        } else if (repDefFile.getName().equals("Item retrievals, anonymous users")) {
          REPORTDEFINITION_NUMBER_OF_ITEM_RETRIEVALS_ANONYMOUS = repDefObjectId;
        } else if (repDefFile.getName().equals("File downloads per Item, anonymous users")) {
          REPORTDEFINITION_FILE_DOWNLOADS_PER_ITEM_ANONYMOUS = repDefObjectId;
        } else if (repDefFile.getName().equals("File downloads, anonymous users")) {
          REPORTDEFINITION_FILE_DOWNLOADS_PER_FILE_ANONYMOUS = repDefObjectId;
        }
      }

      /*
       * logger.info( ReportDefinitionStorage.getInstance().getReportDefinitionMap().size()
       * +" Statistic report definitions are initialized! ");
       */

    } catch (Exception e) {
      logger.error(
          "Statistic report definitions could not be initialized! Statistic system may not work properly. ",
          e);
    }
  }