quarkus: Problem with environment variables when using multiple datasources

Describe the bug I belive there’s a problem with environment variables when using multiple datasources. Looks like Quarkus isn’t recognizing the environment variables that have datasource namespaces, like quarkus.datasource."users".jdbc.url . Or perhaps I’m not passing the variables correctly.

Expected behavior Quarkus should read the environment variables with the datasource namespace.

Actual behavior Quarkus isn’t reading reading the environment variables with the datasource namespace.

To Reproduce

1. Build the project with mvn clean package
2. Export the environment variables
3. Execute the runnable jar.
4. Quarkus says that the variables weren’t defined.

Configuration

quarkus.datasource."users".db-kind=postgresql
quarkus.datasource."users".jdbc.url=${POSTGRESQL_URL:prod-url}
quarkus.datasource."users".username=${POSTGRESQL_USERNAME:prod-username}
quarkus.datasource."users".password=${POSTGRESQL_PASSWORD:prod-password}
quarkus.hibernate-orm."users".datasource=users
quarkus.hibernate-orm."users".packages=com.helesto.models.users
quarkus.hibernate-orm."users".database.generation = none
quarkus.hibernate-orm."users".sql-load-script=no-file
quarkus.hibernate-orm."users".log.sql=false

quarkus.datasource."orders".db-kind=mariadb
quarkus.datasource."orders".jdbc.url=${MARIADB_URL:prod-url}
quarkus.datasource."orders".username=${MARIADB_USERNAME:prod-username}
quarkus.datasource."orders".password=${MARIADB_PASSWORD:prod-password}
quarkus.hibernate-orm."orders".datasource=orders
quarkus.hibernate-orm."orders".packages=com.helesto.models.orders
quarkus.hibernate-orm."orders".database.generation=none
quarkus.hibernate-orm."orders".sql-load-script=no-file
quarkus.hibernate-orm."orders".log.sql=false

Environment:

• uname -a: Linux machine 5.4.0-52-generic #57-Ubuntu SMP Thu Oct 15 10:57:00 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

• java -version: openjdk version “11.0.8” 2020-07-14 OpenJDK Runtime Environment (build 11.0.8+10-post-Ubuntu-0ubuntu120.04) OpenJDK 64-Bit Server VM (build 11.0.8+10-post-Ubuntu-0ubuntu120.04, mixed mode, sharing)

• Quarkus version or git rev: 1.9.0.Final

• mvnw --version: Apache Maven 3.6.3 (cecedd343002696d0abb50b32b541b8a6ba2883f) Maven home: /home/helesto/.m2/wrapper/dists/apache-maven-3.6.3-bin/1iopthnavndlasol9gbrbg6bf2/apache-maven-3.6.3 Java version: 11.0.8, vendor: Ubuntu, runtime: /usr/lib/jvm/java-11-openjdk-amd64 Default locale: en_US, platform encoding: UTF-8 OS name: “linux”, version: “5.4.0-52-generic”, arch: “amd64”, family: “unix”

Test with my project - happy end

It’s possible to reproduce this problem with a project I created to test the use of multiple databases:

• https://github.com/felipewind/poc-quarkus-multiple-datasources

With this project, I did the following test:

1. Build it with ./mvnw clean package
2. Start the docker containers of the databases (PostgreSQL and MariaDB):

docker run -d --name postgres-db -p 5432:5432 -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=postgres -e POSTGRES_DB=usersdb postgres
docker run -d --name mariadb-db -p 3306:3306 -e MYSQL_USER=maria -e MYSQL_ROOT_PASSWORD=maria -e MYSQL_PASSWORD=maria -e MYSQL_DATABASE=ordersdb mariadb

1. Run the project in dev mode just to create the tables and insert some rows:

./mvnw compile quarkus:dev

1. Enter inside the /target folder and run the runnable jar passing all parameters:

java -jar -Dquarkus.datasource.users.jdbc.url=jdbc:postgresql://localhost:5432/usersdb -Dquarkus.datasource.users.username=postgres -Dquarkus.datasource.users.password=postgres -Dquarkus.datasource.orders.jdbc.url=jdbc:mariadb://localhost:3306/ordersdb -Dquarkus.datasource.orders.username=maria -Dquarkus.datasource.orders.password=maria poc-quarkus-multiple-datasources-1.0.0-SNAPSHOT-runner.jar

1. Enter inside the http://localhost:8080/swagger-ui , execute the tests and confirm everything is ok.

Now the problem.

1. I try to export just one variable with, like this one:

export QUARKUS_DATASOURCE_USERS_JDBC_URL=jdbc:postgresql://localhost:5432/usersdb 

1. Then I try to run the same command without this property ( quarkus.datasource."users".jdbc.url ), just to test:

java -jar -Dquarkus.datasource.users.username=postgres -Dquarkus.datasource.users.password=postgres -Dquarkus.datasource.orders.jdbc.url=jdbc:mariadb://localhost:3306/ordersdb -Dquarkus.datasource.orders.username=maria -Dquarkus.datasource.orders.password=maria poc-quarkus-multiple-datasources-1.0.0-SNAPSHOT-runner.jar

1. Quarkus ignore my environment variable and I receive this error:

WARN  [io.agr.pool] (main) Datasource 'users': Driver does not support the provided URL: prod-url

• prod-url is my default value:

quarkus.datasource."users".jdbc.url=${POSTGRESQL_URL:prod-url}

Now my workaround

As Quarkus isn’t reading the property variables with the datasource namespace, I’ve created the variables below:

quarkus.datasource."users".jdbc.url=${POSTGRESQL_URL:prod-url}
quarkus.datasource."users".username=${POSTGRESQL_USERNAME:prod-username}
quarkus.datasource."users".password=${POSTGRESQL_PASSWORD:prod-password}
quarkus.datasource."orders".jdbc.url=${MARIADB_URL:prod-url}
quarkus.datasource."orders".username=${MARIADB_USERNAME:prod-username}
quarkus.datasource."orders".password=${MARIADB_PASSWORD:prod-password}

For example:

1. I export the POSTGRESQL_URL:

export POSTGRESQL_URL=jdbc:postgresql://localhost:5432/usersdb 

1. Now I run the application without passing this variable ( quarkus.datasource."users".jdbc.url ) and everything works fine:

java -jar -Dquarkus.datasource.users.username=postgres -Dquarkus.datasource.users.password=postgres -Dquarkus.datasource.orders.jdbc.url=jdbc:mariadb://localhost:3306/ordersdb -Dquarkus.datasource.orders.username=maria -Dquarkus.datasource.orders.password=maria poc-quarkus-multiple-datasources-1.0.0-SNAPSHOT-runner.jar

I’m using this solution to run my real application inside Kubernetes. That is, instead of passing QUARKUS_DATASOURCE_USERS_JDBC_URL and the other variables, I’m passing this variables I’ve created, like POSTGRESQL_URL.