Skip to main content

mysql error came  during writing how to fix 

error like:

JDBC_23 - Can't coerce ' ]' of type 'LIST' to column 'remarks' of JDBC type '-1'

 

@lakshmi_narayanan_t 

The error seems like there is mismatch in the data type.

Kindly elaborate in details or share your dummy pipeline for which you getting error, so I can help you on it.

 


@lakshmi_narayanan_t

The error seems like there is mismatch in the data type.

Kindly elaborate in details or share your dummy pipeline for which you getting error, so I can help you on it.

 

preview of my pipeline:

 


@lakshmi_narayanan_t 

kindly check if the multi row option is enabled in jdbc producer.

If yes , please uncheck it and retry to load data to jdbc.

Kindly let me know destination column name if possible so i can try to reproduce it in sdc to check on the issue.

 

Thanks & Regards

Bikram_


Reply