Property | S/T | Description |
|---|---|---|
Batch Size | S | The number of source records the connector caches before processing them in a map. The default is zero, which means to read all. |
Port | ST | The integration platform uses the Derby database in client/server mode with the default port number (1527). You must use a non-standard port or a different server when using the Derby database in client/server mode. |
Additional Properties | ST | Name=value pairs that is required for the connection. Separate multiple pairs with semi colons. |
Show System Tables | S | Required. Only applicable if the user is logged onto the database as the database administrator. Only the DBA has access to s system tables. If set to True, allows you to see all the tables created by the DBA. The system table names appear in the table list. The default is False. |
Show Views | ST | If set to True (default), all views are displayed in the table list. |
Scrollability of Results | S | Required. Determines how to set result set. The three options: • Forward Only (default) - Result set is not scrollable. The system reads the next row in the result set. • Scrollable - Insensitive to changes - Result set is scrollable. The system can data read data forward or backward. Any changes to the result set that are made while it is open are not visible. • Scrollable - Sensitive to changes - Result set is scrollable. Any changes that are made to the result set while it is open are visible. |
Transaction Isolation | T | Allows you to specify any one of four isolation levels when reading from or writing to a Derby database table. The default value is Read Committed. The ANSI SQL 2 standard defines three specific ways in which serializability of a transaction may be violated: P1 (Dirty Read), P2 (Nonrepeatable Read), and P3 (Phantoms). The following lists the four supported isolation levels: • READ_UNCOMMITTED—Permits P1, P2, and P3. • READ_COMMITTED—Permits P2 and P3. Does not permit P1. • REPEATABLE_READ—Permits P3. Does not permit P1 and P2. • SERIALIZABLE—Does not permit P1, P2 or P3. |
Flush Frequency | T | Number of record inserts to buffer before sending a batch to the connector. Default is zero. If you are inserting many records, change the default to a higher value to improve performance. |
Batch Response | T | This property creates a batch response file, which serves as a reporting mechanism to the connector. The file provides detailed results for each object in a batch where the batch size is greater than 1. Obtaining detailed results is useful in the following cases: • Capturing system-generated object IDs for use in future updates. • Correlating an error with its object and have enough information about the error for exception handling and error diagnosis. For more information, see Batch Response File. |
Ignore Null Fields | T | If set to False (default), null values are included when updating records. If set to True, ignores null data values when updating records |