How to overwrite the db url on jar run command

Question

I am using invalid jdbc connection and mentioned in app properties.But I am trying to overwrite that, on that time of running JAR file.

java -jar proj.jar --spring.datasource.url=jdbc:ucanaccess:db.accdb; 

note, jar and db are same location. I dont want to place jar and db in different locations.

Answer 1

Try like :
Method 1: Using system properties

java -Dspring.datasource.url=jdbc:ucanaccess:db.accdb -jar proj.jar

Method 2: Using environment variables

Set jdbc connection url as SPRING_DATASOURCE_URL environment variable.

windows:

set SPRING_DATASOURCE_URL=jdbc:ucanaccess:db.accdb
java -jar proj.jar

Mac/Linux:

export SPRING_DATASOURCE_URL=jdbc:ucanaccess:db.accdb
java -jar proj.jar