Reject conditions
When you use the JDBC connector to write data to a JDBC data source, you can add a reject link to the JDBC Connector stage and send rejected records to the stage attached to the other end of the link. Reject conditions determine when a record is rejected.
You can set the following reject conditions:
- SQL error
- The driver reports an error when it tries to perform the write operation that is specified by the connector. This condition is applicable to all write modes.
- Row not inserted
- The specified INSERT statement was performed on the record, and the statement did not result in an error. However, no rows were inserted in the target table. This condition is applicable to the following write modes: Insert, Insert then update, Update then insert, Delete then insert, Insert new rows only.
- Row not updated
- The specified UPDATE statement was performed on the record, and the statement did not result in an error. However, no rows were updated in the target table. This condition is applicable to the following write modes: Update, Insert then update.
- Row not deleted
- The specified DELETE statement was performed on the record, and the statement did not result in an error. However, no rows were deleted from the target table. This condition is only applicable to the Delete write mode.
If a reject condition is selected with a write mode for which it is not applicable, the connector ignores the reject condition setting.