多数据源

whyclxw

2024-05-23 08642ebd256ed9918db9c4415f63c7025cf3536c

 src/main/resources/config/application-dev.yml

@@ -18,14 +18,22 @@
#数据库
spring:
  datasource:
#    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      db-type: POSTGRE_SQL
    driver-class-name: com.highgo.jdbc.Driver
#    url: jdbc:dm://localhost:5236/SYSDBA?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
    url: jdbc:highgo://localhost:5866/test?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
    username: sysdba
    password: Lmx&8688139
    dynamic:
      primary: master # 默认使用mater库
      strict: false   # 不使用严格模式
      datasource:
        master:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: com.highgo.jdbc.Driver
      #    url: jdbc:dm://localhost:5236/SYSDBA?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
          url: jdbc:highgo://192.168.10.183:5866/highgo?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
          username: sysdba
          password: Lmx&8688139
        db2:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: org.sqlite.JDBC
          url: jdbc:sqlite:E:\2软件下载包\easydarwin\EasyDarwin-windows-8.2.2-24031216\data\db\EasyDarwin.db?date_string_format=yyyy-MM-dd HH:mm:ss
    #      url: jdbc:sqlite:\2软件下载包\easydarwin\EasyDarwin-windows-8.2.2-24031216\data\db\EasyDarwin.db?date_string_format=yyyy-MM-dd HH:mm:ss
    maxIdel: 60
    initialPoolSize: 2
    minPoolSize: 5