public long findMaxDataId() { return sqlTemplate.queryForLong(getSql("selectMaxDataIdSql")); }
public long findMaxDataEventDataId() { return sqlTemplate.queryForLong(getSql("selectMaxDataEventDataIdSql")); }
public void init() { long maxBatchId = sqlTemplate.queryForLong(getSql("maxOutgoingBatchSql")); if (maxBatchId < 1) { maxBatchId = 1; } try { create(new Sequence(Constants.SEQUENCE_OUTGOING_BATCH, maxBatchId, 1, 1, 9999999999l, "system", false)); } catch (UniqueKeyException ex) { log.debug("Failed to create sequence {}. Must be initialized already.", Constants.SEQUENCE_OUTGOING_BATCH); } try { create(new Sequence(Constants.SEQUENCE_OUTGOING_BATCH_LOAD_ID, 1, 1, 1, 9999999999l, "system", false)); } catch (UniqueKeyException ex) { log.debug("Failed to create sequence {}. Must be initialized already.", Constants.SEQUENCE_OUTGOING_BATCH_LOAD_ID); } }
public long getUnroutedDataCount() { long maxDataIdAlreadyRouted = sqlTemplate .queryForLong(getSql("selectLastDataIdRoutedUsingDataGapSql")); long leftToRoute = engine.getDataService().findMaxDataId() - maxDataIdAlreadyRouted; List<DataGap> gaps = engine.getDataService().findDataGaps(); for (int i = 0; i < gaps.size()-2; i++) { DataGap gap = gaps.get(i); leftToRoute += (gap.getEndId() - gap.getStartId()); } if (leftToRoute > 0) { return leftToRoute; } else { return 0; } }
sequence = 1l + template.queryForLong(String.format("select max(%s) from %s", COLUMN_AUDIT_ID, auditTableName)); } else {