Exemplo n.º 1
0
  /** {@inheritDoc} */
  @Override
  public int executeUpdate() throws SQLException {
    if ((this.sqlStream == null) && !this.debug) {
      return this.statement.executeUpdate();
    }

    if (this.statementNo == -1) {
      this.statementNo = PreparedStatementProxy.no.incrementAndGet();
    }

    this.executionNo++;

    PreparedStatementProxy.LOG.debug(
        "{0}:{1} executeUpdate(){2}",
        this.statementNo,
        this.executionNo,
        PreparedStatementProxy.LOG.lazyBoxed(this.sql, this.parameters));
    if (this.sqlStream != null) {
      this.sqlStream.println(
          MessageFormat.format(
              "{0}:{1} executeUpdate(){2}",
              this.statementNo,
              this.executionNo,
              PreparedStatementProxy.LOG.lazyBoxed(this.sql, this.parameters)));
    }

    final long start = System.currentTimeMillis();
    try {
      return this.statement.executeUpdate();
    } finally {
      final long time = System.currentTimeMillis() - start;
      if (time > this.slowSqlThreshold) {
        if (this.sqlStream != null) {
          this.sqlStream.println(
              MessageFormat.format(
                  "{0}:{1} {2} msecs, executeUpdate()", this.statementNo, this.executionNo, time));

          new OperationTookLongTimeWarning().printStackTrace(this.sqlStream);
        }

        PreparedStatementProxy.LOG.warn(
            new OperationTookLongTimeWarning(),
            "{0}:{1} {2} msecs, executeUpdate()",
            this.statementNo,
            this.executionNo,
            time);
      } else {
        if (this.sqlStream != null) {
          this.sqlStream.println(
              MessageFormat.format(
                  "{0}:{1} {2} msecs, executeUpdate()", this.statementNo, this.executionNo, time));
        }

        PreparedStatementProxy.LOG.debug(
            "{0}:{1} {2} msecs, executeUpdate()", this.statementNo, this.executionNo, time);
      }
    }
  }
Exemplo n.º 2
0
  /** {@inheritDoc} */
  @Override
  public ResultSet executeQuery() throws SQLException {
    if ((this.sqlStream == null) && !this.debug) {
      return this.statement.executeQuery();
    }

    if (this.statementNo == -1) {
      this.statementNo = PreparedStatementProxy.no.incrementAndGet();
    }

    this.executionNo++;

    PreparedStatementProxy.LOG.debug(
        "{0}:{1} executeQuery(){2}",
        this.statementNo,
        this.executionNo,
        PreparedStatementProxy.LOG.lazyBoxed(this.sql, this.parameters));

    final long start = System.currentTimeMillis();
    try {
      return this.statement.executeQuery();
    } finally {
      final long time = System.currentTimeMillis() - start;

      if (time > this.slowSqlThreshold) {
        PreparedStatementProxy.LOG.warn(
            new OperationTookLongTimeWarning(),
            "{0}:{1} {2} msecs, executeQuery()",
            this.statementNo,
            this.executionNo,
            time);
      } else {
        PreparedStatementProxy.LOG.trace(
            "{0}:{1} {2} msecs, executeQuery()", this.statementNo, this.executionNo, time);
      }
    }
  }