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,
Solved! Go to Solution.
Thanks vapukov for your Solution. I have changed the same in my design. Its working fine.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema