crss-datainterface-task-ingest.yml 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. spring:
  2. crss-emdb:
  3. datasource:
  4. jdbcUrl: ${crss.emdb}
  5. username: crss_tod
  6. password: crss_tod
  7. driverClassName: oracle.jdbc.OracleDriver
  8. connectionTimeout: 150000
  9. maximumPoolSize: 3
  10. crss-dataflow:
  11. datasource:
  12. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=dataflow
  13. username: crss_dataflow
  14. password: lgcCpwy0
  15. driverClassName: com.edb.Driver
  16. connectionTimeout: 150000
  17. maximumPoolSize: 3
  18. test-on-borrow: true
  19. validation-query: SELECT 1
  20. crss-nmms:
  21. datasource:
  22. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=nmms
  23. username: crss_nmms
  24. password: lbgg1i2Y
  25. driverClassName: com.edb.Driver
  26. connectionTimeout: 150000
  27. maximumPoolSize: 3
  28. test-on-borrow: true
  29. validation-query: SELECT 1
  30. crss-registration:
  31. datasource:
  32. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=registration
  33. username: crss_registration
  34. password: 51UF3JA9
  35. driverClassName: com.edb.Driver
  36. connectionTimeout: 150000
  37. maximumPoolSize: 3
  38. test-on-borrow: true
  39. validation-query: SELECT 1
  40. crss-scheduler:
  41. datasource:
  42. driverClassName: "${spring.datasource.driverClassName}"
  43. jdbcUrl: jdbc:postgresql://${crss.database.ip}:5432/crss?currentSchema=scheduler
  44. username: crss_scheduler
  45. password: S0CuFyj6
  46. jpa:
  47. show-sql: false
  48. generate-ddl: false
  49. open-in-view: false
  50. properties:
  51. hibernate:
  52. dialect: org.hibernate.dialect.PostgreSQLDialect
  53. ddl-auto: none
  54. hbm2ddl:
  55. auto: none
  56. cloud:
  57. task:
  58. initialize:
  59. enable: false
  60. batch:
  61. initializer:
  62. enabled: false
  63. logging:
  64. level:
  65. com.pemc.crss: DEBUG
  66. batch:
  67. # resourceLocation: "file:target/libs/crss-datainterface-task-ingest-1.0.0.BUILD-SNAPSHOT.jar"
  68. partitionSize:
  69. mq: 1500
  70. ssla: 1500
  71. report: 1500
  72. importPrices: 100
  73. autoMinusDaysAgo: 2
  74. mqreport:
  75. directory: /tmp/
  76. sftp:
  77. credentials:
  78. #username: pemc
  79. #password: 123qwe
  80. username: crss_sftp_rbcq
  81. password: Pemc1234
  82. #host: sftp.marathon.l4lb.thisdcos.directory
  83. host: 192.168.94.82
  84. port: 22
  85. workingDirectory: /rbcq
  86. privateKey:
  87. database:
  88. emdb:
  89. rtu-db: "SNAPSHOT_MVIEW"
  90. energy-price-sched-db: "ENERGY_MVIEW"
  91. reserve-price-sched-db: "RESERVE_MVIEW"
  92. nmms:
  93. rtu-db: "TXN_RTU"
  94. energy-price-sched-db: "TXN_ENERGY_PRICE_SCHED"
  95. reserve-price-sched-db: "TXN_RESERVE_PRICE_SCHED"
  96. reserve-bcq-db: "TXN_RESERVE_BCQ"
  97. registration:
  98. mtn-db: "TXN_MARKET_TRADING_NODE"
  99. bcq:
  100. fileNamePrefix: "reserve_bcq_"
  101. todi_config:
  102. dispatch-interval: 5
  103. 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"