application.yml 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. # 项目相关配置
  2. gyee:
  3. #实时数据库Url
  4. #baseurl: http://10.0.118.73:8011/ts
  5. baseurl: http://123.60.213.70:8011/ts
  6. #实时数据库选择
  7. realtimedataBase: mongodb #数据查询模式 golden、hwy
  8. initialcode: INITIAL
  9. server:
  10. port: 8162
  11. servlet:
  12. context-path: /
  13. management:
  14. health:
  15. redis:
  16. enabled: false
  17. mybatis-plus:
  18. configuration:
  19. map-underscore-to-camel-case: true
  20. auto-mapping-behavior: full
  21. log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  22. mapper-locations: classpath*:mapper/**/*Mapper.xml
  23. global-config:
  24. # 逻辑删除配置
  25. db-config:
  26. id-type: auto
  27. # 删除前
  28. logic-not-delete-value: 1
  29. # 删除后
  30. logic-delete-value: 0
  31. spring:
  32. main:
  33. allow-bean-definition-overriding: true #当遇到同样名字的时候,是否允许覆盖注册
  34. autoconfigure:
  35. exclude: org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration,org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration
  36. datasource:
  37. type: com.alibaba.druid.pool.DruidDataSource
  38. # driverClassName: com.mysql.jdbc.Driver
  39. #druid连接池配置
  40. druid:
  41. #主库数据源
  42. master:
  43. # url: jdbc:mysql://localhost:3306/springbootv2?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
  44. # username: root
  45. # password: 123456
  46. #url: jdbc:oracle:thin:@10.0.118.71:1521:gdsj
  47. url: jdbc:oracle:thin:@123.60.213.70:1521:gdnxfd
  48. # username: gdprod
  49. # password: gd123
  50. username: nxfdprod
  51. password: gdnxfd123
  52. driver-class-name: oracle.jdbc.driver.OracleDriver
  53. #备数据源 #关闭
  54. slave:
  55. enabled: false
  56. url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&serverTimezone=UTC
  57. username: root
  58. password: 123456
  59. #两票数据源
  60. ticket:
  61. #url: jdbc:sqlserver://10.0.118.71:1433;DatabaseName=fdeamnew
  62. url: jdbc:sqlserver://123.60.213.70:1434;DatabaseName=fdeam
  63. username: sa
  64. # password: ibs
  65. #password: Gd!123456
  66. password: Gyee@321#!
  67. driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
  68. #配置初始化连接数大小
  69. initial-size: 10
  70. # 最大连接数
  71. max-active: 50
  72. #最小连接数
  73. min-idle: 10
  74. #获取连接等待超时时间
  75. max-wait: 5000
  76. pool-prepared-statements: true #是否缓存preparedStatement,也就是PSCache。PSCache对支持游标的数据库性能提升巨大,比如说oracle。在mysql下建议关闭。
  77. max-pool-prepared-statement-per-connection-size: 20
  78. validation-query: SELECT 1 FROM DUAL
  79. validation-query-timeout: 20000
  80. test-on-borrow: false #申请连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。
  81. test-on-return: false #归还连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。
  82. test-while-idle: true #建议配置为true,不影响性能,并且保证安全性。申请连接的时候检测,如果空闲时间大于timeBetweenEvictionRunsMillis,执行validationQuery检测连接是否有效。
  83. time-between-eviction-runs-millis: 60000 #配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  84. min-evictable-idle-time-millis: 300000 #一个连接在池中最小生存的时间,单位是毫秒
  85. #StatViewServlet配置。(因为暴露的监控信息比较敏感,支持密码加密和访问ip限定)
  86. stat-view-servlet:
  87. enabled: true
  88. url-pattern: /druid/*
  89. #可以增加访问账号密码【去掉注释就可以】
  90. #login-username: admin
  91. #login-password: admin
  92. filter:
  93. stat:
  94. log-slow-sql: true
  95. slow-sql-millis: 1000
  96. merge-sql: false
  97. wall:
  98. config:
  99. multi-statement-allow: true
  100. servlet:
  101. multipart:
  102. # 开启 multipart 上传功能
  103. enabled: true
  104. # 文件写入磁盘的阈值
  105. file-size-threshold: 2KB
  106. # 最大文件大小
  107. max-file-size: 200MB
  108. # 最大请求大小
  109. max-request-size: 215MB
  110. logging:
  111. level:
  112. root: info
  113. com.example: debug
  114. edos:
  115. baseURL: http://10.0.118.73:8011/ts