Get value after every n counts

[Anonymous]

Hi,

I get the max(ID) from the table which is BigDecimal(7,0). This value I am passing to tJavaRow component to assign the value to globalMap as below:
globalMap.put("startID", "1");
globalMap.put("endID", String.valueOf(row1.maxID));
globalMap.put("rowsToProcess", "40000000" );

OnComponentOK, connecting to tLoop component where the For loop is chosen as below:

From - 1

To - Integer.parseInt(globalMap.get("endID").toString())

Step - Integer.parseInt(globalMap.get("rowsToProcess").toString())

This raises NumberFormatException. 

java.lang.NumberFormatException: For input string: "4979013401".

Is there any other way to generate value from start id to end id every n'th value.

Thanks.

[TRF · Accepted solution]

Max value for an integer is 2,147,483,647...

[akumar2301]

4979013401 is higher than above maximum possible value for Int 

Instead try Long but you have to use While Loop instead of For( doesnot support Long)

start condition

 Long i = 0L

[Anonymous]

Hi TRF,

System.out.println((Long)globalMap.get("tLoop_1_CURRENT_VALUE")); is returning NULL in tJava component.

How do I get the tLoop value ?

Thanks.

[Anonymous]

Hi,

System.out.println((Long)globalMap.get("tLoop_1_CURRENT_VALUE")); is returning NULL in tJava component.

How do I get the tLoop value ?

Thanks.

[Anonymous]

Hi,

System.out.println((Long)globalMap.get("tLoop_1_CURRENT_ITERATION"));

globalMap.get("tLoop_1_CURRENT_ITERATION") is by default Integer. 

int current_iteration_tLoop_1 = 0;

How would it transfer Long value?

Is there any other way to achieve this?

Thanks.

[akumar2301]

Hmm , If you need to use counter value in long
Immediately after tloop put a tjava and create a your own long globalmap
counter and use that custom value in your subjob