public void disableSyncTriggers(ISqlTransaction transaction, String nodeId) { String contextTableName = parameterService.getTablePrefix() + "_" + CONTEXT_TABLE_NAME; transaction.prepareAndExecute(String.format(CONTEXT_TABLE_INSERT, contextTableName), new Object[] { SYNC_TRIGGERS_DISABLED_USER_VARIABLE, "1" }); if (nodeId != null) { transaction.prepareAndExecute(String.format(CONTEXT_TABLE_INSERT, contextTableName), new Object[] { SYNC_TRIGGERS_DISABLED_NODE_VARIABLE, nodeId }); } }
protected void deleteTransformColumns(ISqlTransaction transaction, String transformTableId) { transaction.prepareAndExecute(getSql("deleteTransformColumnsSql"), (Object) transformTableId); }
public void enableSyncTriggers(ISqlTransaction transaction) { String contextTableName = parameterService.getTablePrefix() + "_" + CONTEXT_TABLE_NAME; transaction.prepareAndExecute("delete from " + contextTableName); }
protected void insertDataEvent(ISqlTransaction transaction, long dataId, long batchId, String routerId) { try { transaction .prepareAndExecute(getSql("insertIntoDataEventSql"), new Object[] { dataId, batchId, StringUtils.isBlank(routerId) ? Constants.UNKNOWN_ROUTER_ID : routerId }, new int[] { Types.NUMERIC, Types.NUMERIC, Types.VARCHAR }); } catch (RuntimeException ex) { log.error("Could not insert a data event: data_id={} batch_id={} router_id={}", new Object[] { dataId, batchId, routerId }); log.error(ex.getMessage(), ex); throw ex; } }
protected void updateExtractRequestStatus(ISqlTransaction transaction, long extractId, ExtractStatus status) { transaction.prepareAndExecute(getSql("updateExtractRequestStatus"), status.name(), extractId); }
protected boolean sql(CsvData data) { try { statistics.get(batch).startTimer(DataWriterStatisticConstants.DATABASEMILLIS); String script = data.getParsedData(CsvData.ROW_DATA)[0]; List<String> sqlStatements = getSqlStatements(script); long count = 0; for (String sql : sqlStatements) { sql = preprocessSqlStatement(sql); transaction.prepare(sql); if (log.isDebugEnabled()) { log.debug("About to run: {}", sql); } count += transaction.prepareAndExecute(sql); if (log.isDebugEnabled()) { log.debug("{} rows updated when running: {}", count, sql); } } statistics.get(batch).increment(DataWriterStatisticConstants.SQLCOUNT); statistics.get(batch).increment(DataWriterStatisticConstants.SQLROWSAFFECTEDCOUNT, count); return true; } finally { statistics.get(batch).stopTimer(DataWriterStatisticConstants.DATABASEMILLIS); } }
transaction.prepareAndExecute(getSql("deleteNodeIdentitySql")); transaction.prepareAndExecute(getSql("deleteNodeSecuritySql"), new Object[] { nodeId }); transaction.prepareAndExecute(getSql("deleteNodeHostSql"), new Object[] { nodeId }); transaction.prepareAndExecute(getSql("deleteNodeSql"), new Object[] { nodeId });
protected void deleteTableReloadRequest(ISqlTransaction sqlTransaction, TableReloadRequest request) { sqlTransaction.prepareAndExecute( getSql("deleteTableReloadRequest"), new Object[] { request.getSourceNodeId(), request.getTargetNodeId(), request.getTriggerId(), request.getRouterId() }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR }); }
int updateCount = transaction.prepareAndExecute(getSql("updateCurrentValueSql"), nextVal, name, currVal); if (updateCount != 1) {
public void deleteTransformTable(String transformTableId) { ISqlTransaction transaction = null; try { transaction = sqlTemplate.startSqlTransaction(); deleteTransformColumns(transaction, transformTableId); transaction.prepareAndExecute(getSql("deleteTransformTableSql"), (Object) transformTableId); transaction.commit(); refreshCache(); } catch (Error ex) { if (transaction != null) { transaction.rollback(); } throw ex; } catch (RuntimeException ex) { if (transaction != null) { transaction.rollback(); } throw ex; } finally { close(transaction); } }
/** * @see IRegistrationService#markNodeAsRegistered(Node) */ public void markNodeAsRegistered(String nodeId) { ISqlTransaction transaction = null; try { transaction = sqlTemplate.startSqlTransaction(); symmetricDialect.disableSyncTriggers(transaction, nodeId); transaction.prepareAndExecute(getSql("registerNodeSecuritySql"), nodeId); transaction.commit(); } catch (Error ex) { if (transaction != null) { transaction.rollback(); } throw ex; } catch (RuntimeException ex) { if (transaction != null) { transaction.rollback(); } throw ex; } finally { symmetricDialect.enableSyncTriggers(transaction); close(transaction); } }
protected void saveTransformColumn(ISqlTransaction transaction, TransformColumn transformColumn) { transformColumn.setLastUpdateTime(new Date()); if (transaction.prepareAndExecute(getSql("updateTransformColumnSql"), transformColumn.getSourceColumnName(), transformColumn.isPk() ? 1 : 0, transformColumn.getTransformType(), transformColumn.getTransformExpression(), transformColumn.getTransformOrder(), transformColumn.getLastUpdateTime(), transformColumn.getLastUpdateBy(), transformColumn.getTransformId(), transformColumn.getIncludeOn().toDbValue(), transformColumn.getTargetColumnName()) == 0) { transformColumn.setCreateTime(new Date()); transaction.prepareAndExecute(getSql("insertTransformColumnSql"), transformColumn.getTransformId(), transformColumn.getIncludeOn().toDbValue(), transformColumn.getTargetColumnName(), transformColumn.getSourceColumnName(), transformColumn.isPk() ? 1 : 0, transformColumn.getTransformType(), transformColumn.getTransformExpression(), transformColumn.getTransformOrder(), transformColumn.getLastUpdateTime(), transformColumn.getLastUpdateBy(), transformColumn.getCreateTime()); } }
public void save(ISqlTransaction sqlTransaction, FileSnapshot snapshot) { snapshot.setLastUpdateTime(new Date()); if (0 == sqlTransaction.prepareAndExecute( getSql("updateFileSnapshotSql"), new Object[] { snapshot.getLastEventType().getCode(), snapshot.getCrc32Checksum(), Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR })) { snapshot.setCreateTime(snapshot.getLastUpdateTime()); sqlTransaction.prepareAndExecute( getSql("insertFileSnapshotSql"), new Object[] { snapshot.getLastEventType().getCode(), sqlTransaction.prepareAndExecute(getSql("deleteFileSnapshotSql"), new Object[] { snapshot.getTriggerId(), snapshot.getRouterId(), snapshot.getRelativeDir(), snapshot.getFileName() }, new int[] { Types.VARCHAR, Types.VARCHAR,
public void insertIncomingError(ISqlTransaction transaction, IncomingError incomingError) { if (StringUtils.isNotBlank(incomingError.getNodeId()) && incomingError.getBatchId() >= 0) { transaction.prepareAndExecute(getSql("insertIncomingErrorSql"), incomingError.getBatchId(), incomingError.getNodeId(), incomingError.getFailedRowNumber(), incomingError .getFailedLineNumber(), incomingError.getTargetCatalogName(), incomingError.getTargetSchemaName(), incomingError.getTargetTableName(), incomingError.getEventType().getCode(), incomingError.getBinaryEncoding() .name(), incomingError.getColumnNames(), incomingError .getPrimaryKeyColumnNames(), incomingError.getRowData(), incomingError .getOldData(), incomingError.getCurData(), incomingError.getResolveData(), incomingError .getResolveData(), incomingError.getConflictId(), incomingError.getCreateTime(), incomingError .getLastUpdateBy(), incomingError.getLastUpdateTime()); } }
public void insertIncomingBatch(ISqlTransaction transaction, IncomingBatch batch) { if (batch.isPersistable()) { batch.setLastUpdatedHostName(clusterService.getServerId()); batch.setLastUpdatedTime(new Date()); transaction.prepareAndExecute( getSql("insertIncomingBatchSql"), new Object[] { batch.getBatchId(), batch.getNodeId(), batch.getChannelId(), batch.getStatus().name(), batch.getNetworkMillis(), batch.getFilterMillis(), batch.getDatabaseMillis(), batch.getFailedRowNumber(), batch.getFailedLineNumber(), batch.getByteCount(), batch.getStatementCount(), batch.getFallbackInsertCount(), batch.getFallbackUpdateCount(), batch.getIgnoreCount(), batch.getMissingDeleteCount(), batch.getSkipCount(), batch.getSqlState(), batch.getSqlCode(), FormatUtils.abbreviateForLogging(batch.getSqlMessage()), batch.getLastUpdatedHostName(), batch.getLastUpdatedTime() }, new int[] { Types.NUMERIC, Types.VARCHAR, Types.VARCHAR, Types.CHAR, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.VARCHAR, Types.NUMERIC, Types.VARCHAR, Types.VARCHAR, Types.TIMESTAMP }); } }
public void insertOutgoingBatch(ISqlTransaction transaction, OutgoingBatch outgoingBatch) { outgoingBatch.setLastUpdatedHostName(clusterService.getServerId()); long batchId = outgoingBatch.getBatchId(); if (batchId <= 0) { batchId = sequenceService.nextVal(transaction, Constants.SEQUENCE_OUTGOING_BATCH); } transaction.prepareAndExecute(getSql("insertOutgoingBatchSql"), batchId, outgoingBatch .getNodeId(), outgoingBatch.getChannelId(), outgoingBatch.getStatus().name(), outgoingBatch.getLoadId(), outgoingBatch.isExtractJobFlag() ? 1: 0, outgoingBatch.isLoadFlag() ? 1 : 0, outgoingBatch .isCommonFlag() ? 1 : 0, outgoingBatch.getReloadEventCount(), outgoingBatch .getOtherEventCount(), outgoingBatch.getLastUpdatedHostName(), outgoingBatch.getCreateBy()); outgoingBatch.setBatchId(batchId); }
public boolean updateNodeSecurity(ISqlTransaction transaction, NodeSecurity security) { security.setNodePassword(filterPasswordOnSaveIfNeeded(security.getNodePassword())); boolean updated = transaction.prepareAndExecute( getSql("updateNodeSecuritySql"), new Object[] { security.getNodePassword(), security.isRegistrationEnabled() ? 1 : 0, security.getRegistrationTime(), security.isInitialLoadEnabled() ? 1 : 0, security.getInitialLoadTime(), security.getCreatedAtNodeId(), security.isRevInitialLoadEnabled() ? 1 : 0, security.getRevInitialLoadTime(), security.getInitialLoadId(), security.getInitialLoadCreateBy(), security.getRevInitialLoadId(), security.getRevInitialLoadCreateBy(), security.getNodeId() }, new int[] { Types.VARCHAR, Types.INTEGER, Types.TIMESTAMP, Types.INTEGER, Types.TIMESTAMP, Types.VARCHAR, Types.INTEGER, Types.TIMESTAMP, Types.BIGINT, Types.VARCHAR, Types.BIGINT, Types.VARCHAR, Types.VARCHAR }) == 1; flushNodeAuthorizedCache(); return updated; }
count = transaction.prepareAndExecute( getSql("updateIncomingBatchSql"), new Object[] { batch.getStatus().name(), batch.isErrorFlag() ? 1 : 0,
public void updateOutgoingBatch(ISqlTransaction transaction, OutgoingBatch outgoingBatch) { outgoingBatch.setLastUpdatedTime(new Date()); outgoingBatch.setLastUpdatedHostName(clusterService.getServerId()); transaction.prepareAndExecute( getSql("updateOutgoingBatchSql"), new Object[] { outgoingBatch.getStatus().name(), outgoingBatch.getLoadId(), outgoingBatch.isExtractJobFlag() ? 1: 0, outgoingBatch.isLoadFlag() ? 1 : 0, outgoingBatch.isErrorFlag() ? 1 : 0, outgoingBatch.getByteCount(), outgoingBatch.getExtractCount(), outgoingBatch.getSentCount(), outgoingBatch.getLoadCount(), outgoingBatch.getDataEventCount(), outgoingBatch.getReloadEventCount(), outgoingBatch.getInsertEventCount(), outgoingBatch.getUpdateEventCount(), outgoingBatch.getDeleteEventCount(), outgoingBatch.getOtherEventCount(), outgoingBatch.getIgnoreCount(), outgoingBatch.getRouterMillis(), outgoingBatch.getNetworkMillis(), outgoingBatch.getFilterMillis(), outgoingBatch.getLoadMillis(), outgoingBatch.getExtractMillis(), outgoingBatch.getSqlState(), outgoingBatch.getSqlCode(), FormatUtils.abbreviateForLogging(outgoingBatch.getSqlMessage()), outgoingBatch.getFailedDataId(), outgoingBatch.getLastUpdatedHostName(), outgoingBatch.getLastUpdatedTime(), outgoingBatch.getBatchId(), outgoingBatch.getNodeId() }, new int[] { Types.CHAR, Types.BIGINT, Types.NUMERIC, Types.NUMERIC, Types.NUMERIC, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.BIGINT, Types.VARCHAR, Types.NUMERIC, Types.VARCHAR, Types.BIGINT, Types.VARCHAR, Types.TIMESTAMP, symmetricDialect.getSqlTypeForIds(), Types.VARCHAR }); }
transaction = sqlTemplate.startSqlTransaction(); transformTable.setLastUpdateTime(new Date()); if (transaction.prepareAndExecute(getSql("updateTransformTableSql"), transformTable .getNodeGroupLink().getSourceNodeGroupId(), transformTable.getNodeGroupLink() .getTargetNodeGroupId(), transformTable.getSourceCatalogName(), transformTable transformTable.getLastUpdateBy(), transformTable.getTransformId()) == 0) { transformTable.setCreateTime(new Date()); transaction.prepareAndExecute(getSql("insertTransformTableSql"), transformTable .getNodeGroupLink().getSourceNodeGroupId(), transformTable .getNodeGroupLink().getTargetNodeGroupId(), transformTable