springboot 2 Hikari 多数据源配置问题（dataSourceClassName or jdbcUrl is required）

springboot 2 Hikari 多数据源配置问题（dataSourceClassName or jdbcUrl is required）

最近在项目中想试一下使用 Hikari 连接池，以前用的是阿里的 Druid，框架是 Spring MVC，xml配置文件方式注入的 Bean，现在换成 Spring Boot 之后，总遇到一些奇怪的问题，问题的根源是在于自己是个半桶水。

好了，先来看看 application.yml 配置文件：

spring:
  jpa:
    show-sql: true
  datasource:
    url: jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=true
    username: root
    password: root
    type: com.zaxxer.hikari.HikariDataSource
    hikari:
      maximum-pool-size: 20
      max-lifetime: 30000
      idle-timeout: 30000
      data-source-properties:
        prepStmtCacheSize: 250
        prepStmtCacheSqlLimit: 2048
        cachePrepStmts: true
        useServerPrepStmts: true
    slave:
      url: jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=true
      username: root
      password: root
      type: com.zaxxer.hikari.HikariDataSource
      hikari:
        maximum-pool-size: 20
        max-lifetime: 30000
        idle-timeout: 30000
        data-source-properties:
          prepStmtCacheSize: 250
          prepStmtCacheSqlLimit: 2048
          cachePrepStmts: true
          useServerPrepStmts: true
复制代码

数据源配置文件：

package org.seckill.config;
import com.zaxxer.hikari.HikariDataSource;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.boot.jdbc.DataSourceBuilder;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.Primary;

import org.springframework.jdbc.core.JdbcTemplate;
import javax.sql.DataSource;

import java.util.HashMap;

import java.util.Map;
/**


数据源配置



@author jeftom


@date 2019-04-14 12:03


@since 1.0.0

*/

@Configuration

public class DataSourceConfig {

private final static Logger LOGGER = LoggerFactory.getLogger(DataSourceConfig.class);
@Bean(name = "masterDataSource")

@ConfigurationProperties(prefix = "spring.datasource")

public DataSource masterDataSource(DataSourceProperties properties) {

LOGGER.info("init master data source：{}", properties);

return DataSourceBuilder.create().build();

}
@Bean(name = "slaveDataSource")

@ConfigurationProperties(prefix = "spring.datasource.slave")

public DataSource slaveDataSource(DataSourceProperties properties) {

LOGGER.info("init slave data source：{}", properties);

return DataSourceBuilder.create().build();

}
@Bean

@Primary

public DynamicDataSource dataSource(DataSource masterDataSource, DataSource slaveDataSource) {

Map<String, DataSource> targetDataSources = new HashMap<>();

targetDataSources.put(DataSourceEnum.MASTER.getName(), masterDataSource);

targetDataSources.put(DataSourceEnum.SLAVE.getName(), slaveDataSource);
 <span class="hljs-built_in"><span class="hljs-built_in">return</span></span> new DynamicDataSource(masterDataSource, targetDataSources);

}

}

复制代码

报错信息：