Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

Six Stars

Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

Hi,
I am creating a table in SQL server and generating column datatype by using java code below: 
 
if ((context.Param_Name).equals("myDriver")){
 globalMap.put("COL1","BIGINT");
 }
 else
 {
globalMap.put("COL1","NUMBER");
}
And then inserting the data to SQL table. During the execution of this job, I am getting below error on Talend:
FACT_TABLE:tJDBCInput_1: java.sql.SQLException:Numeric overflow in conversion of value 2,444,017,960 to type INTEGER. - ABORT
My Table has only 2 coulmns: One is Prim_key which is generating sequentially and other one is taking data from COL1, defined in above code. 
Please help.

Regards,
Mohit
One Star

Re: Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

Hi,
The value exceeds the maximal value for the Java Integer datatype. 
No sure but think so.
Regards,
TRF
Thirteen Stars

Re: Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

Standard limit for INT :
from -2 147 483 648 till +2 147 483 648
2 444 017 960 - outside this limit, use long instead of INT
-----------
Four Stars

Re: Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

We are creating a table through JDBC query so we are using BIGINT., for the column.In tmap we are using long
Six Stars JR
Six Stars

Re: Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

During the extraction from the table (tJDBCInput_1), Talend ist trying to put the value into an Integer. Please review the schema in tJDBCInput_1 and verify that you selected "Long" (or "long") for the column in question. Unfortunately, there is nothing more anyone can say without additional information like screenshots.
Four Stars

Re: Error:Numeric overflow in conversion of value 2,444,017,960 to typeINT

Attaching the screen shot of problem part in job  as well as tjava query used in component .