Spring boot not picking value from environment variable in windows

Question

I have declared db url, db user and db password in application.properties like this

spring.datasource.url=${SPRING_DB_URL}
spring.datasource.username=${SPRING_DB_USER}
spring.datasource.password=${SPRING_DB_PASS}

This works in Ubuntu 16.04 but it is not working in windows 7, and the web application is not starting and in logs, it is showing,

Driver com.microsoft.sqlserver.jdbc.SqlServerDriver claims not to accept jdbcurl, ${SPRING_DB_URL}

I tried setting the environment variable with key like this, spring_datasource_url but that too is not working.

the app is build as war file

Why this works in Ubuntu but not in Windows 7?

@MartinChoraine, it is a war file and deployed using tomcat manager — Sony
– Sony, Commented Jul 20, 2019 at 13:31

Ryuzaki L · Accepted Answer · 2019-07-20 13:25:31Z

2

From Externalized Configuration So use the key in upper case letters with combination of underscore if needed

If you use environment variables rather than system properties, most operating systems disallow period-separated key names, but you can use underscores instead (for example, SPRING_CONFIG_NAME instead of spring.config.name).

answered Jul 20, 2019 at 13:25

Ryuzaki L

40.4k14 gold badges81 silver badges111 bronze badges

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

3 Comments

Sony Over a year ago

so you are saying that I should use SPRING_DATASOURCE_URL

Ryuzaki L Over a year ago

Yes i believe, give a chance @Sony

BSchnitzel Over a year ago

Little late here I did all the above then restarted my IDE (Intellij) worked great

Collectives™ on Stack Overflow

Spring boot not picking value from environment variable in windows

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related