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 15 lists the connector-specific configuration properties for the connector. See the sections that follow for explanations of the properties.

Table 15. 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
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
PreserveUIDSeq true or false
true
No
QueryTimeOut Integer value in seconds

No
RDBMS.initsession SQL statement that initializes every database session

No
RDBMSVendor DB2, MSSQLServer, Oracle, Others

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.

Copyright IBM Corp. 1997, 2004