The pipeline sends the record to JDBC INSERT snap, under JDBC INSERT Snap account has auto commit is enabled and batch size is 60. if 180 records are streamed into JDBC INSERT Snap and there was an error in 140th record, how many records JDBC INSERT SNAP sending?
anyone can please respond on these.
Only the current executing batch will be rolled back if the Snap fails. In another words in your case it will be inserted 120 records.
You can always check the official documentation: