crssconfig/crss-meterprocess-stream-source-daily-raw/application-devoracle.yml

#daily extract
spring:
  profiles: dailyExtract
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    password: crss
    username: crss_meterprocess_metering
    url: jdbc:oracle:thin:@192.168.235.6:1521:ORCL
  cloud:
    stream:
      bindings:
        output:
          content-type: application/json
jdbc:
  max-rows-per-poll: 1
  query: "select * from txn_meter_data_daily where consumed <> 'Y' or consumed is null or consumed = ''"
  split: true
  update: "update txn_meter_data_daily set consumed = 'Y' where meter_data_id in (:meter_data_id)"

trigger:
#  cron: '0/1 * * * * ?'
#  date-format: 'MM/dd/yyyy'
  fixed-delay: 100
  initial-delay: 100
  max-messages: 1
  time-unit: MILLISECONDS


logging:
  level:
    org.springframework: DEBUG

---

#Monthly extract
spring:
  profiles: monthlyExtract
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    password: crss
    username: crss_meterprocess_metering
    url: jdbc:oracle:thin:@192.168.235.6:1521:ORCL
  cloud:
    stream:
      bindings:
        output:
          content-type: application/json
jdbc:
  max-rows-per-poll: 1
  query: "select * from txn_meter_data_monthly where consumed <> 'Y' or consumed is null or consumed = ''"
  split: true
  update: "update txn_meter_data_monthly set consumed = 'Y' where meter_data_id in (:meter_data_id)"

trigger:
#  cron: '0/1 * * * * ?'
#  date-format: 'MM/dd/yyyy'
  fixed-delay: 100
  initial-delay: 100
  max-messages: 1
  time-unit: MILLISECONDS

---

# default
spring:
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    password: crss
    username: crss_meterprocess_metering
    url: jdbc:oracle:thin:@192.168.235.6:1521:ORCL
  cloud:
    stream:
      bindings:
        output:
          content-type: application/json
jdbc:
  max-rows-per-poll: 1
  query: "select * from txn_meter_data_monthly where consumed <> 'Y' or consumed is null or consumed = ''"
  split: true
  update: "update txn_meter_data_monthly set consumed = 'Y' where meter_data_id in (:meter_data_id)"

trigger:
#  cron: '0/1 * * * * ?'
#  date-format: 'MM/dd/yyyy'
  fixed-delay: 100
  initial-delay: 100
  max-messages: 1
  time-unit: MILLISECONDS