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

Highlighted
Seven Stars skh
Seven Stars

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

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

 

 

 


Accepted Solutions
Forteen Stars

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

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

-----------

All Replies
Forteen Stars

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

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

-----------
Seven Stars skh
Seven Stars

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

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

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch