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

[mks02]

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.

[TRF]

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

[vapukov]

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

[Anonymous]

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

[JR1]

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.

[Anonymous]

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