Provide Oracle DB SID name from environment variables

[derifgig]

Hello.

I try deploy JasperServer by docker with Oracle DB type.
I build image successfully.

Started docker compose with:

    environment:
      DB_HOST: prod.ctb2tyzpbxjz.eu-west-1.rds.amazonaws.com
      DB_NAME: prod_db
      DB_PASSWORD: prod_password
      DB_PORT: '1521'
      DB_TYPE: oracle
      DB_USER: prod_user

In container logs I see:

[echo] Checking DBMS host and port:
[echo] About to validate port: prod.ctb2tyzpbxjz.eu-west-1.rds.amazonaws.com:1521
[echo]   Port 1521 is OK
[echo] Done validating port: prod.ctb2tyzpbxjz.eu-west-1.rds.amazonaws.com:1521
[echo] Validating administrative database connection at jdbc:tibcosoftware:oracle://prod.ctb2tyzpbxjz.eu-west-1.rds.amazonaws.com:1521;SID=ORCL. Phase: [test]
[echo] About to validate JDBC jar existence
[echo]   Look in: /usr/src/jasperreports-server/buildomatic/conf_source/db/oracle/jdbc
[echo]   Found jar file: assuming OK
[echo]   Jar or Jars found: TIoracle-6.0.0.000032.jar;jasperreports-pro-7.8.0.jar
[select-sql] Failed to connect: [TibcoSoftware][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ORCL) was not recognized by the Oracle server.
[echo] Connection failed:
[echo]   SQLState: 08001
[echo]   Vendor specific error code: 12505
[echo]   Message: [[TibcoSoftware][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ORCL) was not recognized by the Oracle server.]

My SID value for my Oracle DB is "PROD"

Problem: I can not define SID for Oracle database type in environment variables

Please fix me, if my conclusion is incorrect.

[bric-jim-rentschler]

Did you figure this out? I am having the same issue. Thanks

[derifgig]

I use the next approach:
Mount directory for docker service:

 volumes:
  - /jasper/deploy-customization:/usr/local/share/jasperserver-pro/deploy-customization

File in this directory:

$ ls -l  /jasper/deploy-customization/default_master_additional.properties 
-rw-r--r-- 1 root root 112 Nov 23 21:28 /jasper/deploy-customization/default_master_additional.properties

$ cat /jasper/deploy-customization/default_master_additional.properties
quartz.web.deployment.uri=https://jasper.domain.com/jasperserver-pro
sid=JASPER