When using a JDBC Producer destination with Multi-Row Operation enabled, the following error is thrown:
JDBC_14 - Error processing batch: [SQLState:S0001][ErrorCode:103010] Parse error at line: 1, column: 58: Incorrect syntax near ','. SQLState: S0001 Error Code: 103010 Message: Parse error at line: 1, column: 58: Incorrect syntax near ','.
This error is the result of certain databases not supporting the underlying SQL statements made by the JDBC Producer when this setting is enabled.
For example, for Multi-Row inserts, the JDBC Producer uses the following SQL statement:
INSERT INTO <table name> (<col1>, <col2>, <col3>)
VALUES (<record1 field1>,<record1 field2>,<record1 field3>),
(<r2 f1>,<r2 f2>,<r2 f3>), (<r3 f1>,<r3 f2>,<r3 f3>),...;
If the database does not support such statements, it will result in the error message shown above. It is recommended to verify support for these statements before enabling this feature.
To fix this error, navigate to the ‘JDBC’ tab on the JDBC Producer stage, and disable the setting for ‘Use Multi-Row Operation’.