protected void processConnectors() { for (DbMonSampler sampler: dbMonSamplers) { sampler.generateSamples(this); } }
private Connection findConnectionSamePoolName(String connectionPoolName) { Connection conn = null; boolean continueFind = true; Iterator<DbMonSampler> it = dbMonSamplers.iterator(); while (it.hasNext() && continueFind) { DbMonSampler dbMonSampler = it.next(); String connectionPoolNameTmp = dbMonSampler.getPoolName(); if (connectionPoolNameTmp != null && connectionPoolNameTmp.equals(connectionPoolName)) { conn = dbMonSampler.getConnection(); continueFind = false; } } return conn; }
private void initiateConnector(String connectionPoolName, String name, boolean delta, String sql) throws SQLException { Connection conn = findConnectionSamePoolName(connectionPoolName); if (conn == null) { log.debug("create new connection"); conn = DataSourceElement.getConnection(connectionPoolName); } else { log.debug("use same connection"); } dbMonSamplers.add(new DbMonSampler(conn, connectionPoolName, name, delta, sql)); }
private void shutdownConnectors() { log.debug("Start shutdownConnectors"); Iterator<DbMonSampler> it = dbMonSamplers.iterator(); while (it.hasNext()) { DbMonSampler dbMonSampler = it.next(); Connection connJdbc = dbMonSampler.getConnection(); if (connJdbc != null) { try { connJdbc.close(); log.debug("connJdbc is closed"); } catch (Exception ex) { log.debug("Can't close jdbc connector, but continue"); } } else { log.debug("connJdbc == null, don't try to close connection"); } } dbMonSamplers.clear(); log.debug("End shutdownConnectors"); }
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); } }
private void initiateConnector(String connectionPoolName, String name, boolean delta, String sql) throws SQLException { Connection conn = findConnectionSamePoolName(connectionPoolName); if (conn == null) { log.debug("create new connection"); conn = DataSourceElement.getConnection(connectionPoolName); } else { log.debug("use same connection"); } dbMonSamplers.add(new DbMonSampler(conn, connectionPoolName, name, delta, sql)); }
private void shutdownConnectors() { log.debug("Start shutdownConnectors"); Iterator<DbMonSampler> it = dbMonSamplers.iterator(); while (it.hasNext()) { DbMonSampler dbMonSampler = it.next(); Connection connJdbc = dbMonSampler.getConnection(); if (connJdbc != null) { try { connJdbc.close(); log.debug("connJdbc is closed"); } catch (Exception ex) { log.debug("Can't close jdbc connector, but continue"); } } else { log.debug("connJdbc == null, don't try to close connection"); } } dbMonSamplers.clear(); log.debug("End shutdownConnectors"); }
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); } }
private Connection findConnectionSamePoolName(String connectionPoolName) { Connection conn = null; boolean continueFind = true; Iterator<DbMonSampler> it = dbMonSamplers.iterator(); while (it.hasNext() && continueFind) { DbMonSampler dbMonSampler = it.next(); String connectionPoolNameTmp = dbMonSampler.getPoolName(); if (connectionPoolNameTmp != null && connectionPoolNameTmp.equals(connectionPoolName)) { conn = dbMonSampler.getConnection(); continueFind = false; } } return conn; }
protected void processConnectors() { for (DbMonSampler sampler: dbMonSamplers) { sampler.generateSamples(this); } }