springboot+mysql+sql server+mybatis-plus 多数据源使用

最新推荐文章于 2024-04-24 15:51:53 发布

首席令狐冲

最新推荐文章于 2024-04-24 15:51:53 发布

阅读量380

点赞数

文章标签： mybatis mysql spring boot

本文链接：https://blog.csdn.net/java_csdn_w/article/details/129859037

版权

长话短说，非常简单好用！

1. maven依赖

        <!--Mysql+druid+mybatisplus-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.11</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.0</version>
        </dependency>
        <!--mybatis-plus多数据源配置所需依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.5.0</version>
        </dependency>

        <!--sqlserver-->
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>sqljdbc4</artifactId>
            <version>4.0</version>
        </dependency>

2. 配置文件

spring:
  datasource:
    dynamic:
      # 设置默认的数据源或者数据源组,默认值即为master
      primary: db1
      # 严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
      strict: true
      datasource:
        db1:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: com.mysql.jdbc.Driver
          url: jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8
          username: root
          password: root
        db2:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
          url: jdbc:sqlserver://localhost:1433;DatabaseName=krtswjc
          username: sa
          password: root

3. mapper中使用@DS()注解

db1是配置文件里mysql的

db2是配置文件里sql server的
在这里插入图片描述

4. idea 连接sql server 报错

[08S01] The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”. ClientConnectionId:bbc87a2f-5ec2-4c8e-bdb9-aaff6297891f
unable to find valid certification path to requested target.
在这里插入图片描述
解决办法：
url后面拼个这 trustServerCertificate=true