on 07-12-2015 9:33 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.