topic Re: [resolved] tJavaFlex - multiple rows in Talend Studio

[resolved] tJavaFlex - multiple rows

_AnonymousUser — Sat, 16 Nov 2024 14:07:28 GMT

I needing return many rows from a tJavaFlex.
There are 2 components in the job: tJavaFlex and tLogRow.
There are 2 colunms in the schema: COD and DESC.

In the tJavaFlex:
Start code: connect to a data base, execute the SQL.
Main code: loop with the result.
row1.COD = return.col1;
row1.DESC = return.col1;
End code: disconnect to a data base

The connection and SQL execute are working very well, but the return of tJavaFlex is just one row (the last row). The result of SQL has many row.
How can I return many rows fom the tJavaFlex?

Re: [resolved] tJavaFlex - multiple rows

Anonymous — Fri, 12 Dec 2008 18:13:12 GMT

You have to switch the opening loop with the result to begin part
And don't forget to close your loop in end part.

Re: [resolved] tJavaFlex - multiple rows

_AnonymousUser — Mon, 15 Dec 2008 10:55:16 GMT

That it is!
Thank you very much!

Re: [resolved] tJavaFlex - multiple rows

_AnonymousUser — Tue, 21 Dec 2010 07:52:55 GMT

There are 2 components in the job: tJavaFlex and tLogRow.
There are 2 colunms in the schema: COD and DESC.

In the tJavaFlex:
Start code: connect to a data base, execute the SQL.
Main code: loop with the result.
row1.COD = return.col1;
row1.DESC = return.col1;
End code: disconnect to a data base

I do not know how to connect to an oracle database from tjavaflex.Can you help me?

Re: [resolved] tJavaFlex - multiple rows

_AnonymousUser — Fri, 28 Jan 2011 22:31:52 GMT

Thank you mhirt.
Your solution helped t oresolve my probelm

Re: [resolved] tJavaFlex - multiple rows

Anonymous — Tue, 03 Jan 2012 01:50:16 GMT

Why Error Message Talend Tjava not have function. I can't know what error it appeared. please help me