首先yml配置文件添加数据库连接配置:
datasource:
    dynamic:
      datasource:
        master:
          url: jdbc:mysql://数据库地址?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
          username: 账号
          password: 密码
          driver-class-name: com.mysql.cj.jdbc.Driver
          hikari:
            minimum-idle: 5
            idle-timeout: 18000
            maximum-pool-size: 10
            max-lifetime: 1800000
            connection-test-query: SELECT 1
            connection-timeout: 30000
            auto-commit: true
          type: com.zaxxer.hikari.HikariDataSource
        sqlserver:
          url: jdbc:sqlserver://数据库地址;SelectMethod=cursor;DatabaseName=ecology
          username: 账号
          password: 密码
          driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
启动类StartupApplication.java
添加排除类(重要)
@SpringBootApplication(exclude = {
    DruidDataSourceAutoConfigure.class
}

Logo

DAMO开发者矩阵,由阿里巴巴达摩院和中国互联网协会联合发起,致力于探讨最前沿的技术趋势与应用成果,搭建高质量的交流与分享平台,推动技术创新与产业应用链接,围绕“人工智能与新型计算”构建开放共享的开发者生态。

更多推荐