Properties for Db2, Oracle, PostgreSQL
In the sandbox.cfg file, add or modify the properties of the database
that you are using, when customizing images.
Db2 properties
| Property | Value |
|---|---|
| jdbcService.db2Pool.dbvendor | db2 |
| jdbcService.db2Pool.systemPool | true |
| jdbcService.db2Pool.url | jdbc:db2://<db host>:<db port>/<db name> |
| jdbcService.db2Pool.catalog | <db name> |
| jdbcService.db2Pool.dbname | <db name> |
| jdbcService.db2Pool.user | <db user> |
| jdbcService.db2Pool.password | <db user pass> |
| jdbcService.db2Pool.schema | <db name> |
Oracle properties
| Property | Value |
|---|---|
| Database connection properties | |
| ORA_HOST | <oracle host name> |
| ORA_PORT | <oracle port number> |
| ORA_DATA | <Oracle service name/SID> |
| ORA_USER | <oracle user name> |
| ORA_PASS | <oracle user password> |
| DB_SCHEMA_OWNER | The default schema or schema-owner for the provided login ID. |
| Database transformation properties | |
| ORACLE | true Note: Replace the existing property
DB2=true. |
| JDBC_DRIVER | <complete path to ojdbc8.jar in runtime> |
| DB_DRIVERS | <complete path to ojdbc8.jar in runtime> |
| ORACLE_NLS_LENGTH_SEMANTICS | The type of length semantic to use for Oracle database for dbverify
tool.The valid values are CHAR or BYTE. The default value is BYTE. |
| JDBC_VENDOR | oracle |
| DB_VENDOR | Oracle |
| UI_DB_POOL | oracleUIPool |
| DB_POOL | oraclePool |
| ARCHIVE_DB_POOL | oracleArchivePool |
PostgreSQL properties
| Property | Value |
|---|---|
| Database connection properties | |
| DB_HOST | <PostgreSQL host name> |
| DB_PORT | <PostgreSQL port number> |
| DB_DATA | <PostgreSQL database name> |
| DB_USER | <PostgreSQL user name> |
| DB_PASS | <PostgreSQL user password> |
| DB_SCHEMA_OWNER | The default schema or schema-owner for the provided login ID. |
| Database transformation properties | |
| POSTGRESQL | true Note: Replace the existing property
DB2=true. |
| JDBC_DRIVER | <complete path to postgresql.jar in runtime> |
| DB_DRIVERS | <complete path to postgresql.jar in runtime> |
| DB_VENDOR | postgresql |
| UI_DB_POOL | postgresqlPool |
| DB_POOL | postgresqlPool |