Deliver | partitions | partition[n] | dataSources | systemTables
This category contains configuration properties that define the schema, connection settings, and login credentials for the database that contains the Unica Deliver system tables in your network environment.
type
- Description
-
Type of database that hosts the Unica Deliver system tables.
- Default value
-
No default value defined. You must define this property.
- Valid Values
-
-
SQLSERVER
-
ORACLE9
-
ORACLE10 (also used to indicate Oracle 11 databases)
-
DB2
-
schemaName
- Description
-
Name of the database schema for the Unica Deliver system tables. This is the same as the schema name for the Unica Campaign system tables.
You must include this schema name when referencing system tables in scripts.
- Default value
-
dbo
jdbcBatchSize
- Description
-
The number of execution requests JDBC runs on the database at a time.
- Default value
-
10
- Valid Values
-
An integer greater than 0.
jdbcClassName
- Description
-
JDBC driver for system tables as defined in your Unica Campaign web server.
- Default value
-
No default value defined. You must define this property.
jdbcURI
- Description
-
JDBC connection URI for system tables as defined in your Unica Campaign web server.
- Default value
-
No default value defined. You must define this property.
asmUserForDBCredentials
- Description
-
Use this property to specify an Unica user that will be allowed to access the Unica Deliver system tables.
- Default value
-
No default value defined. You must define this property.
- Valid Values
-
Any user defined in the Unica Platform. This should typically be the name of the system user for Unica Campaign
amDataSourceForDBCredentials
- Description
-
Use this property to specify the data source that defines login credentials for the database that contains the Unica Deliver system tables. This can be the same as the data source for the Unica Campaign system tables.
- Default value
-
UA_SYSTEM_TABLES
- Valid Values
-
A Unica Platform data source associated with the Unica user you specify in asmUserForDBCredentials
The data source specifies a database user and credentials used to access the Unica Deliver system tables. If the default schema for the database user is not the schema that contains the system tables you must specify the system table schema in the JDBC connection used to access the system tables.
poolAcquireIncrement
- Description
-
When the database connection pool runs out of connections, the number of new connections Unica Deliver creates for the system tables. Unica Deliver creates new connections up to the number specified in poolMaxSize.
- Default value
-
1
- Valid Values
-
An integer greater than 0.
poolIdleTestPeriod
- Description
-
The number of seconds Unica Deliver waits between testing idle connections to the Unica Deliver system tables for activity.
- Default value
-
100
- Valid Values
-
An integer greater than 0.
poolMaxSize
- Description
-
The maximum number of connections Unica Deliver makes to the system tables. A value of zero (0) indicates there is no maximum.
- Default value
-
100
- Valid Values
-
An integer greater than or equal to 0.
poolMinSize
- Description
-
The minimum number of connections Unica Deliver makes to the system tables.
- Default value
-
10
- Valid Values
-
An integer greater than or equal to 0.
poolMaxStatements
- Description
-
The maximum number of statements that Unica Deliver stores in the PrepareStatement cache per connection to the system tables. Setting poolMaxStatements to zero (0) disables statement caching.
- Default value
-
0
- Valid Values
-
An integer equal to or greater than 0.
timeout
- Description
-
The number of seconds Unica Deliver maintains an idle database connection before dropping the connection.
If poolIdleTestPeriod is greater than 0, Unica Deliver tests all idle, pooled, but unchecked-out connections, every timeout number of seconds.
If poolIdleTestPeriod is greater than timeout, the idle connections are dropped.
- Default value
-
100
- Valid Values
-
An integer equal to or greater than 0.