topic Re: [resolved] Outside valid range for the datatype TINYINT in tMySqlInput Component. in Talend Studio

[resolved] Outside valid range for the datatype TINYINT in tMySqlInput Component.

Anonymous — Sat, 16 Nov 2024 11:14:06 GMT

Hi All,
I'm extracting data from Mysql database and loading into csv file. One field turnaround datatype is TINYINT.
I used tMySqlInput and tfileoutputdelimetedfile components.When i run the job i'm getting below.
"Exception in component tMysqlInput_2
com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '178' in column '13' is outside valid range for the datatype TINYINT."
Thanks,
kumar

Re: [resolved] Outside valid range for the datatype TINYINT in tMySqlInput Component.

Anonymous — Mon, 11 May 2015 04:19:12 GMT

Hi,
A TINYINT will always have a size of one (1) byte. And accept values between -128 and 127 (if signed). Have you signed it? Is it working if you set it as "UNSIGNED"(0-255)?
Best regards
Sabrina

Re: [resolved] Outside valid range for the datatype TINYINT in tMySqlInput Component.

Anonymous — Tue, 12 May 2015 07:12:19 GMT

Thanks Sabrina,
I changed data type as integer.It's working fine.
Regards,
kumar.talend

Re: [resolved] Outside valid range for the datatype TINYINT in tMySqlInput Component.

Anonymous — Tue, 12 May 2015 09:21:11 GMT

Hi kumar.talend,
Thanks for your feedback. Could you please mark this topic as resolved?
Best regards
Sabrina