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

hami1 — Thu, 08 Jun 2017 07:31:16 GMT

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

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

vapukov — Thu, 08 Jun 2017 08:02:27 GMT

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

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

hami1 — Thu, 08 Jun 2017 08:38:05 GMT

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

topic Re: Error while Extracting data from BigInt Field of Table using tMysqlInput Component in Talend Studio

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

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

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