topic Re: tJavaRow not working as expected in Talend Studio

tJavaRow not working as expected

MKAPOOR1596038160 — Wed, 30 Sep 2020 12:58:33 GMT

I am using tJavaRow in TOS where in i am using following code to sort string: "gnbsx00061 gnbsx00063 gnx10326"

In tJAVARow : After sorting it results in "gnx10326 gnbsx00061 gnbsx00063"

String [] licsvr = input_row.lic_server_name.split(" ");

java.util.Arrays.sort(licsvr);

output_row.lic_server_name = java.util.Arrays.toString(licsvr).replace(",", "").replace("[", "").replace("]", "");

While if i run the same following java code in test.java file on standalone linux machine

import java.util.*;

public class test {

public static void main(String[] args) {

String p = "gnx10326 gnbsx00061 gnbsx00063";

String [] licsvr = p.split(" ");

java.util.Arrays.sort(licsvr);

System.out.println(java.util.Arrays.toString(licsvr).replace(",", "").replace("[", "").replace("]", ""));

}

running it results in :

java test

gnbsx00061 gnbsx00063 gnx10326

The linux java program output is what i am expecting. please help?

Re: tJavaRow not working as expected

root — Wed, 30 Sep 2020 15:44:02 GMT

Probably try it in tJava component instead of the tJavaRow and do the operations? Thanks

Re: tJavaRow not working as expected

Jesperrekuh — Wed, 30 Sep 2020 15:44:06 GMT

System.out.println( input_row.lic_server_name ) ;

To make sure it contains values?

Re: tJavaRow not working as expected

MKAPOOR1596038160 — Wed, 30 Sep 2020 16:04:14 GMT

tJavaRow in my design a part of flow and i transform one field using tJavaRow. How can i use tJava in this scenario?

Re: tJavaRow not working as expected

MKAPOOR1596038160 — Wed, 30 Sep 2020 16:15:47 GMT

Another point to highlight is that tJavaRow is doing sorting correctly in cases like

"gnbsx00016 gnbsx00013 gnbsx00014" gets transformed correctly with tJavaRow to "gnbsx00013 gnbsx00014 gnbsx00016".

But in case of gnbsx00063 gnbsx00061 gnx10326, it is unable to sort correctly by transforming it to "gnx10326 gnbsx00061 gnbsx00063" .

The expectation is to sort them in order of alphabetically first then numerically second but it is not happening with tJavaRow.

Re: tJavaRow not working as expected

pakapi_ — Thu, 01 Oct 2020 08:39:59 GMT

Hi MKAPOOR1596038160,

you are 100% sure that your tjavaRow sorting result is gnx10326 gnbsx00061 gnbsx00063 ?

I've tested your both codes and got the same result: gnbsx00061 gnbsx00063 gnx10326.

You are using the same method java.util.Arrays.sort so for me - it's not possible to get diffrent results.

My tJava version:

String p = "gnx10326 gnbsx00061 gnbsx00063";

String[] licsvr = p.split(" ");

java.util.Arrays.sort(licsvr);

System.out.println(java.util.Arrays.toString(licsvr).replace(",", "").replace("[", "").replace("]", ""));

tJavaRow version:

input: gnx10326 gnbsx00061 gnbsx00063

String [] licsvr = input_row.lic_server_name.split(" ");

java.util.Arrays.sort(licsvr);

output_row.lic_server_name = java.util.Arrays.toString(licsvr).replace(",", "").replace("[", "").replace("]", "");

Re: tJavaRow not working as expected

MKAPOOR1596038160 — Thu, 01 Oct 2020 09:58:39 GMT

I got this issue solved after replacing openjdk with oracle java and the version to 1.8.0.05.

Thanks a lot for your help.