Bulk Insert Error Handling

Bulk insert error handling is a feature that supports bulk insert operations. This feature improves data accuracy and processing efficiency as well as preventing data failure in the bulk insert operation.

Note

The bulk insert error handling feature restrictions are listed as follows: • Bulk insert error handling applies to Subscription Service only. • Bulk insert error handling can be implemented only when the java.sql.BatchUpdateException exception occurs. • Bulk insert error handling supports the Oracle database only. • Bulk insert error handling does not support Parent-Child message or Group message.

Without the bulk insert error handling feature, the agent inserts all rows (both correct and incorrect) into the exception table when the subscriber adapter performs the bulk insert operation.

For example, the agent attempts to perform a bulk insert of 500 rows to the destination table. If the first 300 rows are inserted successfully but the last 200 rows are not, the agent inserts the successful 300 rows to the destination table and the unsuccessful 200 rows to the exception table.

The following sections describe the prerequisites and work flow for using the bulk insert error handling feature.