‘javax.sql.DataSource‘ that could not be found的问题

原创已于 2024-02-06 09:01:34 修改 · 1k 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#java

于 2024-02-04 16:39:18 首次发布

博客指出，最初因未接入数据库，在application.yml配置datasource信息后，启动类中添加了exclude配置。如今程序配置了数据库，需去掉SpringbootApplication注解上的exclude，去掉后问题完美解决。

报错信息如下：
2024-02-04 16:31:14.832  WARN 952 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'databaseConfig': Unsatisfied dependency expressed through field 'dataSource'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'javax.sql.DataSource' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
2024-02-04 16:31:14.835  INFO 952 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2024-02-04 16:31:14.849  INFO 952 --- [           main] ConditionEvaluationReportLoggingListener :

原因：@SpringBootApplication(exclude = {DataSourceAutoConfiguration.class, DataSourceTransactionManagerAutoConfiguration.class}) ，当初是没有接入数据库，但application.yml中配置了加了 datasource信息，所以启动类中加了exclude = {DataSourceAutoConfiguration.class, DataSourceTransactionManagerAutoConfiguration.class}，现程序中配置了数据库，需要把exclude去掉

原因是SpringbootApplication上面的注解需要把 exclude 去掉，去掉后完美解决

@SpringBootApplication
public class SpringbootApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootApplication.class, args);
    }