application-dev.yml 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253
  1. spring:
  2. ############################################################
  3. #
  4. # 配置数据源相关 使用 HikariCP 数据源
  5. #
  6. ############################################################
  7. # jdbc_config datasource
  8. datasource:
  9. dynamic:
  10. primary: db1
  11. datasource:
  12. db1:
  13. url: jdbc:mysql://172.18.128.8:3306/thsjzt?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  14. # url: jdbc:mysql://172.17.5.7:3306/thsjzt?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  15. username: thsjzt
  16. password: thsjzt
  17. # Hikari will use the above plus the following to setup connection pooling
  18. type: com.zaxxer.hikari.HikariDataSource
  19. hikari:
  20. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  21. connection-timeout: 30000
  22. # 最小连接数
  23. minimum-idle: 5
  24. # 最大连接数
  25. maximum-pool-size: 15
  26. # 自动提交
  27. auto-commit: true
  28. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  29. idle-timeout: 600000
  30. # 连接池的名字
  31. pool-name: DatebookHikariCP
  32. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  33. max-lifetime: 28740000
  34. connection-test-query: SELECT 1
  35. db1_gjj:
  36. url: jdbc:mysql://172.18.128.8:3306/thgjj?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  37. # url: jdbc:mysql://172.17.5.7:3306/thgjj?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  38. username: thsjzt
  39. password: thsjzt
  40. # Hikari will use the above plus the following to setup connection pooling
  41. type: com.zaxxer.hikari.HikariDataSource
  42. hikari:
  43. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  44. connection-timeout: 30000
  45. # 最小连接数
  46. minimum-idle: 500
  47. # 最大连接数
  48. maximum-pool-size: 15000
  49. # 自动提交
  50. auto-commit: true
  51. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  52. idle-timeout: 600000
  53. # 连接池的名字
  54. pool-name: DatebookHikariCP
  55. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  56. max-lifetime: 28740000
  57. connection-test-query: SELECT 1
  58. db_gjj_s:
  59. url: jdbc:mysql://59.198.246.77:32368/jl503001?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  60. username: jl503001
  61. password: Lg83RJp5
  62. # url: jdbc:mysql://172.18.128.8:3306/thgjj?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  63. # url: jdbc:mysql://172.17.5.7:3306/thsjzt?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  64. # username: thsjzt
  65. # password: thsjzt
  66. # Hikari will use the above plus the following to setup connection pooling
  67. type: com.zaxxer.hikari.HikariDataSource
  68. hikari:
  69. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  70. connection-timeout: 30000
  71. # 最小连接数
  72. minimum-idle: 500
  73. # 最大连接数
  74. maximum-pool-size: 15000
  75. # 自动提交
  76. auto-commit: true
  77. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  78. idle-timeout: 600000
  79. # 连接池的名字
  80. pool-name: DatebookHikariCP
  81. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  82. max-lifetime: 28740000
  83. connection-test-query: SELECT 1
  84. db2:
  85. url: jdbc:mysql://59.198.246.77:32368/jl503033?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  86. username: jl503033
  87. password: Bx82TIg0
  88. # Hikari will use the above plus the following to setup connection pooling
  89. type: com.zaxxer.hikari.HikariDataSource
  90. hikari:
  91. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  92. connection-timeout: 30000
  93. # 最小连接数
  94. minimum-idle: 5
  95. # 最大连接数
  96. maximum-pool-size: 15
  97. # 自动提交
  98. auto-commit: true
  99. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  100. idle-timeout: 600000
  101. # 连接池的名字
  102. pool-name: DatebookHikariCP
  103. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  104. max-lifetime: 28740000
  105. connection-test-query: SELECT 1
  106. db3:
  107. url: jdbc:mysql://59.198.246.77:32368/jl503029?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  108. username: jl503029
  109. password: Lp18NUg8
  110. # Hikari will use the above plus the following to setup connection pooling
  111. type: com.zaxxer.hikari.HikariDataSource
  112. hikari:
  113. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  114. connection-timeout: 30000
  115. # 最小连接数
  116. minimum-idle: 5
  117. # 最大连接数
  118. maximum-pool-size: 15
  119. # 自动提交
  120. auto-commit: true
  121. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  122. idle-timeout: 600000
  123. # 连接池的名字
  124. pool-name: DatebookHikariCP
  125. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  126. max-lifetime: 28740000
  127. connection-test-query: SELECT 1
  128. db4:
  129. url: jdbc:mysql://59.198.246.77:32368/jl503011?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  130. username: jl503011
  131. password: Oq82TSa8
  132. # Hikari will use the above plus the following to setup connection pooling
  133. type: com.zaxxer.hikari.HikariDataSource
  134. hikari:
  135. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  136. connection-timeout: 30000
  137. # 最小连接数
  138. minimum-idle: 5
  139. # 最大连接数
  140. maximum-pool-size: 15
  141. # 自动提交
  142. auto-commit: true
  143. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  144. idle-timeout: 600000
  145. # 连接池的名字
  146. pool-name: DatebookHikariCP
  147. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  148. max-lifetime: 28740000
  149. connection-test-query: SELECT 1
  150. db5:
  151. url: jdbc:mysql://59.198.246.77:32368/jl503026?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  152. username: jl503026
  153. password: Sw80ABr2
  154. # Hikari will use the above plus the following to setup connection pooling
  155. type: com.zaxxer.hikari.HikariDataSource
  156. hikari:
  157. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  158. connection-timeout: 30000
  159. # 最小连接数
  160. minimum-idle: 5
  161. # 最大连接数
  162. maximum-pool-size: 15
  163. # 自动提交
  164. auto-commit: true
  165. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  166. idle-timeout: 600000
  167. # 连接池的名字
  168. pool-name: DatebookHikariCP
  169. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  170. max-lifetime: 28740000
  171. connection-test-query: SELECT 1
  172. db6:
  173. url: jdbc:mysql://59.198.246.77:32368/jl503008?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  174. username: jl503008
  175. password: Jl10PEr0
  176. # Hikari will use the above plus the following to setup connection pooling
  177. type: com.zaxxer.hikari.HikariDataSource
  178. hikari:
  179. # 等待连接池分配连接的最大时长(毫秒),超过这个时长还没有的连接则发生SQLException,默认:30秒
  180. connection-timeout: 30000
  181. # 最小连接数
  182. minimum-idle: 5
  183. # 最大连接数
  184. maximum-pool-size: 15
  185. # 自动提交
  186. auto-commit: true
  187. # 一个连接idle状态的最大时长(毫秒),超时则被释放(retired),默认:10分钟
  188. idle-timeout: 600000
  189. # 连接池的名字
  190. pool-name: DatebookHikariCP
  191. # 一个连接的生命时长(毫秒),超时而且没被使用则被释放(retired),默认:30分钟1800000ms
  192. max-lifetime: 28740000
  193. connection-test-query: SELECT 1
  194. # driver-class-name: com.mysql.cj.jdbc.Driver
  195. # url: jdbc:mysql://59.198.246.77:32368/jl503034?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  196. # username: jl503034
  197. # password: Cs56DIi9
  198. # url: jdbc:mysql://172.17.5.7:3306/thsjzt?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  199. # url: jdbc:mysql://10.0.51.4:8888/thsjzt?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8
  200. jersey:
  201. application-path: api
  202. ############################################################
  203. #
  204. # mybatis 配置
  205. #
  206. ############################################################
  207. # mybatis \配置
  208. mybatis:
  209. type-aliases-package: com.sooka.pojo
  210. mapper-locations: classpath:mapper/*.xml,system/*.xml
  211. # 通用mapper配置
  212. mapper:
  213. mappers: com.sooka.utils.MyMapper
  214. not-empty: false
  215. identity: MYSQL
  216. ############################################################
  217. #
  218. # Server 服务器相关配置
  219. #
  220. ############################################################
  221. server:
  222. # 配置api端口号
  223. port: 5522
  224. tomcat:
  225. # tomcat的URI编码
  226. uri-encoding: UTF-8
  227. ############################################################
  228. #
  229. # 新点接口地址配置
  230. #
  231. ############################################################
  232. xd:
  233. # 基础地址
  234. base_url: http://syggzy.jlsy.gov.cn/EpointWebService/rest/projectinformation
  235. project:
  236. setting:
  237. env: local