How to use

generateSample

method

in

kg.apc.jmeter.dbmon.DbMonSampleGenerator

public void generateSamples(DbMonSampleGenerator collector) {
  Statement stmt = null;
  ResultSet rs = null;
  try {
    stmt = connection.createStatement();
    rs = stmt.executeQuery(sql);
    if (rs.next()) {
      final double val = rs.getDouble(1);
      if (sampleDeltaValue) {
        if (!Double.isNaN(oldValue)) {
          collector.generateSample(val - oldValue, metricName);
        }
        oldValue = val;
      } else {
        collector.generateSample(val, metricName);
      }
    }
  } catch (SQLException ex) {
    log.error("Error executing query: " + sql, ex);
  } finally {
    close(rs);
    close(stmt);
  }
}

public void generateSamples(DbMonSampleGenerator collector) {
  Statement stmt = null;
  ResultSet rs = null;
  try {
    stmt = connection.createStatement();
    rs = stmt.executeQuery(sql);
    if (rs.next()) {
      final double val = rs.getDouble(1);
      if (sampleDeltaValue) {
        if (!Double.isNaN(oldValue)) {
          collector.generateSample(val - oldValue, metricName);
        }
        oldValue = val;
      } else {
        collector.generateSample(val, metricName);
      }
    }
  } catch (SQLException ex) {
    log.error("Error executing query: " + sql, ex);
  } finally {
    close(rs);
    close(stmt);
  }
}