SpringJPA+Druid配置多数据源

wtopps

已于 2024-08-07 17:23:03 修改

阅读量552

点赞数 2

分类专栏： Spring Boot 文章标签： springjpa spring多数据源 druid多数据源 mysql

于 2024-08-07 17:21:25 首次发布

本文链接：https://blog.youkuaiyun.com/wtopps/article/details/140996674

版权

application.yml

spring:
  datasource:
    druid:
      d1:
        url: jdbc:mysql://xxx
        username: xxx
        password: xxx
        driverClassName: com.mysql.jdbc.Driver
        initial-size: 1
        max-active: 1
        min-idle: 1
        test-on-borrow: true
        validation-query: select 1
        min-evictable-idle-time-millis: 500000
        max-evictable-idle-time-millis: 600000
      d2:
        url: jdbc:mysql://xxx
        username: xxx
        password: xxx
        driverClassName: com.mysql.jdbc.Driver
        initial-size: 1
        max-active: 1
        min-idle: 1
        test-on-borrow: true
        validation-query: select 1
        connection-init-sqls: SET NAMES utf8mb4

多数据源配置

import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import