application-db-kingbase.yml

spring:
  datasource:
    druid:
      #监控统计拦截的filters
      filters: stat
      web-stat-filter:
        enabled: true #是否启用StatFilter默认值true
        url-pattern: /*
        exclusions: /druid/*,*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico
        session-stat-enable: true
        session-stat-max-count: 10
      stat-view-servlet:
        # 是否启用statViewServlet配置
        enabled: true
        # 访问监控页面
        url-pattern: "/druid/*"
        # 禁止手动重置监控数据
        reset-enable: false
        # 设置监控页面的登陆名
        login-username: root
        # 设置监控页面的登陆密码
        login-password: root
        allow:
      #慢SQL
      filter:
        stat:
          merge-sql: true
          slow-sql-millis: 10000
          log-slow-sql: true
    dynamic:
      primary: kingbase
      strict: false
      druid:
        #配置初始化大小/最小/最大
        initial-size: 10
        min-idle: 10
        max-active: 100
        #获取连接等待超时时间
        max-wait: 60000
        #间隔多久进行一次检测，检测需要关闭的空闲连接
        time-between-eviction-runs-millis: 60000
        #一个连接在池中最小生存的时间
        min-evictable-idle-time-millis: 30000
        validation-query: SELECT 'x' FROM DUAL
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        #打开PSCache，并指定每个连接上PSCache的大小。oracle设为true，mysql设为false。分库分表较多推荐设置为false
        pool-prepared-statements: false
        max-pool-prepared-statement-per-connection-size: 20
        filters: stat
      datasource:
        kingbase:
          driver-class-name: com.kingbase8.Driver
          url: jdbc:kingbase8://kbp-my-ahpt.cofco.com:54322/my_ahpt?currentSchema=public&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
          schema: public
          username: my_ahpt
          password: ^RTFua88Q9!txMQD
  #          druid:
  #            public-key: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIUIgqiCXvhtN0/BzDw0Q5hrTBYZe1/YzAgtVGr4TLtPqlJDecGjgxQw0A51phIOp8Z4NRo9V5BsH62RPIKwI10CAwEAAQ==