How to Fix Datasource Error in Spring Boot Quickly

A datasource error in Spring Boot usually happens because the database connection settings in application.properties or application.yml are missing or incorrect. Fix it by providing the correct spring.datasource.url, spring.datasource.username, and spring.datasource.password properties and ensuring the database driver dependency is included.

Why This Happens

This error occurs because Spring Boot cannot find or connect to the database. This usually happens when the datasource URL, username, or password is missing or wrong in your configuration file. Also, if the required database driver dependency is not added, Spring Boot cannot create a datasource.

properties

spring.datasource.url=jdbc:mysql://localhost:3306/mydb
spring.datasource.username=
spring.datasource.password=

# Missing username and password cause connection failure

Output

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' ...
Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

The Fix

Update your application.properties or application.yml with the correct database URL, username, and password. Also, add the proper database driver dependency in your pom.xml or build.gradle. This allows Spring Boot to create a working datasource and connect to your database.

properties

spring.datasource.url=jdbc:mysql://localhost:3306/mydb
spring.datasource.username=root
spring.datasource.password=secret

# Add MySQL driver dependency in pom.xml
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <scope>runtime</scope>
</dependency>

Output

Application started successfully with datasource connected to MySQL database.

Prevention

Always double-check your datasource configuration before running your app. Use environment variables or Spring Boot profiles to manage sensitive data like passwords safely. Keep your database driver dependencies up to date and consistent with your database version. Use Spring Boot's spring-boot-starter-data-jpa starter to simplify setup.

Related Errors

Other common datasource errors include:

• Driver class not found: Add the correct driver dependency.
• Connection refused: Check if the database server is running and accessible.
• Invalid credentials: Verify username and password.

Key Takeaways

Always provide correct datasource URL, username, and password in configuration.

Include the proper database driver dependency to enable connection.

Use Spring Boot starters to simplify datasource setup.

Manage sensitive data securely using environment variables or profiles.

Check database server availability if connection errors persist.