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.