crss-datainterface-task-ingest.yml 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  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. jpa:
  41. show-sql: false
  42. generate-ddl: false
  43. open-in-view: false
  44. properties:
  45. hibernate:
  46. dialect: org.hibernate.dialect.PostgreSQLDialect
  47. ddl-auto: none
  48. hbm2ddl:
  49. auto: none
  50. cloud:
  51. task:
  52. initialize:
  53. enable: false
  54. batch:
  55. initializer:
  56. enabled: false
  57. logging:
  58. level:
  59. com.pemc.crss: DEBUG
  60. batch:
  61. # resourceLocation: "file:target/libs/crss-datainterface-task-ingest-1.0.0.BUILD-SNAPSHOT.jar"
  62. partitionSize:
  63. mq: 1500
  64. ssla: 1500
  65. report: 1500
  66. importPrices: 100
  67. autoMinusDaysAgo: 2
  68. mqreport:
  69. directory: /tmp/
  70. sftp:
  71. credentials:
  72. #username: pemc
  73. #password: 123qwe
  74. username: crss_sftp_rbcq
  75. password: Pemc1234
  76. #host: sftp.marathon.l4lb.thisdcos.directory
  77. host: 192.168.94.82
  78. port: 22
  79. workingDirectory: /rbcq
  80. privateKey:
  81. database:
  82. emdb:
  83. rtu-db: "SNAPSHOT_MVIEW"
  84. energy-price-sched-db: "ENERGY_MVIEW"
  85. reserve-price-sched-db: "RESERVE_MVIEW"
  86. nmms:
  87. rtu-db: "TXN_RTU"
  88. energy-price-sched-db: "TXN_ENERGY_PRICE_SCHED"
  89. reserve-price-sched-db: "TXN_RESERVE_PRICE_SCHED"
  90. reserve-bcq-db: "TXN_RESERVE_BCQ"
  91. bcq:
  92. fileNamePrefix: "reserve_bcq_"
  93. todi_config:
  94. dispatch-interval: 5
  95. 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"