Example #1
0
  private static String getOrCreateSession(int connectorId) {
    String sessionId = getConnectorSession(connectorId);
    if (null != sessionId) {
      return sessionId; // we're using the key to the session table rec as the session ID
    }

    String sql =
        "insert into "
            + TABLE_SESSION
            + "("
            + "SESSION_PKEY,"
            + COL_DATE_CREATE
            + ",CONNECTOR_KEY,"
            + COL_DATE_EXPIRE
            + ") values (?,?,?,?)";

    sessionId = Util.getGuid();
    Timestamp now = new Timestamp(Gmt.getGmtDate().getTime());
    ResourceFactory rf = Context.rf.get();
    Sql.sqlExe(
        sql,
        new Object[] {sessionId, now, connectorId, getExpireDt(now)},
        new int[] {Types.VARCHAR, Types.TIMESTAMP, Types.INTEGER, Types.TIMESTAMP},
        rf);

    System.out.println(new Date() + ": Created new connector session --  " + sessionId);
    return sessionId; // we're using the key to the session table rec as the session ID
  }
Example #2
0
  @Override
  public void logWs(LogLevel severity, WsRequest req, String logText) {
    if (!isInit) {
      init();
    }

    String sql =
        "insert into "
            + TABLE_LOG_WS
            + "( date, severity, machine_name, entity_code, action, description, request, millis ) "
            + "values ( getutcdate(),?,?,?,?,?,?,? )";

    long millis = System.currentTimeMillis() - req.getStartTime();
    Sql.sqlExe(
        sql,
        new Object[] {
          severity.toString(),
          Util.getHostName(),
          req.getCompId(),
          req.getVerb(),
          Str.truncate(logText, 2048),
          null == req.getXmlRequest() ? "" : Str.truncate(req.getXmlRequest(), 4096),
          millis
        },
        new int[] {
          Types.VARCHAR,
          Types.VARCHAR,
          Types.VARCHAR,
          Types.VARCHAR,
          Types.VARCHAR,
          Types.VARCHAR,
          Types.INTEGER
        },
        Context.rf.get().getLogRF());
  }
Example #3
0
  @Override
  public void log(LogEntry le) {
    if (!isInit) {
      init();
    }

    ResourceFactory rf = Context.rf.get();
    if (le.level.ordinal() < rf.getLoggingLevel().ordinal()) {
      return;
    }

    prepLogEntry(le, rf);
    final LogContext lc = Log.logContext.get();

    if (alreadyCalled.get() == 0) {
      try {
        alreadyCalled.set(1);
        String sql =
            "INSERT INTO "
                + TABLE_LOG
                + "("
                + COL_SYSTEM
                + ","
                + COL_ENTITY_CODE
                + ","
                + COL_DATE
                + ","
                + COL_SEVERITY
                + ","
                + COL_MACHINE_NAME
                + ","
                + COL_THREAD_ID
                + ","
                + COL_KEY
                + ","
                + COL_DESC
                + ")"
                + "VALUES(?,?,getutcdate(),?,?,?,?,?)";

        Sql.sqlExe(
            sql,
            new Object[] {
              le.serviceName,
              le.compId,
              le.level.toString(),
              Util.getHostName(),
              le.threadId,
              le.transKey == -1 ? null : le.transKey,
              le.desc.length() > MAX_LOG_DESC ? le.desc.substring(0, MAX_LOG_DESC) : le.desc
            },
            new int[] {
              Types.VARCHAR,
              Types.VARCHAR,
              Types.VARCHAR,
              Types.VARCHAR,
              Types.VARCHAR,
              Types.INTEGER,
              Types.VARCHAR
            },
            rf);
      } catch (Throwable t) {
        handleNonLoggableError(
            LogLevel.ERROR,
            le.serviceName,
            getClass(),
            "log",
            "Log to database was unsuccessful. " + buildNonLoggableDesc(le));
      } finally {
        alreadyCalled.set(0);
      }
    } else {
      handleNonLoggableError(
          LogLevel.ERROR,
          le.serviceName,
          getClass(),
          "logImageProcessing",
          "Recursive logging call cannot log. Log data: " + buildNonLoggableDesc(le));
    }
  }