Last updated: 2023-01-21

  1. Learn
  2. Next Steps
  3. Database Configuration

Configuring the database connection of your Spring Boot app

In order to configure our database connection, we could simply edit the application.yml. If there are already environment variables in place (the part before the first colon, e.g. JDBC_DATABASE_URL), we don't need to change anything here. Otherwise we adjust the fallback behind the colon - whatever approach we prefer.

Adjusting our database connection

Adjusting our database connection

Using the local profile

If we don't want to commit our local database settings to the version control, there is also a nice way around it. In the run configuration in IntelliJ we already entered -Dspring.profiles.active=local and thus the profile "local" is automatically active. Therefore we can also store our database settings in a new file application-local.yml.

Adding application-local.yml

Adding application-local.yml

This file is automatically picked up by Spring Boot when the application starts with the corresponding profile. Since this file is listed in the .gitignore, it is not added to git and can be edited separately by each developer. Instead we may add another file application-local.example and add it to our repository, ready to be copied and customized.

Further readings

Connecting Spring Boot to a database
Profiles in Spring Boot