Sender adaper JDBC error DATA too long

[Former Member]

HI Exports,

i got below error for jdbc sender adapter.

Database-level error reported by JDBC driver while executing statement 'CALL proc_dtdc_cod_fod_interface'. The JDBC driver returned the following error message: 'com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'CDS_NUM' at row 54'. For details, contact your database server vendor.

Please suggest  to solve this errror.

[azharshaikh]

Hello Raj,

Seems issue with the Data that is being sent. Can you check with DB team what is the data being sent for CDS_NUM and its length. It sud conform to the Data Type field length that you have defined in ESR.

1. Either correct the data being sent OR

2. Update the field length

Regards,

Azhar

[Former Member]

hi

we are not maintained any length and DB side also not having more than 12 length.

and it is not a mandatory field.

Please suggest with any other reason.

TY

[iaki_vila]

Hi RajiReddy,

Even if you have not set any long in your DB SP parameters the DB types have a maximum length. For example, check this link java - Data truncation: Data too long for column 'logo' at row 1 - Stack Overflow

Regards.