项目场景:
IDEA2023
IDEA2023
spring boot 2.6.13
MySql 5.7.27
pom文件依赖:
<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>
<version>3.0.0</version>
</dependency>
<!-- 热部署 -->
<!-- 在服务器运行时重新部署项目 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId><!-- 可以防止将devtools依赖传递到其他模块中 -->
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>8.2.0</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.9</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13.1</version>
<scope>test</scope>
</dependency>
yml文件:
datasource:
url: jdbc:mysql://localhost:3306/****?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=CONVERT_TO_NULL
username: ****
password: ****
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
***为自定义内容
问题描述
报错:
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
原因分析:
翻译:这个错误通常是由于在配置文件中没有正确指定数据库连接URL导致的。请确保您的配置文件中包含了正确的数据库连接URL。
思路:
- 检查数据库配置处的url及用户名密码等信息
- 检查pom的依赖是否添加完全
- 查看“target”目录下是否有配置文件,如图:
如果没有,可以在pom.xml的resources标签中加上这段代码
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.prooerties</include>
<include>**/*.xml</include>
<include>**/*.yml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
4.启动时加载本不需要加载的数据源,解决方法如下
在@SpringBootApplication处加上(exclude = DataSourceAutoConfiguration.class)
5.以上方法仍没有解决,那再看看yml文件,可能是这个文件的配置没有生效导致的,最终经过他人帮助检查,发现真正的问题是我的yml文件多了Tab
错误的:
正确的:
希望以上总结能对大家有帮助!