Hello

Context variable cannot be of an array type (or am I wrong?) and I didn't find any component that can be used that way.

Currently, there is not such a component can do that.
Why do you want to buffer some data bebore processing them in tJava? Can you show more detailed information and what are your expected result?

You can query and output the data to a Excel file, then extract data from specific Excel cells.
please read this [Forum, topic 970] Accessing specific Excel cells.
Hope it help you...

Best regards

         shong

From another point of view, you can see my problem as the sorting of a chained list that is extracted as a flow from a database.

Actually, I already tried this solution but I have an exception when I try to use in tJava the name I give to the array in the "destination" field. Is there an example of using tArray as an array for tJava ?

Hi, I tried using the syntax like in tArray_in but I got this error:

Exception in thread "Thread-1" java.lang.Error: Unresolved compilation problems:
    Structarray_tArray_1 cannot be resolved to a type

Then I tried this in my tJava:
java.util.ArrayList list_tArrayIn_1 = (java.util.ArrayList) globalMap.get("array_tArray_1");

for (int i = 0; i < list_tArrayIn_1.size(); i++) {
    System.out.println(list_tArrayIn_1.get(i));
}

and I got:
project.job.job$MINICIRCUITStruct@1a9334
project.job.job$MINICIRCUITStruct@b64435
project.job.job$MINICIRCUITStruct@37fb1e
project.job.job$MINICIRCUITStruct@1479feb
project.job.job$MINICIRCUITStruct@15212bc
project.job.job$MINICIRCUITStruct@14c1103
project.job.job$MINICIRCUITStruct@f11404
project.job.job$MINICIRCUITStruct@1592174
project.job.job$MINICIRCUITStruct@97a560
project.job.job$MINICIRCUITStruct@1ea5671
project.job.job$MINICIRCUITStruct@1d15445
project.job.job$MINICIRCUITStruct@1f3aa07
project.job.job$MINICIRCUITStruct@704baa
project.job.job$MINICIRCUITStruct@77a7f9
project.job.job$MINICIRCUITStruct@1b4fad5
project.job.job$MINICIRCUITStruct@bfea1d

I tried casting to string but I got a java exception. Any thougth about getting the values of the arraylist ?

Last edited by mlamrani (2008-05-15 10:20:36)

Is it possible to use a method that is defined in a tJava in another tjava ?

For the sorting, I want to match the extremities of the mini-circuits, and the tSort sort rows depending on 1 column ...

Actually I found a solution for the use of the array stored in the tArray. I put this code in the tJava:

java.util.ArrayList<MINICIRCUITStruct> mc = (java.util.ArrayList) globalMap.get("array_tArray_1");

MINICIRCUITStruct [] a = new MINICIRCUITStruct [topo.size()];
for (int i = 0; i < mc.size(); i++) {
    a[i] = mc.get(i);
}


and then I use the array "a" as I wish.

For the database insertion or update I use this:

java.sql.Connection conn = null;
conn = (java.sql.Connection) globalMap.get("conn_tMysqlConnection_1");
java.sql.PreparedStatement pstmt = null;

pstmt = conn.prepareStatement("<your query here>");
try {
    pstmt.execute();
} catch (Exception e) {
    System.err.print(e.getMessage());
}

if (pstmt != null) {
    pstmt.close();
}


Thanks for your help.


PS: I didn't find the path for code -> routines

Last edited by mlamrani (2008-05-19 14:24:27)

hi to all !
i'm having the same problem for bufferizing data!!!
i followed this example but without success

my data are extracted from a/some file/s , i elaborate this data, and then i want to use in other elaboration the last result...

i have
A----B     tFileExcelInput---tMap----tArray
B----C     tJava---tLogRow   (because the tArrayIn it doesn't work),


the tJava code

java.util.ArrayList<out_IStruct> mc = (java.util.ArrayList) globalMap.get("array_tArray_1");
out_IStruct[] a = new out_IStruct[mc.size()];
a = (out_IStruct[])mc.toArray(new out_IStruct[0]);

The result is:
||||||||||||||||||||

it seems that the tLogRow it doesn't filled up


if i make a System.out.println(a[0]);
i have the right result   

newColumn=I, newColumn1=CT, newColumn2=CRIS, newColumn3=NIO, newColumn4=CRSNA, newColumn5=null, newColumn6=null, newColumn7=null, newColumn8=null, newColumn9=90, newColumn10=90