logging.file=myfilename.log
logging.path=/var/log/mydir

# db1
spring.db1.url=jdbc:mysql://[my_host_ip]/db1
spring.db1.username=my_host_username
spring.db1.password=my_host_password
spring.db1.driver-class-name=com.mysql.jdbc.Driver

# db2
spring.db2.url=jdbc:mysql://[my_host_ip]/db2
spring.db2.username=my_host_username
spring.db2.password=my_host_password
spring.db2.driver-class-name=com.mysql.jdbc.Driver

i) application-production.properties

ii) application-dev.properties

iii) application-test.properties

iv) application-staging.properties

v) application-local.properties

bootRun {
    systemProperties = System.properties
}

./gradlew clean bootRun -Dspring.profiles.active=test

./gradlew clean build -Dspring.profiles.active=test

java -jar myapp.jar  -Dspring.profiles.active=dev

java -jar myapp.jar  -Dspring.profiles.active=staging

Caused by:                          org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: The url cannot be null

Caused by: java.sql.SQLException: The url cannot be null