Spring:未能配置DataSource：“url”属性未指定，也无法配置嵌入式数据源
Spring:未能配置DataSource：“url”属性未指定，也无法配置嵌入式数据源
提问于 2022-05-25 19:33:50
一直致力于与Spring一起开发微服务。我成功地写了几篇，然而，最后一篇是令人费解的，我不知道为什么。
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我的application.properties：
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/Sat
spring.datasource.username=user_auto
spring.datasource.password=(别担心，密码包含在application.properties中)
已经尝试添加和删除：
spring.autoconfigure.exclude=org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration
我的pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.6.8</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.sat.serviciodescargamasiva.automatizador</groupId>
<artifactId>automatizador</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>automatizador</name>
<description>Servicio de automatizador del SAT</description>
<properties>
<java.version>11</java.version>
<spring-cloud-gcp.version>3.2.1</spring-cloud-gcp.version>
<spring-cloud.version>2021.0.2</spring-cloud.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.google.cloud</groupId>
<artifactId>spring-cloud-gcp-starter-storage</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-validation</artifactId>
</dependency>
<dependency>
<groupId>javax.validation</groupId>
<artifactId>validation-api</artifactId>
<version>2.0.1.Final</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.validation</groupId>
<artifactId>validation-api</artifactId>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-dependencies</artifactId>
<version>${spring-cloud.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
<dependency>
<groupId>com.google.cloud</groupId>
<artifactId>spring-cloud-gcp-dependencies</artifactId>
<version>${spring-cloud-gcp.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.yml</include>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>我的主语是：
@SpringBootApplication公共类AutoApplication {
public static void main(String[] args) {
SpringApplication.run(AutoApplication.class, args);
}}
我正在用IntelliJ编写我的代码。救命，我不知道该怎么办！我想我已经找不到解决办法了。
提前谢谢你的时间！
回答 3
Stack Overflow用户
发布于 2022-05-25 19:39:02
尝试删除此依赖关系：
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>我不确定它是否可以与mysql驱动程序相结合：
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>您也可以尝试更改这个：
spring.datasource.driver-class-name -> spring.datasource.driverClassName或者，根据白龙，将其更改为：
spring.datasource.driver-class-name=com.mysql.cj.jdbc.DriverStack Overflow用户
发布于 2022-10-12 18:35:34
我也面临着同样的问题。我也尝试了在答案中给出的不同的解决方案，但是对我来说没有什么效果。最后，我发现问题在于pom.xml (如果您的依赖关系管理器是maven)。我在那里设置了下面的块&移除它之后，问题就解决了。
<resources>
<resource>
<directory>/src/main/resources</directory>
</resource>
<resource>
<directory>../src/main/resources</directory>
</resource>
</resources>问题是spring自动配置无法检测到正确的资源文件夹。删除这将不会对您的程序造成伤害。
Stack Overflow用户
发布于 2022-07-20 19:46:26
检查您的pom.xml文件并确保其打包为war。(它对我有用:)
<packaging>war</packaging>页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/72383247
复制相关文章
相似问题
腾讯云开发者
