Пример #1
0
  @Test
  public void testTopLevelJdbcDataSource() throws Exception {
    final CollectingDataSink dataSink = new CollectingDataSink();
    NSysMonConfigurer.addDataSink(NSysMon.get(), dataSink);

    final DataSource dataSource =
        new NSysMonDataSource(
            JdbcConnectionPool.create("jdbc:h2:mem:demo", "sa", ""), null, NSysMon.get());

    try (Connection conn = dataSource.getConnection()) {
      final Statement stmt = conn.createStatement();
      stmt.execute("create table A (oid number primary key)");
      stmt.execute("insert into A (oid) values (1)");
      final ResultSet rs = conn.createStatement().executeQuery("select * from A");
      while (rs.next()) {
        // Just ignore the result, goal is only to generat the sql
      }
    }

    assertEquals(1, dataSink.data.size());
    final AHierarchicalData root = dataSink.data.get(0).getRootNode();
    assertEquals("jdbc:connection from pool", root.getIdentifier());

    assertEquals(3, root.getChildren().size());

    assertEquals(
        "jdbc: create table A (oid number primary key)", root.getChildren().get(0).getIdentifier());
    assertEquals("jdbc: insert into A (oid) values (1)", root.getChildren().get(1).getIdentifier());

    assertEquals("jdbc: select * from A", root.getChildren().get(2).getIdentifier());
  }
Пример #2
0
  @Test
  public void testTopLevelJdbcDriverManager() throws Exception {
    final CollectingDataSink dataSink = new CollectingDataSink();
    NSysMonConfigurer.addDataSink(NSysMon.get(), dataSink);

    final Connection conn = DriverManager.getConnection("nsysmon::jdbc:h2:mem:demo", "sa", "");
    final Statement stmt = conn.createStatement();
    stmt.execute("create table A (oid number primary key)");
    stmt.execute("insert into A (oid) values (1)");
    final ResultSet rs = conn.createStatement().executeQuery("select * from A");
    while (rs.next()) {
      // Just ignore the result, goal is only to generat the sql
    }
    rs.close();
    stmt.close();
    conn.close();

    // meaurement of 'select' statement was discarded --> top-level collecting measurement
    assertEquals(2, dataSink.data.size());
    assertEquals(
        "jdbc: create table A (oid number primary key)",
        dataSink.data.get(0).getRootNode().getIdentifier());
    assertEquals(
        "jdbc: insert into A (oid) values (1)", dataSink.data.get(1).getRootNode().getIdentifier());
  }