How to pass database name explicitly in Spring Boot Configuration?

Question

I've a Spring Boot application of mine, which connects to a Postgres database. I've specified in application.properties the datasource url as -

spring.datasource.url=jdbc:postgresql://< server ip here >:5432/mydb

The jdbc url (jdbc:postgresql://< server ip here >:5432/) is actually stored in a separate external location which my application is able to read. Therefore, I want to specify only the database name in my properties file.

I don't want to pass the database name as some environment variable since it's not going to change.

I'm stuck at this point for quite some time now, how can I achieve the same?

wherever jdbc url (jdbc:postgresql://< server ip here >:5432/ is sored just append database name to that url string. If it is not going to change then you shouldn't face issues after appending database name to url. — rdj7
– rdj7, Commented Jun 4, 2018 at 7:31

Vikram Saini · Accepted Answer · 2018-06-04 05:18:52Z

2

Add this in your application.properties file

spring.jpa.hibernate.ddl-auto=create\update\none
spring.datasource.url=jdbc:postgresql://host:port/db
spring.datasource.username=username
spring.datasource.password=password

answered Jun 4, 2018 at 5:18

Vikram Saini

2,7521 gold badge21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1854373 Over a year ago

Vikram...By specifying spring.datasource.url=jdbc:postgresql://host:port/db .. Application works. Please read the question again to know how exactly I want to implement.

vszholobov · Accepted Answer · 2022-11-19 04:52:05Z

2

Have you tried using ${var} syntax like:

spring.datasource.url=jdbc:postgresql://${server-ip}:5432/mydb

See:

edited Nov 19, 2022 at 4:52

vszholobov

2,3931 gold badge14 silver badges24 bronze badges

answered Jun 4, 2018 at 5:23

Jean Marois

1,65012 silver badges20 bronze badges

Comments

user1854373 · Accepted Answer · 2018-06-05 05:04:00Z

0

I finally implemented it this way.

Specified only database name in my application and created Datasource bean in a separate Spring Boot application (so that it can be reused across other projects as well).

answered Jun 5, 2018 at 5:04

user1854373

831 gold badge3 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to pass database name explicitly in Spring Boot Configuration?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related