Appendix B. Connector-specific configuration properties

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.

Table 16. Connector-specific configuration 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.

Copyright IBM Corp. 2004, 2005