public void saveRegistrationRedirect(String externalIdToRedirect, String nodeIdToRedirectTo) { int count = sqlTemplate.update(getSql("updateRegistrationRedirectUrlSql"), new Object[] { nodeIdToRedirectTo, externalIdToRedirect }, new int[] { Types.VARCHAR, Types.VARCHAR }); if (count == 0) { sqlTemplate.update(getSql("insertRegistrationRedirectUrlSql"), new Object[] { nodeIdToRedirectTo, externalIdToRedirect }, new int[] { Types.VARCHAR, Types.VARCHAR }); } }
public void purgeAllIncomingEventsForNode(String nodeId) { int count = sqlTemplate.update(getSql("deleteIncomingBatchByNodeSql"), new Object[] { nodeId }); log.info("Purged all {} incoming batch for node {}", count, nodeId); }
protected boolean unlock(String action, String serverId) { String lastLockingServerId = serverId.equals(Lock.STOPPED) ? null : serverId; return sqlTemplate.update(getSql("releaseLockSql"), new Object[] { new Date(), lastLockingServerId, action, serverId }) > 0; }
public boolean deleteIdentity() { boolean successful = false; try { sqlTemplate.update(getSql("deleteNodeIdentitySql")); successful = true; } catch (SqlException ex) { log.debug(ex.getMessage()); } finally { cachedNodeIdentity = null; } return successful; }
protected void install(String sql, String objectName) { sql = replaceTokens(sql, objectName); platform.getSqlTemplate().update(sql); log.info("Just installed {}", objectName); }
protected boolean lock(String action, Date timeToBreakLock, Date timeLockAquired, String serverId) { try { return sqlTemplate.update(getSql("aquireLockSql"), new Object[] { serverId, timeLockAquired, action, timeToBreakLock, serverId }) == 1; } catch (ConcurrencySqlException ex) { log.debug("Ignoring concurrency error and reporting that we failed to get the cluster lock: {}", ex.getMessage()); return false; } }
protected void uninstall(String sql, String objectName) { sql = replaceTokens(sql, objectName); platform.getSqlTemplate().update(sql); log.info("Just uninstalled {}", objectName); }
public void deleteRouter(Router router) { if (router != null) { sqlTemplate.update(getSql("deleteRouterSql"), (Object) router.getRouterId()); } }
public void removeTrigger(StringBuilder sqlBuffer, String catalogName, String schemaName, String triggerName, String tableName) { String sql = getDropTriggerSql(sqlBuffer, catalogName, schemaName, triggerName, tableName); logSql(sql, sqlBuffer); if (parameterService.is(ParameterConstants.AUTO_SYNC_TRIGGERS)) { try { this.platform.getSqlTemplate().update(sql); } catch (Exception e) { log.warn("Tried to remove trigger using: {} and failed because: {}", sql, e.getMessage()); } } }
public void inactivateTriggerHistory(TriggerHistory history) { sqlTemplate.update(getSql("inactivateTriggerHistorySql"), new Object[] { history.getErrorMessage(), history.getTriggerHistoryId() }, new int[] { Types.VARCHAR, Types.INTEGER }); }
private long purgeStrandedBatches() { int updateStrandedBatchesCount = sqlTemplate.update(getSql("updateStrandedBatches"), OutgoingBatch.Status.OK.name(), 1, OutgoingBatch.Status.OK.name()); if (updateStrandedBatchesCount > 0) { log.info( "Set the status to {} for {} batches that no longer are associated with valid nodes", OutgoingBatch.Status.OK.name(), updateStrandedBatchesCount); statisticManager.incrementPurgedBatchOutgoingRows(updateStrandedBatchesCount); } return updateStrandedBatchesCount; }
public void saveNodeGroup(NodeGroup group) { group.setLastUpdateTime(new Date()); if (sqlTemplate.update(getSql("updateNodeGroupSql"), group.getDescription(), group.getLastUpdateTime(), group.getLastUpdateBy(), group.getNodeGroupId()) == 0) { group.setCreateTime(new Date()); sqlTemplate.update(getSql("insertNodeGroupSql"), group.getDescription(), group.getNodeGroupId(), group.getLastUpdateTime(), group.getLastUpdateBy(), group.getCreateTime()); } }
public void deleteDataGap(DataGap gap) { sqlTemplate.update(getSql("deleteDataGapSql"), new Object[] { gap.getStartId(), gap.getEndId() }, new int[] { symmetricDialect.getSqlTypeForIds(), symmetricDialect.getSqlTypeForIds() }); }
public void insertNodeSecurity(String id) { flushNodeAuthorizedCache(); String password = nodeIdCreator.generatePassword(new Node(id, null, null)); password = filterPasswordOnSaveIfNeeded(password); sqlTemplate.update(getSql("insertNodeSecuritySql"), new Object[] { id, password, findIdentity().getNodeId() }); }
public void updateDataGap(DataGap gap, DataGap.Status status) { sqlTemplate.update( getSql("updateDataGapSql"), new Object[] { status.name(), AppUtils.getHostName(), gap.getStartId(), gap.getEndId() }, new int[] { Types.VARCHAR, Types.VARCHAR, symmetricDialect.getSqlTypeForIds(), symmetricDialect.getSqlTypeForIds() }); }
public void deleteTriggerRouterGrouplet(Grouplet grouplet, TriggerRouterGrouplet triggerRouterGrouplet) { ISqlTemplate sqlTemplate = platform.getSqlTemplate(); sqlTemplate .update(getSql("deleteTriggerRouterGroupletSql"), new Object[] { grouplet.getGroupletId(), triggerRouterGrouplet.getAppliesWhen().name(), triggerRouterGrouplet.getTriggerId(), triggerRouterGrouplet.getRouterId() }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR }); }
public void save(JobStats stats) { sqlTemplate.update( getSql("insertJobStatsSql"), new Object[] { stats.getNodeId(), stats.getHostName(), stats.getJobName(), stats.getStartTime(), stats.getEndTime(), stats.getProcessedCount() }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.TIMESTAMP, Types.TIMESTAMP, Types.BIGINT }); }
public void create(Sequence sequence) { sqlTemplate.update(getSql("insertSequenceSql"), sequence.getSequenceName(), sequence.getCurrentValue(), sequence.getIncrementBy(), sequence.getMinValue(), sequence.getMaxValue(), sequence.isCycle() ? 1 : 0, sequence.getLastUpdateBy()); }
public boolean deleteRegistrationRequest(RegistrationRequest request) { String externalId = request.getExternalId() == null ? "" : request.getExternalId(); String nodeGroupId = request.getNodeGroupId() == null ? "" : request.getNodeGroupId(); return 0 < sqlTemplate.update(getSql("deleteRegistrationRequestSql"), new Object[] { nodeGroupId, externalId, request.getIpAddress(), request.getHostName(), RegistrationStatus.RQ.name() }); }