双数据源配置 mysql+orcale --springboot(数据库通用)

最新推荐文章于 2024-05-03 13:59:27 发布

鲁蛋的机车手

最新推荐文章于 2024-05-03 13:59:27 发布

阅读量468

点赞数 1

文章标签：数据库 mysql spring boot

本文链接：https://blog.csdn.net/m0_56177738/article/details/132457469

版权

双数据源配置

yml文件(数据源配置)

spring:
 application:
   name: ulane-im
 datasource:
   dynamic:
     primary: primaryDB
     strict: false
     datasource:
       primaryDB:
         driver-class-name: oracle.jdbc.OracleDriver
         url: jdbc:oracle:thin:@XXXX.XXX.XX.X:1521:orcl
         username: dmt_test
         password: dmt_test
       xbDB:
         driver-class-name: com.mysql.cj.jdbc.Driver
         url: jdbc:mysql://XXXX.XXX.XX.X:8306/CallCenter?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useSSL=false
         username: drcc
         password: Zk123qwe!@#

CCDB(名称可对应修改)—第一个数据源注解文件

package com.ulane.ulink.im.config;

import com.baomidou.dynamic.datasource.annotation.DS;

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

@Target({ ElementType.TYPE, ElementType.METHOD })
@Retention(RetentionPolicy.RUNTIME)
@DS("xbDB")
public @interface CCDB {
}

PrimaryDB(名称可对应修改)—第二个数据源注解文件

package com.ulane.ulink.im.config;

import com.baomidou.dynamic.datasource.annotation.DS;

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

@Target({ ElementType.TYPE, ElementType.METHOD })
@Retention(RetentionPolicy.RUNTIME)
@DS("primaryDB")
public @interface PrimaryDB {
}

pom文件新增依赖 (+自身数据库依赖)

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>