application-daoTest.yml 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. spring:
  2. datasource:
  3. druid:
  4. master:
  5. driver-class-name: com.mysql.cj.jdbc.Driver
  6. url: jdbc:mysql://192.168.16.222:3306/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true&removeAbandoned=true&removeAbandonedTimeout=60&logAbandoned=true
  7. username: root
  8. password: mydm888
  9. filters: wall,stat
  10. filter:
  11. stat:
  12. log-slow-sql: true
  13. #慢sql
  14. slow-sql-millis: 1000
  15. #初始化大小、最小、最大
  16. initial-size: 1
  17. max-active: 50
  18. max-pool-prepared-statement-per-connection-size: 20
  19. #获取连接等待超时的时间
  20. max-wait: 60000
  21. #一个连接在池中最小生存的时间,单位是毫秒
  22. min-evictable-idle-time-millis: 300000
  23. min-idle: 5
  24. #打开PSCache,并且指定每个连接上PSCache的大小
  25. #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
  26. pool-prepared-statements: false
  27. test-on-borrow: true
  28. test-on-return: true
  29. test-while-idle: true
  30. #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  31. time-between-eviction-runs-millis: 60000
  32. validation-query: SELECT 'x'
  33. slave:
  34. driver-class-name: com.mysql.cj.jdbc.Driver
  35. url: jdbc:mysql://localhost:3306/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
  36. username: root
  37. #password: mysql?123!@MYSQL
  38. password: mydm888
  39. filters: wall,stat
  40. filter:
  41. stat:
  42. log-slow-sql: true
  43. #慢sql
  44. slow-sql-millis: 1000
  45. #初始化大小、最小、最大
  46. initial-size: 1
  47. max-active: 50
  48. max-pool-prepared-statement-per-connection-size: 20
  49. #获取连接等待超时的时间
  50. max-wait: 60000
  51. #一个连接在池中最小生存的时间,单位是毫秒
  52. min-evictable-idle-time-millis: 300000
  53. min-idle: 5
  54. #打开PSCache,并且指定每个连接上PSCache的大小
  55. #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
  56. pool-prepared-statements: false
  57. test-on-borrow: true
  58. test-on-return: true
  59. test-while-idle: true
  60. #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  61. time-between-eviction-runs-millis: 60000
  62. validation-query: SELECT 'x'
  63. qykh:
  64. driver-class-name: com.mysql.cj.jdbc.Driver
  65. url: jdbc:mysql://139.159.196.89:33306/qykh?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
  66. username: qykh
  67. password: qykh@CQDWJS@!123
  68. filters: wall,stat
  69. filter:
  70. stat:
  71. log-slow-sql: true
  72. #慢sql
  73. slow-sql-millis: 1000
  74. #初始化大小、最小、最大
  75. initial-size: 1
  76. max-active: 50
  77. max-pool-prepared-statement-per-connection-size: 20
  78. #获取连接等待超时的时间
  79. max-wait: 60000
  80. #一个连接在池中最小生存的时间,单位是毫秒
  81. min-evictable-idle-time-millis: 300000
  82. min-idle: 5
  83. #打开PSCache,并且指定每个连接上PSCache的大小
  84. #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
  85. pool-prepared-statements: false
  86. test-on-borrow: true
  87. test-on-return: true
  88. test-while-idle: true
  89. #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  90. time-between-eviction-runs-millis: 60000
  91. validation-query: SELECT 'x'
  92. stat-view-servlet:
  93. login-password: platform8888
  94. login-username: root
  95. stat-view-servlet:
  96. login-password: platform8888
  97. login-username: root
  98. jpa:
  99. properties:
  100. hibernate:
  101. temp:
  102. use_jdbc_metadata_defaults: false
  103. dialect: org.hibernate.dialect.MySQLDialect
  104. # mybaits配置 tk
  105. mybatis:
  106. mapper-locations: classpath:mapper/**/*.xml
  107. configuration:
  108. map-underscore-to-camel-case: true
  109. call-setters-on-nulls: true
  110. jdbc-type-for-null: NULL
  111. # mybaits配置 tk
  112. mapper:
  113. mappers:
  114. - com.platform.dao.config.MyMapper
  115. not-empty: false
  116. identity: MYSQL
  117. data:
  118. aspect:
  119. method:
  120. names: get,select
  121. quartz:
  122. datasource:
  123. quartzDataSource:
  124. driver: ${spring.datasource.druid.master.driver-class-name}
  125. url: ${spring.datasource.druid.master.url}
  126. user: ${spring.datasource.druid.master.username}
  127. password: ${spring.datasource.druid.master.password}
  128. maxConnections: 5
  129. validationQuery: select 0
  130. connection-provider:
  131. class: com.platform.dao.quartz.DruidConnectionProvider
  132. logging:
  133. level:
  134. com.platform: INFO
  135. org.activiti: INFO