Connector-specific configuration properties provide information needed by the connector at runtime. Connector-specific properties also provide a way of changing static information or logic within the connector without having to recode and rebuild it.
Table 16 lists the connector-specific configuration properties for the connector. See the sections that follow for explanations of the properties.
Name | Possible values | Default value | Required |
---|---|---|---|
ApplicationPassword | Password for connector user account |
Yes* |
|
ApplicationUserName | Name of connector user account |
Yes* |
|
ArchiveProcessed | true or false |
true |
No |
ArchiveTableName | Name of archive queue table |
xworlds_archive_events |
Yes if Archive Processed is true |
AutoCommit | true or false |
false |
No |
CheckforEventTableInInit | true or false |
true |
No |
ChildUpdatePhyDelete | true or false |
false |
No |
CloseDBConnection | true or false |
false |
No |
ConnectorID | Unique ID for the connector |
null |
No |
DatabaseURL | Name of the database server |
Yes |
|
DateFormat | A time pattern String |
MM/dd/yyyy HH:mm:ss |
No |
DisableLocaleFormatting | true or false | false | No |
DisableNumberFormtGrouping | true or false | false | No |
DriverConnectionProperties | Additional JDBC driver connection properties |
No |
|
DriverSupportForLong | true or false |
true |
No |
EventKeyDel | Delimiter character or characters for object key column of event table |
semicolon (;) |
No |
EventOrderBy |
none, ColumnName, ColumnName, ...] |
No |
|
EventQueryType | Fixed or Dynamic |
Fixed |
No |
EventTableName | Name of event queue table |
xworlds_events |
Yes, if polling is required; null (as a string) if polling is not required |
JDBCDriverClass | driver classname |
Yes |
|
MaximumDatabaseConnections | Number of simultaneous database connections |
5 |
Yes |
PingQuery |
SELECT 1 FROM <tablename> |
No |
|
PollQuantity | Values are 1 to 500 |
1 |
No |
PreparedStatementCacheSize | Maximum number of prepared statements to be cached for each connection in JDBC connection pool |
40 |
No |
PreserveUIDSeq | true or false |
true |
No |
QueryTimeOut | Integer value in seconds |
No |
|
RDBMS.initsession | SQL statement that initializes every database session |
No |
|
RDBMSVendor | DB2 |
Yes |
|
ReplaceAllStr | true or false |
false |
No |
ReplaceStrList | A set composed of a single character, a character delimiter, and the character's substitution string. Also, multiple such sets with a termination delimiter between them. | Q,DSQ Note: In the connector configuration tool, these characters represent a single quotation mark, followed by a comma, followed by two single quotation marks. |
No |
RetryCountAndInterval | Count, interval in seconds | 3,20 |
No |
ReturnDummyBOForSP | true or false |
false |
No |
SchemaName | Schema on which the events reside |
No |
|
SelectiveCommitForPoll | true or false |
false |
No |
SPBeforePollCall | Name of the stored procedure to be executed for each poll call |
No |
|
StrDelimiter | The character and termination delimiters used in the ReplaceStrList property |
,: |
No |
TimingStats | 0, 1, 2 |
0 |
No |
UniqueIDTableName | Name of table used for generation of IDs |
xworlds_uid |
No |
UseDefaults | true or false |
false |
Yes |
UseDefaultsForCreatingChildBOs | true or false |
false |
No |
UseDefaultsWhenPolling | true or false |
true |
No |
*ApplicationPassword and ApplicationUserName are not required if you are using trusted authentication. For i5/OS, when accessing i5/OS databases, the UserName and Password can be set to blank. i5/OS will then use the user profile the Adapter Job is running under to access the Application. The default user name can be changed by changing the Job Description object QWBIJDBCC in the QWBISVR44 library.