Home > front end >  How to properly use Postgres-style url in Spring Boot application.yml
How to properly use Postgres-style url in Spring Boot application.yml

Time:07-29

I'm trying to figure out if there is a way to configure Spring datasource using a single string that contains all credentials:

postgres://username:secret@localhost/somedb

By far I see that spring.datasource always requires username and password properties to be defined separately and url property to start with jdbc:. Is there some other way to configure DB connection and use Postgres single string url?

BTW, this url works fine in Python/Django and GoLang.

CodePudding user response:

As the documentation specifies, spring.datasource.url is the JDBC URL of the database.

The format of the JDBC url is driver specific, in your case Postgresql JDBC Driver.

You can specify the username and password of your database inside the JDBC url as connection properties. This is the general format:

jdbc:postgresql://host:port/database?properties

So, in your case: jdbc:postgresql://localhost/somedb?user=username&password=secret

  • Related