Скачать или смотреть Spring Boot - Failed to configure a Data Source: 'url' attribute is not specified

Hello Everyone, I m sharing below step by step procedure followed in this video.

If you like the content, please like the video, subscribe to the channel.

1. Overview
In this video, we’ll discuss what causes and what resolves the “Failed to configure a DataSource” error on a Spring Boot project.
We’ll resolve the issue using two different approaches:
a. Defining the data source
b. Disabling the auto-configuration of the data source

2. Suppose we have a Spring Boot project, and we’ve added the spring-data-starter-jpa dependency and a MySQL JDBC driver to our pom.xml

3. The Cause
Spring Boot auto-configuration tries to configure the beans automatically based on the dependencies added to the classpath.

And since we have the JPA dependency on our classpath, Spring Boot tries to automatically configure a JPA DataSource. The problem is that we haven’t given Spring the information it needs to perform the auto-configuration.

4. Solutions
4.1. Define the DataSource Using Properties Or we can provide the data source properties in application.yml
spring.datasource.url=jdbc:mysql://localhost:3306/myDb
spring.datasource.username=user1
spring.datasource.password=pass
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

or

spring:
datasource:
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/first_schema
username: root
password: root

4.2. Define the DataSource Programmatically

@Configuration
public class DataSourceConfig {
@Bean
public DataSource getDataSource() {
return DataSourceBuilder.create()
.driverClassName("com.mysql.cj.jdbc.Driver")
.url("jdbc:mysql://localhost:3306/myDb")
.username("user1")
.password("pass")
.build();
}
}

4.3. Exclude DataSourceAutoConfiguration
Now, there are a few ways that we can exclude this from the auto-configuration.
a. First, we can disable the auto-configuration using the spring.autoconfigure.exclude property in our application.properties file
spring.autoconfigure.exclude=org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration

b. And we can do the same using our application.yml file
spring:
autoconfigure:
exclude:
org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration
c. we can use the exclude attribute on our @SpringBootApplication or @EnableAutoConfiguration annotation:
@SpringBootApplication(exclude={DataSourceAutoConfiguration.class})
5. Conclusion
we’ve seen what causes the “Failed to configure a DataSource” error.
First, we fixed the issue by defining the data source.
Next, we discussed how to work around the issue without configuring the data source at all.