eMessage | 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 eMessage system tables in your network environment.
type
- Description
-
Type of database that hosts the eMessage 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 eMessage system tables. This is the same as the schema name for the 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 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 Campaign web server.
- Default value
-
No default value defined. You must define this property.
asmUserForDBCredentials
- Description
-
Use this property to specify an HCL® EMM user that will be allowed to access the eMessage system tables.
- Default value
-
No default value defined. You must define this property.
- Valid Values
-
Any user defined in the Marketing Platform. This should typically be the name of the system user for Campaign
amDataSourceForDBCredentials
- Description
-
Use this property to specify the data source that defines login credentials for the database that contains the eMessage system tables. This can be the same as the data source for the Campaign system tables.
- Default value
-
UA_SYSTEM_TABLES
- Valid Values
-
A Marketing Platform data source associated with the HCL EMM user you specify in asmUserForDBCredentials
The data source specifies a database user and credentials used to access the eMessage 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 eMessage creates for the system tables. eMessage 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 eMessage waits between testing idle connections to the eMessage system tables for activity.
- Default value
-
100
- Valid Values
-
An integer greater than 0.
poolMaxSize
- Description
-
The maximum number of connections eMessage 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 eMessage 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 eMessage 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 eMessage maintains an idle database connection before dropping the connection.
If poolIdleTestPeriod is greater than 0, eMessage 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.