Dynamic-datasource加载报错:jdbcUrl is required with driverClassName

问题描述

在给项目配置动态数据源时使用的时

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

使用的配置文件如下

spring:
	datasource:
	    dynamic:
	      primary: center-bill
	      datasource:
	        master:
	          type: com.zaxxer.hikari.HikariDataSource
	          driver-class-name: com.mysql.cj.jdbc.Driver
	          jdbc-url: jdbc:mysql://127.127.127.1:3306/center_bill?characterEncoding=utf8&useSSL=false&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
	          password: '*******'
	          username: dev_rw
	          maximumPoolSize: 10 # Default: 10
	          poolName: center-bill_master
	        slave0:
	          type: com.zaxxer.hikari.HikariDataSource
	          driver-class-name: com.mysql.cj.jdbc.Driver
	          jdbc-url: jdbc:mysql://127.128.122.2:3306/center_bill?characterEncoding=utf8&useSSL=false&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
	          password: '*********'
	          username: dev_rw
	          maximumPoolSize: 10 # Default: 10
	          poolName: center-bill_slave0

运行时代码报错:

Caused by: java.lang.IllegalArgumentException: jdbcUrl is required with driverClassName.
	at com.zaxxer.hikari.HikariConfig.validate(HikariConfig.java:1000)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:77)
	at com.baomidou.dynamic.datasource.creator.HikariDataSourceCreator.createDataSource(HikariDataSourceCreator.java:47)
	at com.baomidou.dynamic.datasource.creator.DataSourceCreator.createHikariDataSource(DataSourceCreator.java:165)
	at com.baomidou.dynamic.datasource.creator.DataSourceCreator.createDataSource(DataSourceCreator.java:95)
	at com.baomidou.dynamic.datasource.provider.AbstractDataSourceProvider.createDataSourceMap(AbstractDataSourceProvider.java:45)
	at com.heytea.service.order.admin.config.DynamicDataSourceConfig$1.loadDataSources(DynamicDataSourceConfig.java:41)
	at com.baomidou.dynamic.datasource.DynamicRoutingDataSource.afterPropertiesSet(DynamicRoutingDataSource.java:254)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792)
	... 181 common frames omitted

问题分析

这个问题看起来很明显，加载driverClassName时缺少jdbcUrl，但是我们的配置中的jdbcUrl明明有配置，这种情况只能是直接进源码看了，经过一番操作，找到了这个参数实在创建Hikari数据源时使用的类名:HikariDataSourceCreator，加载时的代码为:

@Data
@AllArgsConstructor
public class HikariDataSourceCreator {

    private HikariCpConfig hikariCpConfig;

    public DataSource createDataSource(DataSourceProperty dataSourceProperty) {
        HikariConfig config = dataSourceProperty.getHikari().toHikariConfig(hikariCpConfig);
        config.setUsername(dataSourceProperty.getUsername());
        config.setPassword(dataSourceProperty.getPassword());
        config.setJdbcUrl(dataSourceProperty.getUrl());
        config.setDriverClassName(dataSourceProperty.getDriverClassName());
        config.setPoolName(dataSourceProperty.getPoolName());
        return new HikariDataSource(config);
    }
}

问题大家可能已经发现了，这里报错的原因就是这行代码
config.setJdbcUrl(dataSourceProperty.getUrl());
取的配置中的Url赋值给jdbcUrl,所以配置中应该配的是url而不是jdbc-url

问题处理

将配置中的jdbc-url改为url问题即可解决。

写在后面

dyncmic-datasource之前看到好像是不支持hikari连接池的，因为hikari连接池的url使用的是jdbc-url，但是dyncmic-datasource为了保持架构配置的统一，全部使用了url属性，但是这个数据源的加载是hikari完成的，所以配置有问题，报的错误就是jdbcUrl的错误。