This section describes the properties related to Oracle, PostgreSQL, and SAP HANA related properties that you can set.
Derby
These The following properties are applicable for to the Derby database.
Property | Description |
---|---|
derby.restore.path | Default value: Set this property to set the Derby restore directory. |
Oracle
These The following properties are applicable for to the Oracle database.
These settings are used by the Platform for the connection towards the Platform database, and for ECs for connections towards external databases.
Property | Description |
---|---|
oracle.pool.connectionwaittimeout | Default value: The number of seconds to wait for a free connection if the pool has reached max-connections used. |
oracle.pool.maxlimit | Default value: Maximum number of connections in the pool. Should It should be set to no less than "3". A usual setting would be about 10 to 100. The default value "-1" means that the number of connections is unlimited. |
...
More information about Oracle Advanced Security can be found in the Oracle Database Advanced Security Administrator's Guide.
Note |
---|
Note!MediationZone only supports Oracle Advanced Security for Oracle 12.2. |
Property | Description | ||
---|---|---|---|
oracle.net.encryption_client | The level of security of the client that will connect to the Oracle database is determined with this parameter. Accepted values include, REJECTED, ACCEPTED, REQUESTED, and REQUIRED.
| ||
oracle.net.encryption_types_client | The encryption algorithm to be used is determined with this parameter. | ||
oracle.net.crypto_checksum_client | The level of security when it comes to regarding data integrity for the connection with the Oracle database is determined with this parameter. Accepted values include, REJECTED, ACCEPTED, REQUESTED, and REQUIRED.
| ||
oracle.net.crypto_checksum_types_client | The data integrity algorithm to be used is determined with this parameter. |
PostgreSQL
These The following properties are applicable for to the PostgreSQL database.
These settings are used by the Platform for the connection towards the Platform database, and for ECs for connections towards external databases.
Property | Description |
---|---|
postgresql.connectionpool.defaultQueryTimeout | Default value: 300 Sets the maximum allowed duration in ms of any statement. |
postgresql.connectionpool.maxlimit | Default value: Maximum number of connections in the pool for the PostgreSQL database. Should It should be set to no less than the sum of the values of postgresql.connectionpool.maxlimit configured for Platform and database profiles connecting to this database. These settings are used by the Platform for the connection towards the Platform database . Can and can also be used for ECs connections towards external databases and it is set on Database profile level. |
The following settings are used by the PostgreSQL Database for the connection to MediationZone, and are stored in the postgresql.conf
file in the server that is hosting the PostgreSQL database.
...
Code Block |
---|
$ psql postgres=# ALTER SYSTEM SET max_connections = 110; ALTER SYSTEM |
Property | Description |
---|---|
max_connections | Default value: Maximum number of connections in the pool for the PostgreSQL database. Should It should be set to no less than the value in set for postgresql.connectionpool.maxlimit. |
shared_buffers | Default value: Amount of memory (in MB) for caching data that should be dedicated to the PostgreSQL database. |
effective_cache_size | Default value: Amount of memory (in MB) for disk caching. The recommended effective size should be set to 1/2 of the total memory of the server. |
work_mem | Default value: Memory (in MB) for performing in-memory complex sorts in the database. |
random_page_cost | Default value: Multiplier value for determining the length of time it takes for the disk to seek a random disk page. |
...
The following properties are applicable for to the SAP HANA database.
These settings are used by the Platform for the connection towards the MediationZone database, and by ECs for connections towards external databases.
...