博客

Failed to configure a DataSource: ‘url’ attribute… 错误解决

在整理Springboot项目时，出现报错？错误描述如下：

***************************
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

图片如下：

大致意思就是：无法配置DataSource：未指定’url’属性，也无法配置嵌入数据源。

显示很明显，就是你在应用中没有配置datasource的一些相关属性，例如：地址值啊，数据库驱动啊，用户名，密码等配置信息。

解决方法有两种：
**1.**把注解@SpringBootApplication
换成：@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})

2.配置一个application.yml文件（满足springboot所提出的需求）

#SpringBoot配置mysql信息
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql:///mybatisdb?useUnicode=true&characterEncoding=utf8&useSSL=false
    username: root
    password: root
#SpringBoot整合Mybatis配置
mybatis:
  #加载resources下面的映射文件，如：UserMapper.xml文件的位置
  mapper-locations: classpath:*.xml
  #开启驼峰映射
  configuration:
    map-underscore-to-camel-case: true

然后再次运行启动类就能正常运行啦！