hos-central-rest.yml 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238
  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: prod_sr
  88. datasource:
  89. driverClassName: com.mysql.jdbc.Driver
  90. url: jdbc:mysql://192.168.210.3:3310/tenant_central?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true
  91. username: jkzlesb
  92. password: Ajch6o@Y
  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. jpa:
  115. database-platform: org.hibernate.dialect.MySQL5Dialect
  116. hibernate:
  117. dialect: org.hibernate.dialect.MySQL5Dialect
  118. format-sql: true
  119. show-sql: false
  120. aop:
  121. proxy-target-class: false
  122. crawler:
  123. upload:
  124. ip: localhost
  125. port: 8088
  126. api: crawler/patient
  127. storage:
  128. ip: localhost
  129. port: 8088
  130. api: crawler/datapush
  131. elasticsearch:
  132. cluster-name: elasticsearch
  133. cluster-nodes: 172.10.10.5:9300
  134. service-gateway:
  135. url:
  136. ehrMgrUrl: http://192.168.200.76:10220/api/v1.0
  137. ehrCouldUrl: http://192.168.200.67:10400/api/v1.0
  138. ehrAdminUrl: http://192.168.220.84:10000/api/v1.0
  139. sslKeystore: /root/jkzl/tomcat.keystore
  140. sslPassword: 123456
  141. clientId: zkGuSIm2Fg
  142. clientKey: emtHdVNJbTJGZzpnUGR2VFJBWVVoc2tjaHht
  143. # 中间库连接地址信息
  144. temp:
  145. datasource:
  146. driverClassName: oracle.jdbc.driver.OracleDriver
  147. url: jdbc:oracle:thin:@10.16.11.9:1522/sjpt_p4
  148. username: shangrao
  149. password: shangrao_2017
  150. validation-query: select 1 from dual
  151. ---
  152. spring:
  153. profiles: test
  154. datasource:
  155. driverClassName: com.mysql.jdbc.Driver
  156. url: jdbc:mysql://172.19.103.57:8066/hos1?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true
  157. username: hos
  158. password: 123456
  159. test-on-borrow: true
  160. validation-query: SELECT 1
  161. test-while-idle: true
  162. max-total: 100
  163. default-auto-commit: true
  164. max-idle: 200
  165. min-idle: 50
  166. initial-size: 10
  167. max-active: 200
  168. max-wait: 50
  169. minEvictableIdleTimeMillis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  170. timeBetweenEvictionRunsMillis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  171. testOnBorrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  172. testOnReturn: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  173. testWhileIdle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  174. poolPreparedStatements: true # 打开PSCache,并且指定每个连接上PSCache的大小
  175. maxPoolPreparedStatementPerConnectionSize: 50
  176. removeAbandoned: false #超过时间限制是否回收
  177. removeAbandonedTimeout: 7200 #超时时间;单位为秒。180秒=3分钟
  178. logAbandoned: false #关闭abanded连接时输出错误日志
  179. filters: stat,wall #配置监控统计拦截的filters,去掉后监控界面sql将无法统计,'wall'用于防火墙
  180. # REDIS
  181. redis:
  182. host: 172.19.103.47 # Redis server host.
  183. port: 6379
  184. password: redis!@456
  185. database: 0 # Database index used by the connection factory.
  186. timeout: 0
  187. #sentinel:
  188. # master: # Name of Redis server.
  189. # nodes: # Comma-separated list of host:port pairs.
  190. pool:
  191. 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.
  192. max-idle: 8 # Max number of "idle" connections in the pool. Use a negative value to indicate an unlimited number of idle connections.
  193. 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.
  194. 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.
  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.19.103.9:9300
  215. service-gateway:
  216. url:
  217. ehrMgrUrl: http://172.19.103.74:10220/api/v1.0
  218. ehrCouldUrl: http://172.19.103.73:10400/api/v1.0
  219. ehrAdminUrl: http://172.19.103.73:10000/api/v1.0
  220. sslKeystore: /usr/local/esb/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:@172.19.103.76:1521/orcl.123.125.237
  229. username: test
  230. password: test
  231. validation-query: select 1 from dual