Error while Extracting data from BigInt Field of Table using tMysqlInput Component

[hami1]

Hi Guys ,

I am facing the Error while extracting the data from Mysql Table BigInt Column using tMysqlInput Component.

The Column datatype is :  course_id` bigint(30) unsigned NOT NULL

It has the records with 11-digit Number, Eg : 30001000008. If I try to return only 10-digits from this number, then its returning without any error. But when I tried to return the total number (in my case 11-digit) it returns the following Error as show below.

Exception in component tMysqlInput_2
com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.0001000001E10' in column '1' is outside valid range for the datatype INTEGER.

Is it requires any Extra-Settings in Additional JDBC Parameters Option to work around on this.

I am using Talend Open Studio 5.5.0 Version, CentOS.

Thanks In Advance,

hmd

[vapukov · Accepted solution]

BigInt in MySQL equal to Long in Java (Talend), so change type in All components from Integer to Long

[hami1]

Thanks vapukov for your Solution. I have changed the same in my design. Its working fine.