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

wsfw014

已于 2024-02-06 09:01:34 修改

阅读量690

点赞数 11

文章标签： java

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

本文链接：https://blog.csdn.net/wsfw014/article/details/136028588

版权

报错信息如下：
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);
    }