Interact | general | systemTablesDataSource
These configuration properties define the data source settings for the system tables for runtime environment. You must define this data source.
jndiName
- Description
-
Use this jndiName property to identify the Java™ Naming and Directory Interface (JNDI) data source that is defined in the application server (Websphere or WebLogic) for the runtime environment tables.
The runtime environment database is the database populated with the aci_runtime and aci_populate_runtime dll scripts and, for example, contains the following tables (among others): UACI_CHOfferAttrib and UACI_DefaultedStat.
- Default value
-
No default value defined.
type
- Description
-
The database type for the runtime environment system tables.
The runtime environment database is the database populated with the aci_runtime and aci_populate_runtime dll scripts and, for example, contains the following tables (among others): UACI_CHOfferAttrib and UACI_DefaultedStat.
- Default value
-
SQLServer
- Valid Values
-
SQLServer | DB2® | ORACLE | MARIADB
connectionRetryPeriod
- Description
-
The ConnectionRetryPeriod property specifies the amount of time in seconds Unica Interact automatically retries the database connection request on failure for the runtime system tables. Unica Interact automatically tries to reconnect to the database for this length of time before reporting a database error or failure. If the value is set to 0, Unica Interact will retry indefinitely; if the value is set to -1, no retry will be attempted.
The runtime environment database is the database populated with the aci_runtime and aci_populate_runtime dll scripts and, for example, contains the following tables (among others): UACI_CHOfferAttrib and UACI_DefaultedStat.
- Default value
-
-1
connectionRetryDelay
- Description
-
The ConnectionRetryDelay property specifies the amount of time in seconds Unica Interact waits before it tries to reconnect to the database after a failure for the Unica Interact runtime system tables. If the value is set to -1, no retry will be attempted.
The runtime environment database is the database populated with the aci_runtime and aci_populate_runtime dll scripts and, for example, contains the following tables (among others): UACI_CHOfferAttrib and UACI_DefaultedStat.
- Default value
-
-1
schema
- Description
-
The name of the schema containing the tables for the runtime environment. Unica Interact inserts the value of this property before all table names, for example, UACI_IntChannel becomes schema.UACI_IntChannel.
You do not have to define a schema. If you do not define a schema, Unica Interact assumes that the owner of the tables is the same as the schema. You should set this value to remove ambiguity.
- Default value
-
No default value defined.