jdbcUrl is required with driverClassName.

小渣渣

Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.

Sun Sep 09 10:38:10 CST 2018
There was an unexpected error (type=Internal Server Error, status=500).
nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.IllegalArgumentException: jdbcUrl is required with driverClassName. ### The error may exist in com/itsvse/test/mapper/AccountMapper.java (best guess) ### The error may involve com.itsvse.test.mapper.AccountMapper.selectAll ### The error occurred while executing a query ### Cause: java.lang.IllegalArgumentException: jdbcUrl is required with driverClassName.

在Spring Boot 1.5.x之前，多数据源编程已经有很多教程和例子了

但是在升级到Spring Boot 2.0后，一些配置及用法有了变化，如果不小心就会碰到“jdbcUrl is required with driverClassName.”的错误。

解决办法：

在配置文件中使用spring.datasource.jdbc-url，而不是通常使用的spring.datasource.url。

jdbc-url: jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false
username: itsvse
password: 123456

driver-class-name属性可以删除！

spring.datasource.jdbc-url和spring.datasource.url的区别，网上没有一个能解释清楚的，我自己的理解如下：

有了jdbc-url，就不需要driver-class-name属性了，Spring Boot将根据spring.datasource.jdbc-url属性值找出默认的驱动程序类名称。