crss-datainterface-task-ingest.yml 2.8 KB

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