Turn off batch processing in Kettle?

2
votes

I am running a Pentaho Kettle transformation to insert into and update an Oracle 11g database that Kettle connects to using ODBC. When I run the transformation (or edit any of the database steps) I get the following message:

WARNING: Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.

Since I don't want to proceed if caution is needed, and I can't change the drivers I figure I better turn of the batch processing. How do I do that?

1
oracleoracle11gbatch-processingpentahokettle
Are you using table output transformation? - DUnkn0wn1
Yes, I am using table output, as well as insert / update. - Anders

1 Answers

2
votes

It's a tickbox in the step configuration "Use batch mode". If you don't see the tickbox on the particular step, then it's not relevant.

However why are you using ODBC? The batch mode works fine with the jdbc driver with oracle. Generally the batch mode is only an issue for MySQL, and only with specific driver versions (which is why its a warning)