protected void remove(String clustername, Address addr) { final String addressAsString = addressAsString(addr); try { delete(clustername, addressAsString); } catch (SQLException e) { log.error("Error", e); } }
protected boolean contains(String cluster_name, Address addr) { final String addressAsString = addressAsString(addr); try(Connection conn=getConnection()) { try (PreparedStatement ps=conn.prepareStatement(contains_sql)) { ps.setString(1, cluster_name); ps.setString(2, addressAsString); try (ResultSet resultSet=ps.executeQuery()) { if(!resultSet.next()) return false; int count=resultSet.getInt("RECORDCOUNT"); return count > 0; } } } catch(SQLException e) { log.error(Util.getMessage("ErrorReadingTable"), e); } return false; }
protected synchronized void writeToDB(PingData data, String clustername, boolean overwrite) { final String ownAddress = addressAsString(data.getAddress()); final Connection connection = getConnection(); if (connection != null) { try { if(overwrite) delete(connection, clustername, ownAddress); else { if(contains(clustername, data.getAddress())) return; } insert(connection, data, clustername, ownAddress); } catch (SQLException e) { log.error(Util.getMessage("ErrorUpdatingJDBCPINGTable"), e); } finally { closeConnection(connection); } } else { log.error(Util.getMessage("FailedToStorePingDataInDatabase")); } }
protected void remove(String clustername, Address addr) { final String addressAsString = addressAsString(addr); try { delete(clustername, addressAsString); } catch (SQLException e) { log.error("Error", e); } }
protected boolean contains(String cluster_name, Address addr) { final String addressAsString = addressAsString(addr); try(Connection conn=getConnection()) { try (PreparedStatement ps=conn.prepareStatement(contains_sql)) { ps.setString(1, cluster_name); ps.setString(2, addressAsString); try (ResultSet resultSet=ps.executeQuery()) { if(!resultSet.next()) return false; int count=resultSet.getInt("RECORDCOUNT"); return count > 0; } } } catch(SQLException e) { log.error(Util.getMessage("ErrorReadingTable"), e); } return false; }
protected synchronized void writeToDB(PingData data, String clustername, boolean overwrite) { final String ownAddress = addressAsString(data.getAddress()); final Connection connection = getConnection(); if (connection != null) { try { if(overwrite) delete(connection, clustername, ownAddress); else { if(contains(clustername, data.getAddress())) return; } insert(connection, data, clustername, ownAddress); } catch (SQLException e) { log.error(Util.getMessage("ErrorUpdatingJDBCPINGTable"), e); } finally { closeConnection(connection); } } else { log.error(Util.getMessage("FailedToStorePingDataInDatabase")); } }