hos-central-rest.yml 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  1. security:
  2. basic:
  3. enabled: false
  4. ---
  5. spring:
  6. profiles: dev
  7. datasource:
  8. driverClassName: com.mysql.jdbc.Driver
  9. url: jdbc:mysql://172.19.103.57:8066/hos1?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true
  10. username: hos
  11. password: 123456
  12. test-on-borrow: true
  13. validation-query: SELECT 1
  14. test-while-idle: true
  15. max-total: 100
  16. default-auto-commit: true
  17. max-idle: 200
  18. min-idle: 50
  19. initial-size: 10
  20. max-active: 200
  21. max-wait: 50
  22. minEvictableIdleTimeMillis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  23. timeBetweenEvictionRunsMillis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  24. testOnBorrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  25. testOnReturn: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  26. testWhileIdle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  27. poolPreparedStatements: true # 打开PSCache,并且指定每个连接上PSCache的大小
  28. maxPoolPreparedStatementPerConnectionSize: 50
  29. removeAbandoned: false #超过时间限制是否回收
  30. removeAbandonedTimeout: 7200 #超时时间;单位为秒。180秒=3分钟
  31. logAbandoned: false #关闭abanded连接时输出错误日志
  32. filters: stat,wall #配置监控统计拦截的filters,去掉后监控界面sql将无法统计,'wall'用于防火墙
  33. # REDIS
  34. redis:
  35. host: 172.19.103.47 # Redis server host.
  36. port: 6379
  37. password: redis!@456
  38. database: 0 # Database index used by the connection factory.
  39. timeout: 0
  40. #sentinel:
  41. # master: # Name of Redis server.
  42. # nodes: # Comma-separated list of host:port pairs.
  43. pool:
  44. max-active: 8 # Max number of connections that can be allocated by the pool at a given time. Use a negative value for no limit.
  45. max-idle: 8 # Max number of "idle" connections in the pool. Use a negative value to indicate an unlimited number of idle connections.
  46. max-wait: -1 # Maximum amount of time (in milliseconds) a connection allocation should block before throwing an exception when the pool is exhausted. Use a negative value to block indefinitely.
  47. min-idle: 1 # Target for the minimum number of idle connections to maintain in the pool. This setting only has an effect if it is positive.
  48. jpa:
  49. database-platform: org.hibernate.dialect.MySQL5Dialect
  50. hibernate:
  51. dialect: org.hibernate.dialect.MySQL5Dialect
  52. format-sql: true
  53. show-sql: false
  54. aop:
  55. proxy-target-class: false
  56. crawler:
  57. upload:
  58. ip: localhost
  59. port: 8088
  60. api: crawler/patient
  61. storage:
  62. ip: localhost
  63. port: 8088
  64. api: crawler/datapush
  65. elasticsearch:
  66. cluster-name: elasticsearch
  67. cluster-nodes: 172.19.103.9:9300
  68. service-gateway:
  69. url:
  70. ehrMgrUrl: http://172.19.103.74:10220/api/v1.0
  71. ehrCouldUrl: http://172.19.103.73:10400/api/v1.0
  72. ehrAdminUrl: http://172.19.103.73:10000/api/v1.0
  73. sslKeystore: /usr/local/esb/tomcat.keystore
  74. sslPassword: 123456
  75. clientId: zkGuSIm2Fg
  76. clientKey: emtHdVNJbTJGZzpnUGR2VFJBWVVoc2tjaHht
  77. # 中间库连接地址信息
  78. temp:
  79. datasource:
  80. driverClassName: oracle.jdbc.driver.OracleDriver
  81. url: jdbc:oracle:thin:@172.19.103.76:1521/orcl.123.125.237
  82. username: test
  83. password: test
  84. validation-query: select 1 from dual
  85. ---
  86. spring:
  87. profiles: test
  88. datasource:
  89. driverClassName: com.mysql.jdbc.Driver
  90. url: jdbc:mysql://172.19.103.57:8066/hos1?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true
  91. username: hos
  92. password: 123456
  93. test-on-borrow: true
  94. validation-query: SELECT 1
  95. test-while-idle: true
  96. max-total: 100
  97. default-auto-commit: true
  98. max-idle: 200
  99. min-idle: 50
  100. initial-size: 10
  101. max-active: 200
  102. max-wait: 50
  103. minEvictableIdleTimeMillis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  104. timeBetweenEvictionRunsMillis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  105. testOnBorrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  106. testOnReturn: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  107. testWhileIdle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  108. poolPreparedStatements: true # 打开PSCache,并且指定每个连接上PSCache的大小
  109. maxPoolPreparedStatementPerConnectionSize: 50
  110. removeAbandoned: false #超过时间限制是否回收
  111. removeAbandonedTimeout: 7200 #超时时间;单位为秒。180秒=3分钟
  112. logAbandoned: false #关闭abanded连接时输出错误日志
  113. filters: stat,wall #配置监控统计拦截的filters,去掉后监控界面sql将无法统计,'wall'用于防火墙
  114. # REDIS
  115. redis:
  116. host: 172.19.103.47 # Redis server host.
  117. port: 6379
  118. password: redis!@456
  119. database: 0 # Database index used by the connection factory.
  120. timeout: 0
  121. #sentinel:
  122. # master: # Name of Redis server.
  123. # nodes: # Comma-separated list of host:port pairs.
  124. pool:
  125. max-active: 8 # Max number of connections that can be allocated by the pool at a given time. Use a negative value for no limit.
  126. max-idle: 8 # Max number of "idle" connections in the pool. Use a negative value to indicate an unlimited number of idle connections.
  127. max-wait: -1 # Maximum amount of time (in milliseconds) a connection allocation should block before throwing an exception when the pool is exhausted. Use a negative value to block indefinitely.
  128. min-idle: 1 # Target for the minimum number of idle connections to maintain in the pool. This setting only has an effect if it is positive.
  129. jpa:
  130. database-platform: org.hibernate.dialect.MySQL5Dialect
  131. hibernate:
  132. dialect: org.hibernate.dialect.MySQL5Dialect
  133. format-sql: true
  134. show-sql: false
  135. aop:
  136. proxy-target-class: false
  137. crawler:
  138. upload:
  139. ip: localhost
  140. port: 8088
  141. api: crawler/patient
  142. storage:
  143. ip: localhost
  144. port: 8088
  145. api: crawler/datapush
  146. elasticsearch:
  147. cluster-name: elasticsearch
  148. cluster-nodes: 172.19.103.9:9300
  149. service-gateway:
  150. url:
  151. ehrMgrUrl: http://172.19.103.74:10220/api/v1.0
  152. ehrCouldUrl: http://172.19.103.73:10400/api/v1.0
  153. ehrAdminUrl: http://172.19.103.73:10000/api/v1.0
  154. sslKeystore: /usr/local/esb/tomcat.keystore
  155. sslPassword: 123456
  156. clientId: zkGuSIm2Fg
  157. clientKey: emtHdVNJbTJGZzpnUGR2VFJBWVVoc2tjaHht
  158. # 中间库连接地址信息
  159. temp:
  160. datasource:
  161. driverClassName: oracle.jdbc.driver.OracleDriver
  162. url: jdbc:oracle:thin:@172.19.103.76:1521/orcl.123.125.237
  163. username: test
  164. password: test
  165. validation-query: select 1 from dual
  166. ---
  167. spring:
  168. profiles: prod
  169. datasource:
  170. driverClassName: com.mysql.jdbc.Driver
  171. url: jdbc:mysql://192.168.210.3:3310/tenant_central?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true
  172. username: jkzlesb
  173. password: Ajch6o@Y
  174. test-on-borrow: true
  175. validation-query: SELECT 1
  176. test-while-idle: true
  177. max-total: 100
  178. default-auto-commit: true
  179. max-idle: 200
  180. min-idle: 50
  181. initial-size: 10
  182. max-active: 200
  183. max-wait: 50
  184. minEvictableIdleTimeMillis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  185. timeBetweenEvictionRunsMillis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  186. testOnBorrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  187. testOnReturn: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  188. testWhileIdle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  189. poolPreparedStatements: true # 打开PSCache,并且指定每个连接上PSCache的大小
  190. maxPoolPreparedStatementPerConnectionSize: 50
  191. removeAbandoned: false #超过时间限制是否回收
  192. removeAbandonedTimeout: 7200 #超时时间;单位为秒。180秒=3分钟
  193. logAbandoned: false #关闭abanded连接时输出错误日志
  194. filters: stat,wall #配置监控统计拦截的filters,去掉后监控界面sql将无法统计,'wall'用于防火墙
  195. jpa:
  196. database-platform: org.hibernate.dialect.MySQL5Dialect
  197. hibernate:
  198. dialect: org.hibernate.dialect.MySQL5Dialect
  199. format-sql: true
  200. show-sql: false
  201. aop:
  202. proxy-target-class: false
  203. crawler:
  204. upload:
  205. ip: localhost
  206. port: 8088
  207. api: crawler/patient
  208. storage:
  209. ip: localhost
  210. port: 8088
  211. api: crawler/datapush
  212. elasticsearch:
  213. cluster-name: elasticsearch
  214. cluster-nodes: 172.10.10.5:9300
  215. service-gateway:
  216. url:
  217. ehrMgrUrl: http://192.168.200.76:10220/api/v1.0
  218. ehrCouldUrl: http://192.168.200.67:10400/api/v1.0
  219. ehrAdminUrl: http://192.168.220.84:10000/api/v1.0
  220. sslKeystore: /root/jkzl/tomcat.keystore
  221. sslPassword: 123456
  222. clientId: zkGuSIm2Fg
  223. clientKey: emtHdVNJbTJGZzpnUGR2VFJBWVVoc2tjaHht
  224. # 中间库连接地址信息
  225. temp:
  226. datasource:
  227. driverClassName: oracle.jdbc.driver.OracleDriver
  228. url: jdbc:oracle:thin:@10.16.11.9:1522/sjpt_p4
  229. username: shangrao
  230. password: shangrao_2017
  231. validation-query: select 1 from dual