spring boot jdbc Failed to determine a suitable driver class

川长思鸟来 2022-10-02 00:42 22阅读 0赞

[2019独角兽企业重金招聘Python工程师标准>>> ][2019_Python_] ![hot3.png][]

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate \[com.zaxxer.hikari.HikariDataSource\]: Factory method 'dataSource' threw exception; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class  
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~\[spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE\]  
    at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:622) ~\[spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE\]  
    ... 79 common frames omitted  
Caused by: org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class  
    at org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.determineDriverClassName(DataSourceProperties.java:236) ~\[spring-boot-autoconfigure-2.1.2.RELEASE.jar:2.1.2.RELEASE\]  
    at org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.initializeDataSourceBuilder(DataSourceProperties.java:176) ~\[spring-boot-autoconfigure-2.1.2.RELEASE.jar:2.1.2.RELEASE\]  
    at org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration.createDataSource(DataSourceConfiguration.java:43) ~\[spring-boot-autoconfigure-2.1.2.RELEASE.jar:2.1.2.RELEASE\]  
    at org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari.dataSource(DataSourceConfiguration.java:83) ~\[spring-boot-autoconfigure-2.1.2.RELEASE.jar:2.1.2.RELEASE\]  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~\[na:1.8.0\_181\]  
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~\[na:1.8.0\_181\]  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~\[na:1.8.0\_181\]  
    at java.lang.reflect.Method.invoke(Unknown Source) ~\[na:1.8.0\_181\]  
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~\[spring-beans-5.1.4.RELEASE.jar:5.1.4.RELEASE\]  
    ... 80 common frames omitted

问题分析：

在spring boot配置文件application.yml中我的配置是:

spring:

datasource:

db-name:

url:

username:

password:

...

spring boot org.springframework.boot.autoconfigure.jdbc.DataSourceProperties无法找到datasource下的定义的db-name数据库链接

解决方法：

方法一：