Integration Composer database properties
The database properties apply to all data sources: source, target, and repository.
| Property | Default Value | Description |
|---|---|---|
| mxe.db.maxRetryConnectionCount | 3 | Maximum number of attempts to establish or re-establish database connection. |
| mxe.db.waitTimeSeconds | 30 | Number of seconds between database reconnection attempts. |
| mxe.db.queryTimeoutSeconds | 1200 | Specifies the maximum number of seconds that the JDBC driver waits for a SQL SELECT statement to execute. |
| mxe.db.updateTimeoutSeconds | 1200 | Specifies the maximum
number of seconds that the JDBC driver waits for the following SQL
statements to execute:
|
| mxe.db.format.datetime | YYYY-MM-DD HH24:MI:SS | Indicates the format of the value of an Oracle DATETIME data type. |
| mxe.db.queryDepthLevel | 3 | A depth value for
each CI type. The depth specifies the number of classifications to
be included when importing actual CI data. By subtracting one from
the depth value, you can calculate:
|
| mxe.db.queryFetchSize | 500 | Reserved for future use. |
| mxe.db.queryCursorOn | false | Reserved for future use. |
| mxe.db.doBatchUpdate | true | This property determines whether Integration Composer queues SQL statements for the lowest level child class in a data schema tree and processes them in a batch. By default, the value is true, and Integration Composer processes the statements in a batch. |