crss-datainterface-task-ingest.yml 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
  1. spring:
  2. crss-emdb:
  3. datasource:
  4. jdbcUrl: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)
  5. (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.94.165)(PORT=1521))
  6. (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.94.166)(PORT=1521))
  7. (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.94.167)(PORT=1521)))
  8. (CONNECT_DATA=(SERVICE_NAME=emdb)(SERVER=DEDICATED)))
  9. username: crss_tod
  10. password: crss_tod
  11. driverClassName: oracle.jdbc.OracleDriver
  12. connectionTimeout: 150000
  13. maximumPoolSize: 3
  14. crss-dataflow:
  15. datasource:
  16. jdbcUrl: jdbc:edb://10.176.11.131:5432/crss?currentSchema=dataflow
  17. username: crss_dataflow
  18. password: lgcCpwy0
  19. driverClassName: com.edb.Driver
  20. connectionTimeout: 150000
  21. maximumPoolSize: 3
  22. test-on-borrow: true
  23. validation-query: SELECT 1
  24. crss-nmms:
  25. datasource:
  26. jdbcUrl: jdbc:edb://10.176.11.131:5432/crss?currentSchema=nmms
  27. username: crss_nmms
  28. password: lbgg1i2Y
  29. driverClassName: com.edb.Driver
  30. connectionTimeout: 150000
  31. maximumPoolSize: 3
  32. test-on-borrow: true
  33. validation-query: SELECT 1
  34. crss-registration:
  35. datasource:
  36. jdbcUrl: jdbc:edb://10.176.11.131:5432/crss?currentSchema=registration
  37. username: crss_registration
  38. password: 51UF3JA9
  39. driverClassName: com.edb.Driver
  40. connectionTimeout: 150000
  41. maximumPoolSize: 3
  42. test-on-borrow: true
  43. validation-query: SELECT 1
  44. jpa:
  45. show-sql: false
  46. generate-ddl: false
  47. open-in-view: false
  48. properties:
  49. hibernate:
  50. dialect: org.hibernate.dialect.PostgreSQLDialect
  51. ddl-auto: none
  52. hbm2ddl:
  53. auto: none
  54. cloud:
  55. task:
  56. initialize:
  57. enable: false
  58. batch:
  59. initializer:
  60. enabled: false
  61. logging:
  62. level:
  63. com.pemc.crss: DEBUG
  64. batch:
  65. # resourceLocation: "file:target/libs/crss-datainterface-task-ingest-1.0.0.BUILD-SNAPSHOT.jar"
  66. partitionSize:
  67. mq: 1500
  68. ssla: 1500
  69. report: 1500
  70. importPrices: 100
  71. autoMinusDaysAgo: 2
  72. mqreport:
  73. directory: /tmp/
  74. sftp:
  75. credentials:
  76. #username: pemc
  77. #password: 123qwe
  78. username: crss_sftp_rbcq
  79. password: Pemc1234
  80. #host: sftp.marathon.l4lb.thisdcos.directory
  81. host: 192.168.94.82
  82. port: 22
  83. workingDirectory: /rbcq
  84. privateKey:
  85. database:
  86. emdb:
  87. rtu-db: "SNAPSHOT_MVIEW"
  88. energy-price-sched-db: "ENERGY_MVIEW"
  89. reserve-price-sched-db: "RESERVE_MVIEW"
  90. nmms:
  91. rtu-db: "TXN_RTU"
  92. energy-price-sched-db: "TXN_ENERGY_PRICE_SCHED"
  93. reserve-price-sched-db: "TXN_RESERVE_PRICE_SCHED"
  94. reserve-bcq-db: "TXN_RESERVE_BCQ"
  95. bcq:
  96. fileNamePrefix: "reserve_bcq_"
  97. todi_config:
  98. dispatch-interval: 5
  99. reserve-categories-white-list: "Regulation Down,Fast Contingency Raise,Fast Contingency Lower,Slow Contingency Raise,Slow Contingency Lower,Delayed Contingency Raise,Delayed Contingency Lower,Regulation Up"