My use case is, When my transformation is trying to insert a row to the table in Vertica DB where a field has exceeded the defined size.
What happens is that kettle throws java.sql.SQLDataException and aborts the job.
I understand that this can be handled in Data Validator, ignore those rows which has failed the condition in Data Validator.
However say in case if i missed to do Data Validation for a column, which will obviously escape and tries to insert that particular row in the table and throws the java.sql.SQLDataException.
What i would like to know is, is there way to handle such exceptions inside the transformation which will allow the transformation to keep running ignoring the rows with errors. Please suggest.