Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

一句话总结Spring Boot 启动时试图自动配置数据库连接但你在配置文件中既没提供数据库 URL也没启用 H2/HSQLDB 等嵌入式数据库。 一、错误全貌典型日志2026-04-12 12:04:26.318 INFO 21144 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2026-04-12 12:04:26.325 WARN 21144 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.lang.Object.wait(Native Method) java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143) com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:43) 2026-04-12 12:04:26.333 INFO 21144 --- [ main] ConditionEvaluationReportLoggingListener : Error starting ApplicationContext. To display the conditions report re-run your application with debug enabled. 2026-04-12 12:04:26.339 ERROR 21144 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter : *************************** APPLICATION FAILED TO START *************************** Description: Failed to configure a DataSource: url attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Action: Consider the following: If you want an embedded database (H2, HSQL or Derby), please put it on the classpath. If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active). Disconnected from the target VM, address: 127.0.0.1:7870, transport: socket Process finished with exit code 1 二、为什么会发生—— 核心机制解析Spring Boot 的DataSourceAutoConfiguration自动装配机制在启动时会检查spring.datasource.url是否存在若不存在尝试查找 classpath 下是否有嵌入式数据库驱动如 H2、HSQLDB若两者都无 → 抛出此异常。关键点只要你引入了spring-boot-starter-jdbc或spring-boot-starter-data-jpa/mybatis-spring-boot-starter就会触发此检查️ 三、解决方案按场景分类✅ 场景 1你确实需要连接数据库如 MySQL、PostgreSQL步骤 1确保配置文件正确在src/main/resources/application.yml或.properties中添加spring:datasource:url:jdbc:mysql://localhost:3306/your_db?useSSLfalseserverTimezoneUTCusername:rootpassword:your_passworddriver-class-name:com.mysql.cj.jdbc.Driver⚠️常见陷阱YAML 缩进错误必须是 2 空格url写成jdbc-url旧版 MyBatis 需要新版 Spring Boot 用url未添加数据库驱动依赖如mysql-connector-java步骤 2检查依赖Maven 示例dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdscoperuntime/scope/dependency✅ 场景 2你不需要数据库如纯 API 服务、工具类项目方案 A排除数据源自动配置推荐在主启动类上加注解SpringBootApplication(exclude{DataSourceAutoConfiguration.class})publicclassYourApplication{publicstaticvoidmain(String[]args){SpringApplication.run(YourApplication.class,args);}}方案 B临时使用嵌入式数据库仅测试用添加 H2 依赖无需安装数据库dependencygroupIdcom.h2database/groupIdartifactIdh2/artifactIdscoperuntime/scope/dependency✅ 此时即使不配urlSpring Boot 也会自动创建内存数据库。✅ 场景 3多模块项目 / Profile 配置未生效问题表现application-dev.yml中有配置但启动时仍报错原因未激活对应 profile解决在application.properties中指定spring.profiles.activedev或启动时加参数java-jarapp.jar--spring.profiles.activedev❗ 注意bootstrap.yml中设置spring.profiles.active在 Spring Boot 2.4 默认不生效 四、快速自检清单检查项是/否项目是否真的需要数据库☐application.yml中spring.datasource.url是否存在且格式正确☐数据库驱动依赖是否已添加☐当前激活的 profile 是否包含数据库配置☐主启动类是否误排除了必要配置☐ 五、最佳实践建议明确项目依赖若不用 DB不要引入mybatis/jpastarter配置分离开发/测试/生产环境使用不同 profile日志调试启动时加--debug查看自动配置报告IDE 提示在 IntelliJ IDEA 中YAML 文件会高亮无效属性。 结语这个错误看似简单却暴露了 Spring Boot “约定优于配置” 背后的隐式逻辑。理解自动装配机制比记住解决方案更重要。下次再遇到类似问题你就能一眼看穿本质延伸阅读Spring Boot 官方文档 - Data Sources遇到具体配置问题欢迎留言你的pom.xmlapplication.yml片段我来帮你诊断