增加三场数字化

‘liusuyi’

2023-09-18 c4dfbde4b685dba6fd541e5fe6b833cbd009229c

 src/main/resources/application-dev.yml

@@ -36,6 +36,34 @@
        # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
        connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
      datasource:
        master:
          url: jdbc:postgresql://192.168.2.15:5432/ry-vue
          username: postgres
          password: postgres
          driver-class-name: org.postgresql.Driver
          druid: # 配置multi-datasource1 数据源连接池参数
            # 连接池的配置信息
            # 初始化大小，最小，最大
            initial-size: 2
            min-idle: 2
            maxActive: 2
            # 配置获取连接等待超时的时间
            maxWait: 600000
            # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
            timeBetweenEvictionRunsMillis: 60000
            # 配置一个连接在池中最小生存的时间，单位是毫秒
            minEvictableIdleTimeMillis: 300000
            validationQuery: SELECT 1
            testWhileIdle: true
            testOnBorrow: false
            testOnReturn: false
            # 打开PSCache，并且指定每个连接上PSCache的大小
            poolPreparedStatements: true
            maxPoolPreparedStatementPerConnectionSize: 20
            # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
            filters: stat,wall,slf4j
            # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
            connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
        oracle:
          url: jdbc:oracle:thin:@//112.98.126.2:21521/orcl
          username: c##ard_user
@@ -64,34 +92,6 @@
            filters: stat,wall,slf4j
            # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
            connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
        postgres:
          url: jdbc:postgresql://192.168.1.55:5432/ry-vue
          username: postgres
          password: postgres
          driver-class-name: org.postgresql.Driver
          druid: # 配置multi-datasource1 数据源连接池参数
            # 连接池的配置信息
            # 初始化大小，最小，最大
            initial-size: 2
            min-idle: 2
            maxActive: 2
            # 配置获取连接等待超时的时间
            maxWait: 600000
            # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
            timeBetweenEvictionRunsMillis: 60000
            # 配置一个连接在池中最小生存的时间，单位是毫秒
            minEvictableIdleTimeMillis: 300000
            validationQuery: SELECT 1
            testWhileIdle: true
            testOnBorrow: false
            testOnReturn: false
            # 打开PSCache，并且指定每个连接上PSCache的大小
            poolPreparedStatements: true
            maxPoolPreparedStatementPerConnectionSize: 20
            # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
            filters: stat,wall,slf4j
            # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
            connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000

  # netty配置
  netty:
@@ -102,10 +102,10 @@
      enabled: false
  # mqtt配置
  mqtt:
    host: tcp://192.168.1.55:1883
    host: tcp://192.168.2.15:1883
    clientId: cc3
    username: admin
    password: xzx12345
    password: admin
    topic: tube
    timeout: 100
    keepalive: 60
@@ -115,7 +115,7 @@
    url: http://iot.zhdk.net:8090/Warning/GetWarning?userName=cy4oil
  # minio配置
  minio:
    endpoint: http://192.168.1.15:9001
    endpoint: http://192.168.2.15:9001
    accessKey: admin
    secretKey: xzx12345
# mybatis配置
@@ -127,7 +127,7 @@
  level:
    hikSdk: info
    mqtt: debug
    netty: info
    netty: debug
    external: info
    camera: info
    tube: info