Examples of SbiAudit

it.eng.spagobi.monitoring.metadata.SbiAudit

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

   */
  public SbiAudit loadAuditByID(Integer id) throws EMFUserError {
    logger.debug("IN");
    Session aSession = null;
    Transaction tx = null;
    SbiAudit aSbiAudit = null;
    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      aSbiAudit = (SbiAudit) aSession.load(SbiAudit.class, id);
      aSbiAudit.getSbiObject();
      aSbiAudit.getDocumentLabel();
      aSbiAudit.getDocumentId();
      aSbiAudit.getDocumentName();
      aSbiAudit.getDocumentParameters();
      aSbiAudit.getDocumentState();
      aSbiAudit.getDocumentType();
      aSbiAudit.getSbiSubObject();
      aSbiAudit.getSubObjId();
      aSbiAudit.getSubObjName();
      aSbiAudit.getSubObjOwner();
      aSbiAudit.getSubObjIsPublic();
      aSbiAudit.getSbiEngine();
      aSbiAudit.getEngineClass();
      aSbiAudit.getEngineDriver();
      aSbiAudit.getEngineId();
      aSbiAudit.getEngineLabel();
      aSbiAudit.getEngineName();
      aSbiAudit.getEngineType();
      aSbiAudit.getEngineUrl();
      aSbiAudit.getExecutionModality();
      aSbiAudit.getRequestTime();
      aSbiAudit.getId();
      aSbiAudit.getUserName();
      aSbiAudit.getUserGroup();
      aSbiAudit.getExecutionStartTime();
      aSbiAudit.getExecutionEndTime();
      aSbiAudit.getExecutionTime();
      aSbiAudit.getExecutionState();
      aSbiAudit.getError();
      aSbiAudit.getErrorMessage();
      aSbiAudit.getErrorCode();
      tx.commit();
    } catch (HibernateException he) {
      logger.error(he);
      if (tx != null)
        tx.rollback();

View Full Code Here

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

    Session aSession = null;
    Transaction tx = null;
    try {
      aSession = getSession();
      tx = aSession.beginTransaction();      
      SbiAudit sbiAudit = (SbiAudit) aSession.load(SbiAudit.class, id);
      aSession.delete(sbiAudit);
      tx.commit();
    } catch (HibernateException he) {
      logger.error(he);
      if (tx != null)

View Full Code Here

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

   */
  public SbiAudit getLastExecution(Integer objId) throws EMFUserError {
    logger.debug("IN");
    Session aSession = null;
    Transaction tx = null;
    SbiAudit toReturn = new SbiAudit();
    if (objId == null) {
      logger.warn("The object id in input is null or empty.");
      return toReturn;
    }
    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      StringBuffer hql = new StringBuffer();
      hql.append(  "select ");
      hql.append(  "    max(a.executionStartTime)");
      hql.append(  "from ");
      hql.append(  "    SbiAudit a ");
      hql.append(  "where   ");
      hql.append(  "    a.sbiObject is not null and ");
      hql.append(  "    a.sbiObject.biobjId = ? ");
      Query hqlQuery = aSession.createQuery(hql.toString());
      hqlQuery.setInteger(0, objId.intValue());
      Timestamp date = (Timestamp) hqlQuery.uniqueResult();
      toReturn.setDocumentId(objId);
      toReturn.setExecutionStartTime(date);
      
      StringBuffer hql2 = new StringBuffer();
      hql2.append(  "select ");
      hql2.append(  "    a.userName, ");
      hql2.append(  "    a.documentParameters, ");
      hql2.append(  "    a.requestTime, ");
      hql2.append(  "    a.executionEndTime, ");
      hql2.append(  "    a.executionState ");
      hql2.append(  "from ");
      hql2.append(  "    SbiAudit a ");
      hql2.append(  "where   ");
      hql2.append(  "    a.sbiObject is not null and ");
      hql2.append(  "    a.sbiObject.biobjId = ? and ");  
      hql2.append(  "    a.executionStartTime = ? ");
      Query hqlQuery2 = aSession.createQuery(hql2.toString());
      hqlQuery2.setInteger(0, objId.intValue());
      hqlQuery2.setTimestamp(1, date);
      Object[] row = (Object[]) hqlQuery2.uniqueResult();


      toReturn.setUserName((String) row[0]);
      toReturn.setDocumentParameters((String) row[1]);
      toReturn.setRequestTime((Timestamp) row[2]);
      toReturn.setExecutionEndTime((Timestamp) row[3]);
      toReturn.setExecutionState((String) row[4]);      
      
    } catch (Exception ex) {
      logger.error(ex);
      if (tx != null)
        tx.rollback();

View Full Code Here

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

   * @return the sbi audit
   * 
   * @throws EMFUserError the EMF user error
   */
  public SbiAudit loadAudit(Integer id) throws EMFUserError {
    SbiAudit aSbiAudit = _auditDAO.loadAuditByID(id);
    return aSbiAudit;
  }

View Full Code Here

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

   * @return The Integer representing the execution id
   */
  public Integer insertAudit(BIObject obj, SubObject subObj, IEngUserProfile profile, String role, String modality) {
    logger.debug("IN");
    _auditDAO.setUserProfile(profile);
    SbiAudit audit = new SbiAudit();
    logger.debug("userID for audit"+ ((UserProfile)profile).getUserId().toString());
    audit.setUserName(((UserProfile)profile).getUserId().toString());


    audit.setUserGroup(role);
    audit.setDocumentId(obj.getId());
    audit.setDocumentLabel(obj.getLabel());
    audit.setDocumentName(obj.getName());
    audit.setDocumentType(obj.getBiObjectTypeCode());
    audit.setDocumentState(obj.getStateCode());


    String documentParameters = "";
    List parameters = obj.getBiObjectParameters();
    ParameterValuesEncoder parValuesEncoder = new ParameterValuesEncoder();
    if (parameters != null && parameters.size() > 0) {
      for (int i = 0; i < parameters.size(); i++) {
        BIObjectParameter parameter = (BIObjectParameter) parameters.get(i);
        documentParameters += parameter.getParameterUrlName() + "=";
        if (parameter.getParameterValues() != null) {
          String value = parValuesEncoder.encode(parameter);
          documentParameters += value;
        } else
          documentParameters += "NULL";
        if (i < parameters.size() - 1)
          documentParameters += "&";
      }
    }
    audit.setDocumentParameters(documentParameters);
    if (subObj != null) {
      audit.setSubObjId(subObj.getId());
      audit.setSubObjName(subObj.getName());
      audit.setSubObjOwner(subObj.getOwner());
      audit.setSubObjIsPublic(subObj.getIsPublic().booleanValue() ? new Short((short) 1) : new Short((short) 0));
    }
    Engine engine = obj.getEngine();
    audit.setEngineId(engine.getId());
    audit.setEngineLabel(engine.getLabel());
    audit.setEngineName(engine.getName());
    Domain engineType = null;
    try {
      engineType = DAOFactory.getDomainDAO().loadDomainById(engine.getEngineTypeId());
    } catch (EMFUserError e) {
      logger.error("Error retrieving document's engine information", e);
    }
    audit.setEngineType(engineType != null ? engineType.getValueCd() : null);
    if (engineType != null) {
      if ("EXT".equalsIgnoreCase(engineType.getValueCd())) {
        audit.setEngineUrl(engine.getUrl());
        audit.setEngineDriver(engine.getDriverName());
      } else {
        audit.setEngineClass(engine.getClassName());
      }
    }
    audit.setRequestTime(new Timestamp(System.currentTimeMillis()));
    audit.setExecutionModality(modality);
    audit.setExecutionState("EXECUTION_REQUESTED");


    try {
      insertAudit(audit);
    } catch (EMFUserError e) {
      logger.error("Error doing audit insertion", e);
      return null;
    }
    logger.debug("OUT");
    return audit.getId();
  }

View Full Code Here

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

    if (auditId == null) {
      logger.warn("Audit record id not specified, no updating is possible.");
      return;
    }


    SbiAudit audit=null;
    try {
      audit = loadAudit(auditId);
      if (audit==null) {
        logger.error("audit==null ");
        return;
      }
    } catch (EMFUserError e) {
      logger.error("Error loading audit record with id = [" + auditId.toString() + "]", e);
      logger.debug("OUT");
      return;
    }


    if (audit.getExecutionStartTime() != null && audit.getExecutionEndTime() != null) {
      logger.warn("Audit record with id = [" + auditId.toString() + "] has already a start time and an "
          + "end time. This record will not be modified.");
      logger.debug("OUT");
      return;
    }


    if (startTime != null) {
      Date executionStartTime = new Date(startTime.longValue());
      audit.setExecutionStartTime(executionStartTime);
    }
    if (endTime != null) {
      Date executionEndTime = new Date(endTime.longValue());
      audit.setExecutionEndTime(executionEndTime);
      Date executionStartTime = audit.getExecutionStartTime();
      if (executionStartTime != null) {
        // calculates exectuion time as a difference in ms
        long executionTimeLongMSec = endTime.longValue() - executionStartTime.getTime();
        // calculates exectuion time as a difference in s
        int executionTimeIntSec = Math.round(executionTimeLongMSec / 1000);
        Integer executionTime = new Integer(executionTimeIntSec);
        audit.setExecutionTime(executionTime);
      }
    }
    if (executionState != null && !executionState.trim().equals("")) {
      audit.setExecutionState(executionState);
    }
    if (errorMessage != null && !errorMessage.trim().equals("")) {
      audit.setErrorMessage(errorMessage);
      audit.setError(new Short((short) 1));
    } else {
      audit.setError(new Short((short) 0));
    }
    if (errorCode != null && !errorCode.trim().equals("")) {
      audit.setErrorCode(errorCode);
    }


    try {
      modifyAudit(audit);
    } catch (EMFUserError e) {

View Full Code Here

Examples of it.eng.spagobi.monitoring.metadata.SbiAudit

   * 
   * @return the last execution
   */
  public SbiAudit getLastExecution(Integer objId) {
    logger.debug("IN");
    SbiAudit toReturn = new SbiAudit();
    try {
      toReturn = _auditDAO.getLastExecution(objId);
    } catch (Exception e) {
      logger.error("Error while loading my last execution for document " + objId, e);
    } finally {

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.