spring boot3配置dynamic多数据源，报错url找不到，解决方案

最新推荐文章于 2024-07-29 22:40:28 发布

秋留画lin

最新推荐文章于 2024-07-29 22:40:28 发布

阅读量3.3k

点赞数 16

文章标签： spring boot 数据库 mybatis

本文链接：https://blog.csdn.net/Myr233/article/details/136479229

版权

我在编写springboot项目时尝试使用dynamic-datasource实现多数据库连接

运行项目时报错退出

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

报错如下

***************************
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).
 
 
Process finished with exit code 1

可能存在的问题

1.pom依赖导入情况

我当时遇到的就是这个问题

请注意，如果是springboot3项目，导入的包是下面这样

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot3-starter</artifactId>
    <version>4.3.0</version>
</dependency>
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.9</version>
</dependency>

如果是springboot2项目

<!-- 多数据源 -->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
</dependency>

<!-- druid 官方 starter -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
</dependency>

忘记自己springboot版本，可以在pom文件开头找（如下）

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>3.2.2</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

2.application.yml文件是否写对

按照下面这种格式写

server:
  port: 9090
#    数据库
spring:
  datasource:
    dynamic:
      primary: mysql
      strict: false
      datasource:
        mysql:
          url: jdbc:mysql://localhost:3306/ias_info?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2b8
          username: root
          password: 123
          driver-class-name: com.mysql.cj.jdbc.Driver
        mysql1:
          url: jdbc:mysql://cent:3306/alarm?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2b8
          username: root
          password: 123
          driver-class-name: com.mysql.cj.jdbc.Driver