Examples with JdbcSqlStat com.alibaba.druid.stat.JdbcSqlStat used on opensource projects

Example 36 with JdbcSqlStat

use of com.alibaba.druid.stat.JdbcSqlStat in project druid by alibaba.

the class StatFilterOpenClobCountTest2 method test_stat_1.

public void test_stat_1() throws Exception {
    Connection conn = dataSource.getConnection();
    String sql = "select 'x'";
    PreparedStatement stmt = conn.prepareStatement("select 'x'");
    JdbcSqlStat sqlStat = dataSource.getDataSourceStat().getSqlStat(sql);
    Assert.assertEquals(0, sqlStat.getClobOpenCount());
    ResultSet rs = stmt.executeQuery();
    rs.next();
    rs.getObject("1");
    rs.getObject("2");
    rs.getObject("3");
    rs.close();
    stmt.close();
    conn.close();
    Assert.assertEquals(3, sqlStat.getClobOpenCount());
    sqlStat.reset();
    Assert.assertEquals(0, sqlStat.getClobOpenCount());
}

Example 37 with JdbcSqlStat

use of com.alibaba.druid.stat.JdbcSqlStat in project druid by alibaba.

the class StatFilterOpenInputStreamCountTest method test_stat_1.

public void test_stat_1() throws Exception {
    Connection conn = dataSource.getConnection();
    String sql = "select 'x'";
    PreparedStatement stmt = conn.prepareStatement("select 'x'");
    JdbcSqlStat sqlStat = dataSource.getDataSourceStat().getSqlStat(sql);
    Assert.assertEquals(0, sqlStat.getInputStreamOpenCount());
    ResultSet rs = stmt.executeQuery();
    rs.next();
    rs.getBinaryStream("1");
    rs.getBinaryStream("2");
    rs.getBinaryStream("3");
    rs.close();
    stmt.close();
    conn.close();
    Assert.assertEquals(3, sqlStat.getInputStreamOpenCount());
    sqlStat.reset();
    Assert.assertEquals(0, sqlStat.getInputStreamOpenCount());
}

Example 38 with JdbcSqlStat

use of com.alibaba.druid.stat.JdbcSqlStat in project druid by alibaba.

the class StatFilterOpenInputStreamCountTest2 method test_stat_1.

public void test_stat_1() throws Exception {
    Connection conn = dataSource.getConnection();
    String sql = "select 'x'";
    PreparedStatement stmt = conn.prepareStatement("select 'x'");
    JdbcSqlStat sqlStat = dataSource.getDataSourceStat().getSqlStat(sql);
    Assert.assertEquals(0, sqlStat.getInputStreamOpenCount());
    ResultSet rs = stmt.executeQuery();
    rs.next();
    rs.getAsciiStream("1");
    rs.getAsciiStream("2");
    rs.getAsciiStream("3");
    rs.close();
    stmt.close();
    conn.close();
    Assert.assertEquals(3, sqlStat.getInputStreamOpenCount());
    sqlStat.reset();
    Assert.assertEquals(0, sqlStat.getInputStreamOpenCount());
}

Example 39 with JdbcSqlStat

use of com.alibaba.druid.stat.JdbcSqlStat in project druid by alibaba.

the class StatFilterOpenReaderCountTest method test_stat_1.

public void test_stat_1() throws Exception {
    Connection conn = dataSource.getConnection();
    String sql = "select 'x'";
    PreparedStatement stmt = conn.prepareStatement("select 'x'");
    JdbcSqlStat sqlStat = dataSource.getDataSourceStat().getSqlStat(sql);
    Assert.assertEquals(0, sqlStat.getReaderOpenCount());
    ResultSet rs = stmt.executeQuery();
    rs.next();
    rs.getCharacterStream("1");
    rs.getCharacterStream("2");
    rs.getCharacterStream("3");
    rs.close();
    stmt.close();
    conn.close();
    Assert.assertEquals(3, sqlStat.getReaderOpenCount());
    sqlStat.reset();
    Assert.assertEquals(0, sqlStat.getReaderOpenCount());
}

Example 40 with JdbcSqlStat

use of com.alibaba.druid.stat.JdbcSqlStat in project druid by alibaba.

the class StatFilterOpenReaderCountTest method test_stat.

public void test_stat() throws Exception {
    Connection conn = dataSource.getConnection();
    String sql = "select 'x'";
    PreparedStatement stmt = conn.prepareStatement("select 'x'");
    JdbcSqlStat sqlStat = dataSource.getDataSourceStat().getSqlStat(sql);
    Assert.assertEquals(0, sqlStat.getReaderOpenCount());
    ResultSet rs = stmt.executeQuery();
    rs.next();
    rs.getCharacterStream(1);
    rs.getCharacterStream(2);
    rs.close();
    stmt.close();
    conn.close();
    Assert.assertEquals(2, sqlStat.getReaderOpenCount());
    sqlStat.reset();
    Assert.assertEquals(0, sqlStat.getReaderOpenCount());
}