Provide Oracle DB SID name from environment variables #62
Description
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.